public bool UpdateStaff(Staff sf) { bool result = false; try { using (AccessoriesEntities _entityStaff = new AccessoriesEntities()) { Staff _staff = _entityStaff.Staffs.Where(x => x.Id == sf.Id).Select(x => x).FirstOrDefault(); /*_customer.Id = cus.Id;*/ _staff.Name = sf.Name; _staff.Phone = sf.Phone; _staff.Date_join = sf.Date_join; _staff.Position = sf.Position; _staff.Salary = sf.Salary; _entityStaff.SaveChanges(); result = true; } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } return(result); }
public void DisplayStaff() { using (AccessoriesEntities _entityStaff = new AccessoriesEntities()) { dataGridViewStaff.DataSource = _entityStaff.Staffs.ToList(); } }
public bool UpdateCustomer(Customer cus) { bool result = false; try { using (AccessoriesEntities _entityUpdate = new AccessoriesEntities()) { Customer _customer = _entityUpdate.Customers.Where(x => x.Id == cus.Id).Select(x => x).FirstOrDefault(); /*_customer.Id = cus.Id;*/ _customer.Name = cus.Name; _customer.Address = cus.Address; _customer.Gender = cus.Gender; _customer.Phone = cus.Phone; _entityUpdate.SaveChanges(); result = true; } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } return(result); }
public void DisplayCus() { using (AccessoriesEntities _entityCus = new AccessoriesEntities()) { dataGridViewCus.DataSource = _entityCus.Customers.ToList(); } }
public bool UpdateProduct(Product pro) // UpdateStudentDetails method for update a existing Record { bool result = false; try { using (AccessoriesEntities _entity = new AccessoriesEntities()) { Product _product = _entity.Products.Where(x => x.Id == pro.Id).Select(x => x).FirstOrDefault(); _product.ProductName = pro.ProductName; _product.Provider = pro.Provider; _product.Price = pro.Price; _product.Quantity = pro.Quantity; _entity.SaveChanges(); result = true; } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } return(result); }
public bool SaveProduct(Product pro) { bool result = false; using (AccessoriesEntities _entity = new AccessoriesEntities()) { _entity.Products.Add(pro); _entity.SaveChanges(); result = true; } return(result); }
public bool SaveStaff(Staff sf) { bool result = false; using (AccessoriesEntities _entityStaff = new AccessoriesEntities()) { _entityStaff.Staffs.Add(sf); _entityStaff.SaveChanges(); result = true; } return(result); }
public bool SaveCustomer(Customer cus) { bool result = false; using (AccessoriesEntities _entityCus = new AccessoriesEntities()) { _entityCus.Customers.Add(cus); _entityCus.SaveChanges(); result = true; } return(result); }
public bool DeleteStaff(Staff sf) { bool result = false; using (AccessoriesEntities _entityStaff = new AccessoriesEntities()) { Staff _staff = new Staff(); _staff = _entityStaff.Staffs.Where(x => x.Id == sf.Id).Select(x => x).FirstOrDefault(); _entityStaff.Staffs.Remove(_staff); _entityStaff.SaveChanges(); result = true; } return(result); }
public bool DeleteCustomer(Customer cus) { bool result = false; using (AccessoriesEntities _entity = new AccessoriesEntities()) { Customer _customer = new Customer(); _customer = _entity.Customers.Where(x => x.Id == cus.Id).Select(x => x).FirstOrDefault(); _entity.Customers.Remove(_customer); _entity.SaveChanges(); result = true; } return(result); }
public bool DeleteProduct(Product pro) // UpdateStudentDetails method for update a existing Record { bool result = false; using (AccessoriesEntities _entity = new AccessoriesEntities()) { Product _product = new Product(); _product = _entity.Products.Where(x => x.Id == pro.Id).Select(x => x).FirstOrDefault(); _entity.Products.Remove(_product); _entity.SaveChanges(); result = true; } return(result); }
public void DisplayPro() { using (AccessoriesEntities _entity = new AccessoriesEntities()) { /*List<Product> _productlist = new List<Product>(); * _productlist = _entity.Products.Select(x => new Product * { * Id = x.Id, * ProductName = x.ProductName, * Provider = x.Provider, * Price = x.Price, * Quantity = x.Quantity * }).ToList(); * dataGridView.DataSource = _productlist;*/ dataGridView.DataSource = _entity.Products.ToList(); } }