public bool ChangePassword(Staff staff, string newPassword) { staff.Password = newPassword; db.SaveChanges(); return(true); }
public bool CreateOrderDetail(OrderDetail orderDetail) { db.OrderDetails.Add(orderDetail); db.SaveChanges(); return(true); }
public bool UpdateInventoryAccessoryFromExcelFile(string Name, int SoLuong) { var Acc = db.Accessories.FirstOrDefault(x => x.Name.Equals(Name)); if (Acc == null) { return(false); } Acc.Inventory = Acc.Inventory + SoLuong; try { db.SaveChanges(); } catch { } return(true); }
public Result AddOrUpdateCustomer(CustomerCreateDto CustomerDto) { var entityTemp = db.Customers.FirstOrDefault(x => x.Email.Equals(CustomerDto.Email)); var config = new MapperConfiguration(cfg => { cfg.CreateMap <CustomerCreateDto, Customer>(); }); IMapper mapper = config.CreateMapper(); var cus = mapper.Map <CustomerCreateDto, Customer>(CustomerDto); if (entityTemp == null) { db.Customers.Add(cus); } else { entityTemp.Name = CustomerDto.Name; entityTemp.NumberPhone = CustomerDto.NumberPhone; entityTemp.IdentifyNumber = CustomerDto.IdentifyNumber; entityTemp.BirthDate = CustomerDto.BirthDate; entityTemp.Email = CustomerDto.Email; } try { db.SaveChanges(); } catch (DbEntityValidationException e) { return(new Result { ResultMessage = e .EntityValidationErrors .LastOrDefault() .ValidationErrors .LastOrDefault() .ErrorMessage, IsSuccess = false }); } return(new Result { ResultMessage = "Thao Tác thành công", IsSuccess = true }); }
public int CreateOrder(Order order) { db.Orders.Add(order); db.SaveChanges(); return(order.Id); }