void RefresOrder(Order_Del newOrder, Order_Del oldOrder) { if (!oldOrder.Bouquet_ID.Equals(newOrder.Bouquet_ID)) { oldOrder.Bouquet_ID = newOrder.Bouquet_ID; } if (!oldOrder.Date_Delived.Equals(newOrder.Date_Delived)) { oldOrder.Date_Delived = newOrder.Date_Delived; } }
void Equals(string zipOrdera, Order_Del orderDel, string[] zipForDriver, string ComboDriver) { foreach (var dr1 in zipForDriver) { if (dr1.Equals(zipOrdera)) { orderDel.Driver_ID = Convert.ToInt32(ComboDriver); orderDel.Order_Status = "InTransite"; break; } } try { db.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex); } }
public bool SaveOrder(CallCenter model) { bool result = false; //create address Address address = new Address() { Address_City = model.Address_City, Address_ZIPCODE = model.Address_ZIPCODE, Address_Numder_Appartment = model.Address_Numder_Appartment, Address_Country = model.Address_Country, Address_line1 = model.Address_line1, Address_line2 = model.Address_line2, Address_Name_Street = model.Address_Name_Street, Address_Number_Street = model.Address_Number_Street, Address_State = model.Address_State, }; db.Addresses.Add(address); //create customer Cust2 cust2 = new Cust2() { Lname = model.Client.Lname, Fname = model.Client.Fname, Address = address, Email = model.Client.Email, Phone = model.Client.Phone, Gender = model.Gender }; db.Cust2.Add(cust2); //create order int id = 0; int.TryParse(model.ComboBouqets, out id); int quantities = 0; int.TryParse(model.ComboQuantities, out quantities); decimal summ = 0; decimal.TryParse(model.Sum, out summ); Order_Del order = new Order_Del() { Bouquet_ID = id, Florist_ID = 25, Cust2 = cust2, Driver_ID = 1000, Order_Date = DateTime.Today, Bouquet_Quontity = quantities, Date_Delived = DateDelivery, Total_Price = summ, Size_Bouquets = model.ComboSizes, Order_Status = "Payed" }; db.Order_Del.Add(order); try { db.SaveChanges(); return(true); } catch (Exception ex) { return(result); } }
/// <summary> /// Редактирование старой заявки /// </summary> /// <param name="model"></param> /// <returns></returns> bool EditOldOrder(CallCenter model) { bool result = false; // var oldOrderFromDB = db.Order_Del.FirstOrDefault(d => d.Order_ID == model.Order_ID); var oldAddress = oldOrderFromDB.Cust2.Address; var oldCustomer = oldOrderFromDB.Cust2; Address address = new Address() { Address_City = model.Address_City, Address_ZIPCODE = model.Address_ZIPCODE, Address_Numder_Appartment = model.Address_Numder_Appartment, Address_Country = model.Address_Country, Address_line1 = model.Address_line1, Address_line2 = model.Address_line2, Address_Name_Street = model.Address_Name_Street, Address_Number_Street = model.Address_Number_Street, Address_State = model.Address_State, }; RefreshAddress(address, oldAddress); //create customer Cust2 cust2 = new Cust2() { Lname = model.Client.Lname, Fname = model.Client.Fname, Email = model.Client.Email, Phone = model.Client.Phone, Gender = model.Gender }; RefreshCustomer(cust2, oldCustomer); //create order int id = 0; int.TryParse(model.ComboBouqets, out id); int quantities = 0; int.TryParse(model.ComboQuantities, out quantities); decimal summ = 0; decimal.TryParse(model.Sum, out summ); Order_Del order = new Order_Del() { Bouquet_ID = id, Bouquet_Quontity = quantities, Date_Delived = DateDelivery, Total_Price = summ, Size_Bouquets = model.ComboSizes, }; RefresOrder(order, oldOrderFromDB); try { db.SaveChanges(); return(true); } catch (Exception ex) { return(result); } }