public ActionResult DeleteConfirmed(int id)
{
Av_Cust av_cust = db.av_cust.Find(id);
db.av_cust.Remove(av_cust);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Av_Cust/Details/5
public ActionResult Details(int id = 0)
{
Av_Cust av_cust = db.av_cust.Find(id);
if (av_cust == null)
{
return(HttpNotFound());
}
return(View(av_cust));
}
public ActionResult Edit(Av_Cust av_cust)
{
if (ModelState.IsValid)
{
db.Entry(av_cust).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(av_cust));
}
public ActionResult Create(Av_Cust av_cust)
{
SubScription_KindtDBContext sbdb = new SubScription_KindtDBContext();
var q = from a in sbdb.subscription_kind select a;
List <SubScription_Kind2> sb = new List <SubScription_Kind2>();
foreach (var item in q)
{
sb.Add(item);
}
ViewBag.sss = sb;
if (ModelState.IsValid)
{
if (av_cust.Password != av_cust.Passwordco)
{
TempData["pass"] = "******";
return(View(av_cust));
}
av_cust.Start_Time = DateTime.Now;
string snam = Request.Form["snam"];
Av_Cust2 av2 = new Av_Cust2(av_cust.Cust_Nme, av_cust.Phone, av_cust.E_mail, av_cust.Account_count, av_cust.Start_Time, av_cust.Password, snam);
db2.av_cust2.Add(av2);
db2.SaveChanges();
int pr = 0;
foreach (var item in q)
{
if (item.Type == av2.Sup_Type)
{
pr = (int)item.Price;
pr = pr * ((int)av2.Account_count);
}
}
TempData["pr"] = pr;
return(RedirectToAction("Wait"));
}
return(View(av_cust));
}
public ActionResult Renew(Av_Cust av_cust)
{
if (Session["swi"] == null)
{
return(RedirectToAction("Index", "Home"));
}
int id = (int)Session["swi"];
Customers cus = new Customers();
var q2 = from d in db3.customer where d.Cust_Id == id select d;
foreach (var item in q2)
{
cus = item;
}
SubScription_KindtDBContext sbdb = new SubScription_KindtDBContext();
var q = from a in sbdb.subscription_kind select a;
av_cust.Start_Time = cus.Start_Time;
string snam = Request.Form["snam"];
av_cust = new Av_Cust(cus.Cust_Nme, cus.Phone, cus.E_mail, cus.Account_count, cus.Start_Time, cus.Password);
Av_Cust2 av2 = new Av_Cust2(av_cust.Cust_Nme, av_cust.Phone, av_cust.E_mail, av_cust.Account_count, av_cust.Start_Time, av_cust.Password, snam);
db2.av_cust2.Add(av2);
db2.SaveChanges();
int pr = 0;
foreach (var item in q)
{
if (item.Type == av2.Sup_Type)
{
pr = (int)item.Price;
pr = pr * ((int)av2.Account_count);
}
}
TempData["pr"] = pr;
return(RedirectToAction("Wait"));
}
public ActionResult Create(Av_Cust av_cust)
{
SubScription_KindtDBContext sbdb = new SubScription_KindtDBContext();
var q = from a in sbdb.subscription_kind select a;
//var io = from hp in db2.av_cust2 select hp.Cust_Id;
//var w = from aa in db3.customer select aa.Cust_Id;
//int wasd = 0;
//foreach (var item in io)
//{
// if (item > wasd)
// wasd = item;
//}
//int x = 0;
//foreach (var item in w)
//{
// if (item > x)
// x = item;
//}
//wasd = Math.Max(wasd, x);
List <SubScription_Kind2> sb = new List <SubScription_Kind2>();
foreach (var item in q)
{
sb.Add(item);
}
ViewBag.sss = sb;
if (ModelState.IsValid)
{
if (av_cust.Password != av_cust.Passwordco)
{
TempData["pass"] = "******";
return(View(av_cust));
}
av_cust.Start_Time = DateTime.Now;
string snam = Request.Form["snam"];
//Cs_Su cssu = new Cs_Su(wasd + 1, snam);
//var qq = from a in sbdb.subscription_kind where a.Sub_Id == snam select a;
//foreach (var item in qq)
//{
// cssu.Start = DateTime.Now;
// cssu.Start = cssu.Start.AddDays(1);
// cssu.Finish = DateTime.Now;
// cssu.Finish = cssu.Finish.AddDays(item.Time_Period + 1);
//}
Av_Cust2 av2 = new Av_Cust2(av_cust.Cust_Nme, av_cust.Phone, av_cust.E_mail, av_cust.Account_count, av_cust.Start_Time, av_cust.Password, snam);
db2.av_cust2.Add(av2);
db2.SaveChanges();
int pr = 0;
foreach (var item in q)
{
if (item.Type == av2.Sup_Type)
{
pr = (int)item.Price;
pr = pr * ((int)av2.Account_count);
}
}
//db4.cs_su.Add(cssu);
//db4.SaveChanges();
TempData["pr"] = pr;
return(RedirectToAction("Wait"));
}
return(View(av_cust));
}
