/////////////////////////////////////////////////////////////////////////////////
//
// 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"));
}
