public void EditPaper(string paperid, string papername) { var db = new PrinteryContext(); var exitPaper = db.Paper.FirstOrDefault(s => s.PaperId == paperid); if (exitPaper != null) { db.Set <Paper>().Attach(exitPaper); db.Entry(exitPaper).State = EntityState.Modified; exitPaper.PaperName = papername; db.SaveChanges(); } }
public void UpdatePassword(string pwd, string empid) { var db = new PrinteryContext(); var exitEmp = db.Employee.FirstOrDefault(s => s.EmpId == empid); if (exitEmp != null) { db.Set <Employee>().Attach(exitEmp); db.Entry(exitEmp).State = EntityState.Modified; exitEmp.Password = pwd; db.SaveChanges(); } }
public void EditInk(string inkid, string inkname) { var db = new PrinteryContext(); var exitInk = db.InkStock.FirstOrDefault(s => s.InkId == inkid); if (exitInk != null) { db.Set <InkStock>().Attach(exitInk); db.Entry(exitInk).State = EntityState.Modified; exitInk.InkName = inkname; db.SaveChanges(); } }
public void EditProduct(ProductGoodsViewModel product) { var db = new PrinteryContext(); var exitProduct = db.Product.FirstOrDefault(s => s.ProductID == product.ProductID); if (exitProduct != null) { db.Set <Product>().Attach(exitProduct); db.Entry(exitProduct).State = EntityState.Modified; exitProduct.ProductName = product.ProductName; exitProduct.eachPrice = product.eachPrice; db.SaveChanges(); } }
public void EditEmployee(EmployeeViewModel emp) { var db = new PrinteryContext(); var exitEmp = db.Employee.FirstOrDefault(s => s.EmpId == emp.EmpId); if (exitEmp != null) { db.Set <Employee>().Attach(exitEmp); db.Entry(exitEmp).State = EntityState.Modified; exitEmp.Ename = emp.Ename; exitEmp.Department = emp.Department; exitEmp.UserGroup = emp.UserGroup; exitEmp.Sex = emp.Sex; db.SaveChanges(); } }
public void EditCustomer(CustomerViewModel cms) { var db = new PrinteryContext(); var exitCms = db.Customer.FirstOrDefault(s => s.CustomerId == cms.CustomerId); if (exitCms != null) { db.Set <Customer>().Attach(exitCms); db.Entry(exitCms).State = EntityState.Modified; exitCms.CustomerName = cms.CustomerName; exitCms.Contact = cms.Contact; exitCms.Phone = cms.Phone; exitCms.MobilePhone = cms.MobilePhone; exitCms.CAddress = cms.CAddress; db.SaveChanges(); } }
public void UpdateEmployeeInfo(EmployeeViewModel emp) { var db = new PrinteryContext(); var exitEmp = db.Employee.FirstOrDefault(s => s.EmpId == emp.EmpId); if (exitEmp != null) { db.Set <Employee>().Attach(exitEmp); db.Entry(exitEmp).State = EntityState.Modified; exitEmp.Ename = emp.Ename; exitEmp.Department = emp.Department; exitEmp.Nation = emp.Nation; exitEmp.Sex = emp.Sex; exitEmp.QQ = emp.QQ; exitEmp.Phone = emp.Phone; db.SaveChanges(); } }
public void EditProExi(addProExiViewModel pro) { PrinteryContext pr = new PrinteryContext(); var exitPro = pr.ProductionExpense.FirstOrDefault(s => s.ProExId == pro.ProExId); if (exitPro != null) { pr.Set <ProductionExpense>().Attach(exitPro); pr.Entry(exitPro).State = EntityState.Modified; exitPro.ProductId = pro.ProductId; exitPro.ProductName = pro.ProductName; exitPro.InkId1 = pro.InkId1; exitPro.InkId2 = pro.InkId2; exitPro.InkId1Count = pro.InkId1Count; exitPro.InkId2Count = pro.InkId2Count; exitPro.PaperId1 = pro.PaperId1; exitPro.PaperId2 = pro.PaperId2; exitPro.PaperId2Count = pro.PaperId2Count; pr.SaveChanges(); } }