// GET: Book/Delete/5
public ActionResult Delete(string id)
{
using (DaVentiDBEntities dBEntities = new DaVentiDBEntities())
{
return(View(dBEntities.Books.Where(x => x.id_book == id).FirstOrDefault()));
}
}
// GET: Book
public ActionResult Index()
{
using (DaVentiDBEntities dBEntities = new DaVentiDBEntities())
{
return(View(dBEntities.Books.ToList()));
}
}
// GET: Default/Delete/5
public ActionResult Delete(string id)
{
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
return(View(en.Categories.Where(x => x.id_category == id).FirstOrDefault()));
}
}
public ActionResult Login(Login login)
{
string message = "";
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
var check = en.Employees.Where(a => a.email_emp == login.email_emp).FirstOrDefault();
if (check != null)
{
if (string.Compare(login.password_emp, check.password_emp) == 0)
{
FormsAuthentication.SetAuthCookie(login.email_emp, false);
return(RedirectToAction("Index", "Home"));
}
else
{
message = "Wrong email or password!";
}
}
else
{
message = "Invalid credentials!";
}
}
ViewBag.Message = message;
return(View());
}
// GET: Category
public ActionResult Index()
{
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
return(View(en.Categories.ToList()));
}
}
// GET: Promo/Edit/5
public ActionResult Edit(string id)
{
using (DaVentiDBEntities dBEntities = new DaVentiDBEntities())
{
return(View(dBEntities.Promoes.Where(x => x.id_promo == id).FirstOrDefault()));
}
}
public bool IsEmailExist(string email)
{
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
var check = en.Employees.Where(a => a.email_emp == email).FirstOrDefault();
return(check != null);
}
}
public ActionResult Edit(string id, Category category)
{
try
{
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
en.Entry(category).State = EntityState.Modified;
en.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(Category category)
{
try
{
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
en.Categories.Add(category);
en.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(string id, Promo promo)
{
try
{
// TODO: Add update logic here
using (DaVentiDBEntities dBEntities = new DaVentiDBEntities())
{
dBEntities.Entry(promo).State = EntityState.Modified;
dBEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(Promo promo)
{
try
{
// TODO: Add insert logic here
using (DaVentiDBEntities dBEntities = new DaVentiDBEntities())
{
dBEntities.Promoes.Add(promo);
dBEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(string id, FormCollection collection)
{
try
{
// TODO: Add delete logic here
using (DaVentiDBEntities dBEntities = new DaVentiDBEntities())
{
Book book = dBEntities.Books.Where(x => x.id_book == id).FirstOrDefault();
dBEntities.Books.Remove(book);
dBEntities.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(Book book)
{
try
{
using (DaVentiDBEntities dBEntities = new DaVentiDBEntities())
{
dBEntities.Books.Add(book);
dBEntities.SaveChanges();
}
// TODO: Add insert logic here
ViewBag.Message = "Book added";
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(string id, FormCollection collection)
{
try
{
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
Category category = en.Categories.Where(x => x.id_category == id).FirstOrDefault();
en.Categories.Remove(category);
en.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Registration(Employee employee)
{
bool Status = false;
string message = "";
// model validation
if (ModelState.IsValid)
{
#region email already exist
var isExist = IsEmailExist(employee.email_emp);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(employee));
}
#endregion
#region saving to database
using (DaVentiDBEntities en = new DaVentiDBEntities())
{
en.Employees.Add(employee);
en.SaveChanges();
message = "Registration successful. Welcome abroad!";
Status = true;
}
#endregion
}
else
{
message = "Invalid request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(employee));
}
