///////////////////////////////////////////////////////////////////////////////// // // GET: /Customers/Renew/6 public ActionResult Renew(int id = 0) { if (Session["swi"] == null) { return(RedirectToAction("Index", "Home")); } if (Session["isadmin"] == "no") { return(RedirectToAction("../LogOn")); } Av_Cust2 avc = db2.av_cust2.Find(id); Customers cust = new Customers(); var qsd = from kli in db.customer where kli.E_mail == avc.E_mail select kli; foreach (var item in qsd) { cust = item; } var q = from a in db4.subscription_kind where a.Type == avc.Sup_Type select a; int sub_id = 0; decimal price = 0; int tim = 0; foreach (var item in q) { sub_id = item.Sub_Id; price = item.Price; tim = item.Time_Period; } cust.Payment += (int)price * cust.Account_count; db.Entry(cust).State = EntityState.Modified; db.SaveChanges(); var ew = from t in db5.cs_su where t.Customer == cust.Cust_Id orderby t.ID descending select t; Cs_Su cssu = ew.First(); cssu.Finish = cssu.Finish.AddDays(tim); cssu.Sub = sub_id; db5.Entry(cssu).State = EntityState.Modified; db5.SaveChanges(); db2.av_cust2.Remove(avc); db2.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /Customers/Create/6 public ActionResult Create(int id = 0) { if (Session["swi"] == null) { return(RedirectToAction("Index", "Home")); } if (Session["isadmin"] == "no") { return(RedirectToAction("../LogOn")); } Av_Cust2 avc = db2.av_cust2.Find(id); Customers cust = new Customers(avc.Cust_Nme, avc.Phone, avc.E_mail, avc.Account_count, avc.Start_Time, avc.Password); cust.Cust_Id = id; var q = from a in db4.subscription_kind where a.Type == avc.Sup_Type select a; int sub_id = 0; decimal price = 0; int tim = 0; foreach (var item in q) { sub_id = item.Sub_Id; price = item.Price; tim = item.Time_Period; } // Financial2 fn = new Financial2(id, price); // f.fin.Add(fn); // f.SaveChanges(); cust.Payment = (int)price; db.customer.Add(cust); db.SaveChanges(); var ew = from t in db.customer orderby t.Cust_Id descending select t; Customers cs234 = ew.First(); id = cs234.Cust_Id; DateTime Finish = avc.Start_Time.AddDays(tim); Cs_Su cssu = new Cs_Su(id, sub_id, avc.Start_Time, Finish); db5.cs_su.Add(cssu); db5.SaveChanges(); db2.av_cust2.Remove(avc); db2.SaveChanges(); return(RedirectToAction("Index")); }