public int? insertUpdate(DridDataObj obj) { int? iReturn = 0; ctx.spUpdateInsertProduct(obj.ProductID, obj.ProductName, obj.UnitPrice, obj.UnitsInStock, obj.Discontinued, obj.Category, ref iReturn); if (iReturn >= 0) return iReturn; else return null; }
public void Update(string models) { JavaScriptSerializer jSerializer = new JavaScriptSerializer(); IList<DridDataObj> persons = new JavaScriptSerializer().Deserialize<IList<DridDataObj>>(models); DridDataObj temp = new DridDataObj(); foreach (DridDataObj m in persons) { temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice, UnitsInStock = m.UnitsInStock, Discontinued = m.Discontinued, Category = m.Category, CreatedDate = m.CreatedDate, Duration = 20 }; } temp.ProductID = PM.insertUpdate(temp); temp.UniqueCode = PM.getUniqueCodeById(temp.ProductID.Value); //return temp; Context.Response.Write(jSerializer.Serialize(temp)); }
public void ReadPureJson() { DemoVS4.Core.DAL.dbTestDataContext ctx = new Core.DAL.dbTestDataContext(); List<DemoVS4.Core.DAL.Product> List = ctx.Products.ToList(); List<DridDataObj> TempList = new List<DridDataObj>(); foreach (DemoVS4.Core.DAL.Product m in List) { DridDataObj temp = new DridDataObj(); temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice.Value, UnitsInStock = m.UnitsInStock.Value, Discontinued = m.Discontinued.Value, Category = m.Category, CreatedDate = m.CreatedDateTime.Value, Duration = 20 }; TempList.Add(temp); } Context.Response.Write(jSerializer.Serialize(TempList)); }
public int?insertUpdate(DridDataObj obj) { int?iReturn = 0; ctx.spUpdateInsertProduct(obj.ProductID, obj.ProductName, obj.UnitPrice, obj.UnitsInStock, obj.Discontinued, obj.Category, ref iReturn); if (iReturn >= 0) { return(iReturn); } else { return(null); } }
public List<DridDataObj> ReadProduct(string AnyThing) { DemoVS4.Core.DAL.dbTestDataContext ctx = new Core.DAL.dbTestDataContext(); List<DemoVS4.Core.DAL.Product> List = ctx.Products.ToList(); List<DridDataObj> TempList = new List<DridDataObj>(); foreach (DemoVS4.Core.DAL.Product m in List) { DridDataObj temp = new DridDataObj(); temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice.Value, UnitsInStock = m.UnitsInStock.Value, Discontinued = m.Discontinued.Value, Category = m.Category, CreatedDate = m.CreatedDateTime.Value, Duration = 20 }; TempList.Add(temp); } // return jSerializer.Serialize(TempList); return TempList; }
public JsonResult GetJsonOutputForGridDataUpdateIncell(string models) { JavaScriptSerializer jSerializer = new JavaScriptSerializer(); IList<DridDataObj> persons = new JavaScriptSerializer().Deserialize<IList<DridDataObj>>(models); List<DridDataObj> tempItems = new List<DridDataObj>(); foreach (DridDataObj m in persons) { DridDataObj temp = new DridDataObj(); temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice, UnitsInStock = m.UnitsInStock, Discontinued = m.Discontinued, Category = m.Category, CreatedDate = m.CreatedDate, Duration = 2 }; temp.ProductID = PM.insertUpdate(temp); temp.UniqueCode = PM.getUniqueCodeById(temp.ProductID.Value); tempItems.Add(temp); } return Json(tempItems); }
public JsonResult GetJsonOutputForGridDataUpdatePopup(string models) { JavaScriptSerializer jSerializer = new JavaScriptSerializer(); DridDataObj m = new JavaScriptSerializer().Deserialize<DridDataObj>(models); DridDataObj temp = new DridDataObj(); temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice, UnitsInStock = m.UnitsInStock, Discontinued = m.Discontinued, Category = m.Category, CreatedDate = m.CreatedDate }; temp.ProductID = PM.insertUpdate(temp); temp.UniqueCode = PM.getUniqueCodeById(temp.ProductID.Value); /* DemoVS4.Core.DAL.Product l = ctx.Products.Where(x => x.ProductID == 3).FirstOrDefault(); if (l != null) { l.UnitPrice = 50; ctx.SubmitChanges(); } */ return Json(temp); }
public JsonResult GetJsonOutputForGridDataDeletePopup(string models) { JavaScriptSerializer jSerializer = new JavaScriptSerializer(); DridDataObj m = new JavaScriptSerializer().Deserialize<DridDataObj>(models); DridDataObj temp = new DridDataObj(); temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice, UnitsInStock = m.UnitsInStock, Discontinued = m.Discontinued, Category = m.Category, CreatedDate = m.CreatedDate }; PM.DeleteRecordById(temp.ProductID); return Json(new { value = "success" }); }
public JsonResult GetJsonOutputForGridDataCreatePopup(string models) { JavaScriptSerializer jSerializer = new JavaScriptSerializer(); DridDataObj m = new JavaScriptSerializer().Deserialize<DridDataObj>(models); DridDataObj temp = new DridDataObj(); temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice, UnitsInStock = m.UnitsInStock, Discontinued = m.Discontinued, Category = m.Category, CreatedDate = m.CreatedDate }; temp.ProductID = PM.insertUpdate(temp); temp.UniqueCode = PM.getUniqueCodeById(temp.ProductID.Value); return Json(temp); }
public void Delete(string models) { JavaScriptSerializer jSerializer = new JavaScriptSerializer(); IList<DridDataObj> persons = new JavaScriptSerializer().Deserialize<IList<DridDataObj>>(models); DridDataObj temp = new DridDataObj(); foreach (DridDataObj m in persons) { temp = new DridDataObj { ProductID = m.ProductID, ProductName = m.ProductName, UnitPrice = m.UnitPrice, UnitsInStock = m.UnitsInStock, Discontinued = m.Discontinued, Category = m.Category, CreatedDate = m.CreatedDate }; } PM.DeleteRecordById(temp.ProductID); Context.Response.Write(jSerializer.Serialize(temp)); }