// 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 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 CompleteOrder(int id)
{
MyDatabaseEntities ctx = new MyDatabaseEntities();
Order u = ctx.Orders.FirstOrDefault(x => x.OrderId == id);
string response = "failed";
if (u != null)
{
u.Status = "DONE";
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 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);
}
