// Validate Signup Attempt
public JsonResult SingupValidate(string firstname, string lastname, string email, string password)
{
string response = "";
using (MyDatabaseEntities ctx = new MyDatabaseEntities())
{
User u = ctx.Users.FirstOrDefault(x => x.Email == email);
response = "failed";
if (u == null && email != "admin")
{
u = new User();
u.Email = email;
u.FirstName = firstname;
u.LastName = lastname;
u.Password = password;
ctx.Users.Add(u);
ctx.SaveChanges();
Session["id"] = u.UserId;
Session["type"] = "user";
Session["firstname"] = u.FirstName;
Session["lastname"] = u.LastName;
response = "success";
}
}
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public JsonResult AddCatalog(string name)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
Catalog u = new Catalog();
u.Name = name;
ctx.Catalogs.Add(u);
ctx.SaveChanges();
string response = "success";
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Catalog()
{
if (Session["id"] != null && Session["type"].ToString() == "user")
return RedirectToAction("Index", "User");
else if (Session["id"] == null)
return RedirectToAction("Index", "Login");
ViewBag.visible = 2;
MyDatabaseEntities ctx = new MyDatabaseEntities();
List<Catalog> cat = ctx.Catalogs.ToList();
return View(cat);
}
public ActionResult TotalOrders()
{
if (Session["id"] != null && Session["type"].ToString() == "admin")
return RedirectToAction("Index", "Admin");
else if (Session["id"] == null)
return RedirectToAction("Index", "Login");
ViewBag.visible = 2;
MyDatabaseEntities ctx = new MyDatabaseEntities();
int userId = int.Parse(Session["id"].ToString());
List<Order> u = ctx.Orders.Where(x => x.UserId == userId).ToList();
return View(u);
}
public ActionResult Setting()
{
if (Session["id"] != null && Session["type"].ToString() == "admin")
return RedirectToAction("Index", "Admin");
else if (Session["id"] == null)
return RedirectToAction("Index", "Login");
ViewBag.visible = 3;
MyDatabaseEntities ctx = new MyDatabaseEntities();
int userId = int.Parse(Session["id"].ToString());
User u = ctx.Users.FirstOrDefault(m => m.UserId == userId);
return View(u);
}
public JsonResult DiscardOrder(int id)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
Order u = ctx.Orders.FirstOrDefault(x => x.OrderId == id);
string response = "failed";
if (u != null)
{
u.Status = "DISCARD";
ctx.SaveChanges();
response = "success";
}
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public JsonResult DeleteUser(int id)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
User u = ctx.Users.FirstOrDefault(x => x.UserId == id);
string response = "failed";
if (u != null)
{
ctx.Users.Remove(u);
ctx.SaveChanges();
response = "success";
}
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public JsonResult AddOrder(string job, string media, string mediaCatalog, string content)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
Order o = new Order();
o.JobType = job;
o.Media = media;
o.CatalogNumber = int.Parse(mediaCatalog);
o.Content = content;
o.UserId = int.Parse(Session["id"].ToString());
o.Status = "PENDING";
string response = "failed";
ctx.Orders.Add(o);
ctx.SaveChanges();
response = "success";
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public JsonResult UpdateUser(int id, string firstname, string lastname, string email, string password)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
User u = ctx.Users.FirstOrDefault(x => x.UserId == id);
string response = "failed";
if (u != null && email != "admin")
{
u.Email = email;
u.FirstName = firstname;
u.LastName = lastname;
u.Password = password;
ctx.SaveChanges();
response = "success";
Session["firstname"] = firstname;
}
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public JsonResult AddOrder(string payOption)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
Order o = new Order();
o.JobType = Session["job"].ToString();
o.Media = Session["media"].ToString();
o.CatalogNumber = int.Parse(Session["mediaCatalog"].ToString());
o.Content = Session["content"].ToString();
o.UserId = int.Parse(Session["id"].ToString());
o.PaymentMethod = payOption;
o.Status = "PENDING";
string response = "pass";
ctx.Orders.Add(o);
ctx.SaveChanges();
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult EditUser(int id)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
User u = ctx.Users.FirstOrDefault(x => x.UserId == id);
return View(u);
}
public ActionResult Users()
{
if (Session["id"] != null && Session["type"].ToString() == "user")
return RedirectToAction("Index", "User");
else if (Session["id"] == null)
return RedirectToAction("Index", "Login");
ViewBag.visible = 3;
MyDatabaseEntities ctx = new MyDatabaseEntities();
List<User> list = ctx.Users.Where(x => x.UserId != 2).ToList();
return View(list);
}
public JsonResult UpdateCatalog(int id, string name)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
Catalog u = ctx.Catalogs.FirstOrDefault(x => x.CatalogId == id);
string response = "failed";
if (u != null)
{
u.Name = name;
ctx.SaveChanges();
response = "success";
}
return this.Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Orders()
{
if (Session["id"] != null && Session["type"].ToString() == "user")
return RedirectToAction("Index", "User");
else if (Session["id"] == null)
return RedirectToAction("Index", "Login");
ViewBag.visible = 1;
MyDatabaseEntities ctx = new MyDatabaseEntities();
List<Order> or = ctx.Orders.Where(x => x.Status != "PENDING" && x.Status != "DISCARD").ToList();
return View(or);
}
// Validate Login Attempt
public JsonResult Validate(string email, string password)
{
User u = null;
string response = "failed";
using (MyDatabaseEntities ctx = new MyDatabaseEntities())
{
if (email == "admin")
{
u = ctx.Users.FirstOrDefault(x => x.UserId == 2);
if (u.Password == password)
{
response = "admin";
Session["id"] = u.UserId;
Session["type"] = "admin";
Session["firstname"] = u.FirstName;
Session["lastname"] = u.LastName;
}
}
else
{
u = ctx.Users.FirstOrDefault(x => x.Email == email);
if (u == null)
{
try
{
u = ctx.Users.FirstOrDefault(x => x.UserId == int.Parse(email));
}
catch
{
u = null;
}
}
if (u != null && u.Password == password)
{
Session["id"] = u.UserId;
Session["type"] = "user";
Session["firstname"] = u.FirstName;
Session["lastname"] = u.LastName;
response = "user";
}
}
}
return this.Json(response, JsonRequestBehavior.AllowGet);
}