ASP.NET

TestKendoGrid.asmx/Update

[WebMethod]
public static void Update(Person pIn) {
	//updates an existing Person entity with new values, and saves to the database
	using (SandboxEntities e = new SandboxEntities()) {
		//there should be only one (by definition of PK)
		//but using "First()" is safe in case there is more than one
		Person pUpdate = (Person)(from p in e.People where p.ID == pIn.ID select p).First();
 
		pUpdate.Phone = pIn.Phone;
		pUpdate.FirstName = pIn.FirstName;
		pUpdate.LastName = pIn.LastName;
 
		e.SaveChanges();
	}
}

{
    "__type": "TestWebSite.Person",
    "ID": 5,
    "LastName": "Adamson",
    "FirstName": "Danielle",
    "Phone": "303-555-1212",
    "EntityState": 2,
    "EntityKey": {
        "EntitySetName": "People",
        "EntityContainerName": "SandboxEntities",
        "EntityKeyValues": [
            {
                "Key": "ID",
                "Value": 5
            }
        ],
        "IsTemporary": false
    }
}

var svcURL = "SandboxService.asmx";

$(document).ready(function () {
	$("#PeopleGrid").kendoGrid({
		columns: ["LastName", "FirstName", "Phone"],
		dataSource: {
			transport: {
				read: {
					type: "POST",
					url: svcURL + "/Read",
					contentType: "application/json; charset=utf-8",
					dataType: "json"
				},
				create: {
					type: "POST",
					url: svcURL + "/Create",
					contentType: "application/json; charset=utf-8",
					dataType: "json",
					data: function (data) { return { P: data }; }
				},
				update: {
					type: "POST",
					url: svcURL + "/Update",
					contentType: "application/json; charset=utf-8",
					dataType: "json",
					data: function (data) { return { P: data }; }
				},
				parameterMap: function (data, type) {
					return kendo.stringify(data);
				}
			},
			schema: {
				data: "d",
				columns: ["ID", "LastName", "FirstName", "Phone"],
				model: {
					id: "ID",
					fields: {
						LastName: {
							editable: true,
							nullable: false
						},
						FirstName: {
							editable: true,
							nullable: false
						},
						Phone: {
							editable: true,
							nullable: false
						}
					}
				}
			},
			batch: false
		},
		editable: {
			update: true,
			create: true,
			destroy: false
		},
		toolbar: ["create", "save", "cancel"]
	})
});

using System.Web.Services;
using System.Web.Script.Services;
using System.ComponentModel;
using System.Collections.Generic;
using System.Linq;

namespace TestWebSite {
	/// <summary>
	/// This service does basic CRUD on the Sandbox data
	/// </summary>
	[WebService(Namespace = "http://tempuri.org/")]
	[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
	[ScriptService]
	public class SandboxService : System.Web.Services.WebService {
		[WebMethod]
		public List<Person> Read() {
			//Reads the People entity from the database
			using (SandboxEntities entity = new SandboxEntities()) {
				var q = from p in entity.People select p;

				return q.ToList<Person>();
			}
		}

		[WebMethod]
		public void Create(object P) {
			//Creates a new Person entity and saves it to the database
			if (P is Person) {
				using (SandboxEntities e = new SandboxEntities()) {
					e.AddToPeople((Person)P);
					e.SaveChanges();
				}
			}
		}

		[WebMethod]
		public void Update(object P) {
			//updates an existing Person entity with new values, and saves to the database
			if (P is Person) {

				using (SandboxEntities e = new SandboxEntities()) {
					//there should be only one (by definition of PK)
					//but using "First()" is safe in case there is more than one
					Person pUpdate = (Person)(from p in e.People where p.ID == ((Person)P).ID select p).First();

					pUpdate.Phone = ((Person)P).Phone;
					pUpdate.FirstName = ((Person)P).FirstName;
					pUpdate.LastName = ((Person)P).LastName;

					e.SaveChanges();
				}
			}
		}
	}
}

AspDotNetDev wrote:

but wouldn't you just have to link to the social network with a query string value to the page you intend to like/share

Jassim Rahma wrote:

Also reporting to be saved in a databas

Jassim Rahma wrote:

Also reporting to be saved in a database so Ican show each usur share report for his pages only.