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();
}
}
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 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 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 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, 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 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 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();
}
}
