public void UpdateStatusBill(Bill_Show bill_) { var t = db.Output_Form.Find(bill_.ID_output); t.Status = "Complete"; db.SaveChanges(); }
public ObservableCollection <Bill_Show> Load_ListBill() { ObservableCollection <Output_Form> out_form = new ObservableCollection <Output_Form>(db.Output_Form); ObservableCollection <Bill_Show> a = new ObservableCollection <Bill_Show>(); for (int i = 0; i < out_form.Count; i++) { Bill_Show n = new Bill_Show(); n.ID_output = out_form[i].ID_Output; n.Namepro = db.Detail_Product.Find(out_form[i].ID_Product).NameProduct; n.Initial_price = n.Sale_price = Int32.Parse(db.Detail_Product.Find(out_form[i].ID_Product).Original_Price.ToString()); n.Name_Cus = db.Customers.Find(out_form[i].ID_Customer).Name_Cus; n.status = out_form[i].Status; n.ID_PRO = out_form[i].ID_Product; n.Online = out_form[i].BuyOnline; n.Amount = (Int32)out_form[i].Amount; n.DateCreate = (DateTime)out_form[i].Output_Date; n.Phone = db.Customers.Find(out_form[i].ID_Customer).Phone; n.Ship = (int)out_form[i].Ship; n.Address = db.Customers.Find(out_form[i].ID_Customer).Address_Cus; n.Email = db.Customers.Find(out_form[i].ID_Customer).Email == "" ? "" : db.Customers.Find(out_form[i].ID_Customer).Email; n.birthday = (DateTime)db.Customers.Find(out_form[i].ID_Customer).Birthday; //lấy danh sách các Bill để show lên listbill a.Add(n); } return(a); }
public void CancelBill(Bill_Show bill) { var curProduct = db.Detail_Product.Find(bill.ID_PRO); var curBill = db.Output_Form.Find(bill.ID_output); // Đưa lại vào kho curProduct.Amount_Current += (bill.Amount); // Tính cả phần tặng // Cập nhật trạng thái curBill.Status = "Canceled"; db.SaveChanges(); }
public void AddnewOutput(Bill_Show bill_) { Output_Form a = new Output_Form(); a.ID_Output = bill_.ID_output; a.ID_Product = bill_.ID_PRO; a.Note = ""; a.Output_Date = bill_.DateCreate; a.Price_Sale = bill_.Sale_price; a.Ship = bill_.Ship; a.Status = bill_.status; a.Amount = bill_.Amount; a.BuyOnline = bill_.Online; //nếu khách hàng đã tồn tại thì ko cần thêm vào if (db.Customers.Find(bill_.Phone) == null) //chưa tồn tại { Customer b = new Customer() { ID_Customer = Create_NewIdCustomer_Auto(), Phone = bill_.Phone, Name_Cus = bill_.Name_Cus, Address_Cus = bill_.Address == null ? "" : bill_.Address, Email = bill_.Email, Birthday = (DateTime)bill_.birthday, }; a.ID_Customer = b.ID_Customer; db.Customers.Add(b); } else { a.ID_Customer = db.Customers.Find(bill_.Phone).ID_Customer; } db.Output_Form.Add(a); db.SaveChanges(); }