public void Create(Department dpt) { using (var ctx = new LYLQEntities()) { ctx.Departments.Add(dpt); ctx.SaveChanges(); } }
public void Create(InStore dpt) { using (var ctx = new LYLQEntities()) { ctx.InStores.Add(dpt); ctx.SaveChanges(); } }
public void Create(Materiel mat) { using (var ctx = new LYLQEntities()) { ctx.Materiels.Add(mat); ctx.SaveChanges(); } }
public void Create(OutStore ots) { using (var ctx = new LYLQEntities()) { ctx.OutStores.Add(ots); ctx.SaveChanges(); } }
public void Create(User user) { using (var ctx = new LYLQEntities()) { user.Id = Guid.NewGuid().ToString(); ctx.Users.Add(user); ctx.SaveChanges(); } }
public void Delete(string code) { using (var ctx = new LYLQEntities()) { var dbDpts = from dbDpt in ctx.Departments where dbDpt.Code == code select dbDpt; ctx.Departments.Remove(dbDpts.First()); ctx.SaveChanges(); } }
public void Delete(string id) { using (var ctx = new LYLQEntities()) { var dbUsers = from dbUser in ctx.Users where dbUser.Id == id select dbUser; ctx.Users.Remove(dbUsers.First()); ctx.SaveChanges(); } }
public void Delete(string code) { using (var ctx = new LYLQEntities()) { var dbUsers = from dbMaterial in ctx.Materiels where dbMaterial.Code == code select dbMaterial; ctx.Materiels.Remove(dbUsers.First()); ctx.SaveChanges(); } }
public void Delete(string id) { using (var ctx = new LYLQEntities()) { var dbInsts = from dbInst in ctx.InStores where dbInst.Id == id select dbInst; var dbModelInSt = dbInsts.First(); ctx.InStores.Remove(dbModelInSt); ctx.SaveChanges(); } }
public void Update(Materiel mat) { using (var ctx = new LYLQEntities()) { var dbMats = from dbMat in ctx.Materiels where dbMat.Code == mat.Code select dbMat; var dbModelDpt = dbMats.First(); dbModelDpt.Name = mat.Name; dbModelDpt.UpdatedBy = mat.UpdatedBy; dbModelDpt.UpdatedDate = DateTime.Now; ctx.SaveChanges(); } }
public void Update(User user) { using (var ctx = new LYLQEntities()){ var dbUsers = from dbUser in ctx.Users where dbUser.Id == user.Id select dbUser; var dbModelUser = dbUsers.First(); dbModelUser.Password = user.Password; dbModelUser.Demartment = user.Demartment; dbModelUser.Enabled = user.Enabled; dbModelUser.UpdatedBy = user.UpdatedBy; dbModelUser.UpdatedDate = DateTime.Now; ctx.SaveChanges(); } }
public void Update(Department dpt) { using (var ctx = new LYLQEntities()) { var dbDpts = from dbDpt in ctx.Departments where dbDpt.Code == dpt.Code select dbDpt; var dbModelDpt = dbDpts.First(); dbModelDpt.Name = dpt.Name; dbModelDpt.UpdatedBy = dpt.UpdatedBy; dbModelDpt.UpdatedDate = DateTime.Now; ctx.SaveChanges(); } }
public void OutStore(InStore dpt) { using (var ctx = new LYLQEntities()) { var dbInsts = from dbInst in ctx.InStores where dbInst.Id == dpt.Id select dbInst; var dbModelInSt = dbInsts.First(); dbModelInSt.RemainNumber = dpt.RemainNumber; dbModelInSt.RemainTotalPrice = dpt.RemainTotalPrice; dbModelInSt.UpdatedBy = dpt.UpdatedBy; dbModelInSt.UpdatedDate = DateTime.Now; ctx.SaveChanges(); } }
public void Update(OutStore outStore) { using (var ctx = new LYLQEntities()) { var dbOuts = from dbOut in ctx.OutStores where dbOut.Id == outStore.Id select dbOut; var dbModelOut = dbOuts.First(); dbModelOut.InstoreId = outStore.InstoreId; dbModelOut.Code = outStore.Code; dbModelOut.UnitPrice = outStore.UnitPrice; dbModelOut.Number = outStore.Number; dbModelOut.TotalPrice = outStore.TotalPrice; dbModelOut.Department = outStore.Department; dbModelOut.Type = outStore.Type; dbModelOut.UpdatedBy = outStore.UpdatedBy; dbModelOut.UpdatedDate = DateTime.Now; ctx.SaveChanges(); } }