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 SaveEntry(string sData) { supplier oEntry = JsonConvert.DeserializeObject<supplier>(sData); using (var dbContext = new aspet_devEntities()) { dbContext.suppliers.Add(oEntry); dbContext.SaveChanges(); } }
public static string LoadData() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { var oList = dbContext.trucks.OrderByDescending(obj => obj.wTruckId).ToList(); sReturn = JsonConvert.SerializeObject(oList); } return sReturn; }
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 string GetBrands() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { var oList = dbContext.Brands.ToList(); sReturn = JsonConvert.SerializeObject(oList); } return sReturn; }
public static string GetShiftIncharges() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { List<User> olstShiftIncharge = dbContext.Users.Where(ouser => ouser.wRoleId <= 2 || ouser.wRoleId == 5).ToList(); sReturn = JsonConvert.SerializeObject(olstShiftIncharge); } return sReturn; }
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 string GetSupervisors() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { List<User> olst = dbContext.Users.Where(ouser => ouser.wRoleId <= 3 || ouser.wRoleId == 3).ToList(); sReturn = JsonConvert.SerializeObject(olst); } return sReturn; }
public static string GetSupplier() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { List<supplier> olstStat = dbContext.suppliers.ToList(); sReturn = JsonConvert.SerializeObject(olstStat); } return sReturn; }
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 string LoadData() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { var oList = dbContext.PackingMaterials.Where(obj => obj.Status == 0).OrderByDescending(obj => obj.wPackingId).ToList(); sReturn = JsonConvert.SerializeObject(oList); } return sReturn; }
public static string LoadData() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { var oList = dbContext.suppliers.ToList(); sReturn = JsonConvert.SerializeObject(oList); } return sReturn; }
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 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 string LoadSingleData(string sId) { string sReturn = ""; int id = Convert.ToInt16(sId); using (var dbContext = new aspet_devEntities()) { var oList = dbContext.ResinMoistrRpts.Where(obj => obj.wRsinRptId == id).SingleOrDefault(); sReturn = JsonConvert.SerializeObject(oList); } return sReturn; }
protected void Page_Load(object sender, EventArgs e) { using (var dbContext = new aspet_devEntities()) { List<Shift> olstStat = dbContext.Shifts.ToList(); ddlShft.DataSource = olstStat; ddlShft.DataTextField = "sShift"; ddlShft.DataValueField = "wShiftId"; ddlShft.DataBind(); } }
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 string LoadData() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { var oList = dbContext.BagConsumptions.OrderByDescending(obj => obj.date).ToList(); //var oList = dbContext.BagConsumptions.Join(dbContext.Users, po => po.wShiftUserId, mo => mo.wUserId, (main, mo) => new { main, mo.sUser }) // .Join(dbContext.Shifts, sh => sh.main.wShift, shf => shf.wShiftId, (main1, shd) => new { main1,shd.sShift}).ToList(); sReturn = JsonConvert.SerializeObject(oList); } return sReturn; }
public static string LoadSingleData(string sId) { string sReturn = ""; int id = Convert.ToInt16(sId); using (var dbContext = new aspet_devEntities()) { List<object> oList = new List<object>(); oList.Add(dbContext.VisualReports.Where(obj => obj.wVisualId == id).SingleOrDefault()); oList.Add(dbContext.VCavities.Where(obj => obj.wVisualId == id).ToList()); sReturn = JsonConvert.SerializeObject(oList); } return sReturn; }
public static string LoadData() { string sReturn = ""; using (var dbContext = new aspet_devEntities()) { // var oList = dbContext.Users.Include(oInc => oInc.).OrderBy(oUsr=>oUsr.sUser).ToList(); var List = from oUser in dbContext.Users join roles in dbContext.UserRoles on oUser.wRoleId equals roles.wRoleId select new { oUser, roles }; sReturn = JsonConvert.SerializeObject(List); } return sReturn; }
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 CheckUserLogin(string sUserName, string sPassWord) { string msg = ""; using (var dbContext = new aspet_devEntities()) { User oCurr = dbContext.Users.Where(oUser => oUser.sUser == sUserName).SingleOrDefault(); if (oCurr == null || oCurr.sUser == null) msg = "Invalid User name or Password"; else if (oCurr.sPassword != sPassWord) msg = "Invalid User name or Password"; else if (oCurr.sPassword == sPassWord) msg = "Done"; } return msg; }
private void LoadObjects() { using (var dbContext = new aspet_devEntities()) { List<User> olstUser = dbContext.Users.ToList(); ddlChkd.DataSource = olstUser; ddlChkd.DataTextField = "sUser"; ddlChkd.DataValueField = "wUserId"; ddlChkd.DataBind(); ddlprep.DataSource = olstUser; ddlprep.DataTextField = "sUser"; ddlprep.DataValueField = "wUserId"; ddlprep.DataBind(); } }
private void LoadObjects() { using (var dbContext = new aspet_devEntities()) { List<User> olst = dbContext.Users.Where(ouser => ouser.wRoleId <= 3 || ouser.wRoleId == 3).ToList(); ddlSupervisor.DataSource = olst; ddlSupervisor.DataTextField = "sUser"; ddlSupervisor.DataValueField = "wUserId"; ddlSupervisor.DataBind(); List<station> olstStat = dbContext.stations.ToList(); ddlStation.DataSource = olstStat; ddlStation.DataTextField = "sStation"; ddlStation.DataValueField = "wStationId"; ddlStation.DataBind(); } }
private void LoadObjects() { using (var dbContext = new aspet_devEntities()) { List<Material> olst = dbContext.Materials.ToList(); ddlMaterial.DataSource = olst; ddlMaterial.DataTextField = "sMaterial"; ddlMaterial.DataValueField = "wMaterial"; ddlMaterial.DataBind(); List<supplier> olstStat = dbContext.suppliers.ToList(); ddlSuplier.DataSource = olstStat; ddlSuplier.DataTextField = "sSupplier"; ddlSuplier.DataValueField = "wSupplierId"; ddlSuplier.DataBind(); } }
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; }