public static void UpdateEntry(string sData) { AspProdNet.Modals.supplier oEntry = JsonConvert.DeserializeObject<AspProdNet.Modals.supplier>(sData); using (var dbContext = new aspet_devEntities()) { dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } }
public static void SaveEntry(string sData) { MaterialEntry oEntry = JsonConvert.DeserializeObject<MaterialEntry>(sData); using (var dbContext = new aspet_devEntities()) { dbContext.MaterialEntries.Add(oEntry); dbContext.SaveChanges(); } }
public static void SaveTruck(string sData) { truck otruck = JsonConvert.DeserializeObject<truck>(sData); using (var dbContext = new aspet_devEntities()) { dbContext.trucks.Add(otruck); dbContext.SaveChanges(); } }
public static void SaveEntry(string sData) { supplier oEntry = JsonConvert.DeserializeObject<supplier>(sData); using (var dbContext = new aspet_devEntities()) { dbContext.suppliers.Add(oEntry); dbContext.SaveChanges(); } }
public static void SaveEntry(string sData, string sHandData) { Production oEntry = JsonConvert.DeserializeObject<Production>(sData); List<ProdHandling> olstHdn = JsonConvert.DeserializeObject < List<ProdHandling>>(sHandData); using (var dbContext = new aspet_devEntities()) { dbContext.Productions.Add(oEntry); dbContext.SaveChanges(); dbContext.Entry(oEntry).GetDatabaseValues(); foreach (ProdHandling ohdn in olstHdn) { ohdn.wProductionId = oEntry.wProductionId; } dbContext.ProdHandlings.AddRange(olstHdn); dbContext.SaveChanges(); } }
public static void DeleteEntry(string sData) { AspProdNet.Modals.ResinMoistrRpt oEntry = JsonConvert.DeserializeObject<AspProdNet.Modals.ResinMoistrRpt>(sData); using (var dbContext = new aspet_devEntities()) { dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Deleted; // dbContext.RawMaterials.Remove(dbContext.Entry(oEntry)); dbContext.SaveChanges(); } }
public static void SaveEntry(string sData) { User oEntry = JsonConvert.DeserializeObject<User>(sData); using (var dbContext = new aspet_devEntities()) { oEntry.timestamp = DateTime.Now; dbContext.Users.Add(oEntry); dbContext.SaveChanges(); } }
public static void UpdateEntry(string sData) { AspProdNet.Modals.ResinMoistrRpt oEntry = JsonConvert.DeserializeObject<AspProdNet.Modals.ResinMoistrRpt>(sData); using (var dbContext = new aspet_devEntities()) { oEntry.wDateTime = DateTime.Now; oEntry.Status = 0; dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } }
public static void SaveEntry(string sData) { AspProdNet.Modals.ResinMoistrRpt oEntry = JsonConvert.DeserializeObject<AspProdNet.Modals.ResinMoistrRpt>(sData); using (var dbContext = new aspet_devEntities()) { oEntry.wDateTime = DateTime.Now; oEntry.Status = 0; dbContext.ResinMoistrRpts.Add(oEntry); dbContext.SaveChanges(); } }
public static void SaveEntry(string sData, string sHandData) { VisualReport oEntry = JsonConvert.DeserializeObject<VisualReport>(sData); List<VCavity> olstHdn = JsonConvert.DeserializeObject<List<VCavity>>(sHandData); using (var dbContext = new aspet_devEntities()) { oEntry.Date = DateTime.Now; dbContext.VisualReports.Add(oEntry); dbContext.SaveChanges(); dbContext.Entry(oEntry).GetDatabaseValues(); foreach (VCavity ohdn in olstHdn) { ohdn.wVisualId = oEntry.wVisualId; } dbContext.VCavities.AddRange(olstHdn); dbContext.SaveChanges(); } }
public static void DeleteEntry(string sData) { AspProdNet.Modals.VisualReport oEntry = JsonConvert.DeserializeObject<AspProdNet.Modals.VisualReport>(sData); using (var dbContext = new aspet_devEntities()) { dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Deleted; // dbContext.PackingMaterials.Remove(dbContext.Entry(oEntry)); dbContext.VCavities.Where(obj => obj.wVisualId == oEntry.wVisualId).ToList().ForEach(olst => { dbContext.Entry(olst).State = System.Data.Entity.EntityState.Deleted; }); dbContext.SaveChanges(); } }
public static string SaveBrands(string sBrand) { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { Brand oBrand = new Brand(); oBrand.Name = sBrand; dbContext.Brands.Add(oBrand); dbContext.SaveChanges(); dbContext.Entry(oBrand).GetDatabaseValues(); sReturn = oBrand.wBrandId.ToString(); } return sReturn; }
public static string SaveSupplier(string sBrand) { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { supplier oBrand = new supplier(); oBrand.sSupplier = sBrand; dbContext.suppliers.Add(oBrand); dbContext.SaveChanges(); dbContext.Entry(oBrand).GetDatabaseValues(); sReturn = oBrand.wSupplierId.ToString(); } return sReturn; }
public static void UpdateEntry(string sData, string sHandData) { AspProdNet.Modals.VisualReport oEntry = JsonConvert.DeserializeObject<AspProdNet.Modals.VisualReport>(sData); List<VCavity> olstHdn = JsonConvert.DeserializeObject<List<VCavity>>(sHandData); using (var dbContext = new aspet_devEntities()) { dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Modified; foreach (VCavity oCav in olstHdn) { dbContext.Entry(oCav).State = System.Data.Entity.EntityState.Modified; } dbContext.SaveChanges(); } }
public static void SaveEntry(string sData) { BagConsumption oEntry = JsonConvert.DeserializeObject<BagConsumption>(sData); string sType = oEntry.sType; using (var dbContext = new aspet_devEntities()) { if (sType == "Raw") { Modals.RawMaterial oData = dbContext.RawMaterials.Where(x => x.wMaterialId == oEntry.wMaterialId).SingleOrDefault(); oData.Status = 1; dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Modified; } else if (sType == "Packing") { PackingMaterial oData = dbContext.PackingMaterials.Where(x => x.wPackingId == oEntry.wMaterialId).SingleOrDefault(); oData.Status = 1; dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Modified; } else if (sType == "Clrs") { Modals.Color oData = dbContext.Colors.Where(x => x.wColorId == oEntry.wMaterialId).SingleOrDefault(); oData.Status = 1; dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Modified; } else if (sType == "Others") { MaterialOther oData = dbContext.MaterialOthers.Where(x => x.wOtherId == oEntry.wMaterialId).SingleOrDefault(); oData.Status = 1; dbContext.Entry(oEntry).State = System.Data.Entity.EntityState.Modified; } oEntry.date = DateTime.Now; dbContext.BagConsumptions.Add(oEntry); dbContext.SaveChanges(); } }