public ActionResult AdminPanel()
{
Tbl_admin m = null;
if (Session["Admin_id"] != null)
{
int Admin_id = Convert.ToInt32(Session["Admin_id"].ToString());
m = db.Tbl_admin.Where(x => x.Admin_id == Admin_id).SingleOrDefault();
var totalbooks = (from books in db.Tbl_Books
select books).Count();
ViewBag.totalbooks = totalbooks;
var totalebooks = (from ebooks in db.Ebooks_db
select ebooks).Count();
ViewBag.totalebooks = totalebooks;
var totalmembers = (from member in db.tbl_member
select member).Count();
ViewBag.totalmembers = totalmembers;
var totalvendors = (from vendor in db.Tbl_Vendorr
select vendor).Count();
ViewBag.totalvendors = totalvendors;
var totalsubscriber = (from subscriber in db.tbl_subscribe
select subscriber).Count();
ViewBag.totalsubscriber = totalsubscriber;
var totalorders = (from order in db.BTransactions
select order).Count();
ViewBag.totalorders = totalorders;
}
else
{
return(RedirectToAction("Login"));
}
return(View(m));
}
public ActionResult DeleteConfirmed(int id)
{
Tbl_admin tbl_admin = db.Tbl_admin.Find(id);
db.Tbl_admin.Remove(tbl_admin);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Admin_id,Admin_name,Admin_email,Admin_password,Admin_contact,Admin_status")] Tbl_admin tbl_admin)
{
if (ModelState.IsValid)
{
db.Entry(tbl_admin).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_admin));
}
public ActionResult Create([Bind(Include = "Admin_id,Admin_name,Admin_email,Admin_password,Admin_contact,Admin_status")] Tbl_admin tbl_admin)
{
if (ModelState.IsValid)
{
db.Tbl_admin.Add(tbl_admin);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_admin));
}
public ActionResult PersonalInfoAdmin()
{
Tbl_admin m = null;
if (Session["Admin_id"] != null)
{
int Admin_id = Convert.ToInt32(Session["Admin_id"].ToString());
m = db.Tbl_admin.Where(x => x.Admin_id == Admin_id).SingleOrDefault();
}
return(View(m));
}
// GET: Tbladmin/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tbl_admin tbl_admin = db.Tbl_admin.Find(id);
if (tbl_admin == null)
{
return(HttpNotFound());
}
return(View(tbl_admin));
}
public ActionResult Login(String email, String pass)
{
//int id = db.Tbl_admin.Count();
//id += 1;
Tbl_admin model = db.Tbl_admin.Where(x => x.Admin_email == email && x.Admin_password == pass).SingleOrDefault();
if (model != null)
{
Session["Admin_email"] = model.Admin_email;
Session["Admin_id"] = model.Admin_id;
return(RedirectToAction("AdminPanel", "Tbladmin"));
}
return(View("Invalid Password"));
}
