public static ResponResultViewModel Delete(int id)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
Student st = db.Students.Where(x => x.id == id).FirstOrDefault();
if (st != null)
{
result.Entity = st;
db.Students.Remove(st);
db.SaveChanges();
}
else
{
result.Success = false;
result.Message = "Students not found";
}
}
}
catch (Exception e)
{
result.Success = false;
result.Message = e.Message;
}
return(result);
}
public static ResponResultViewModel Delete(int id)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
Product prod = db.Products.Where(x => x.id == id).FirstOrDefault();
if (prod != null)
{
result.Entity = prod;
db.Products.Remove(prod);
db.SaveChanges();
}
else
{
result.Success = false;
result.Message = "Products not found";
}
}
}
catch (Exception e)
{
result.Success = false;
result.Message = "Category memiliki Product, tidak dapat dihapus";
}
return(result);
}
public static ResponResultViewModel Update(TableViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Table table = new Table();
table.initial = entity.initial;
table.Seat = entity.Seat;
table.Desc = entity.Desc;
table.Active = entity.Active;
table.CreateBy = "Bloblo";
table.CreateDate = DateTime.Now;
db.Tables.Add(table);
db.SaveChanges();
result.Entity = table;
}
//Edit
else
{
Table table = db.Tables.Where(o => o.id == entity.id).FirstOrDefault();
if (table != null)
{
table.initial = entity.initial;
table.Seat = entity.Seat;
table.Desc = entity.Desc;
table.Active = entity.Active;
table.ModifyBy = "Booboo";
table.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "table not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel Update(CategoryViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Category category = new Category();
category.initial = entity.initial;
category.Name = entity.Name;
category.Active = entity.Active;
category.CreateBy = "Bloblo";
category.CreateDate = DateTime.Now;
db.Categories.Add(category);
db.SaveChanges();
result.Entity = category;
}
//Edit
else
{
Category category = db.Categories.Where(o => o.id == entity.id).FirstOrDefault();
if (category != null)
{
category.initial = entity.initial;
category.Name = entity.Name;
category.Active = entity.Active;
category.ModifyBy = "Booboo";
category.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Category not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel WorkFlow(OrderViewModel entity)
{
ResponResultViewModel res = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
if (entity.id == 0)
{
Order ord = new Order();
ord.reservid = entity.reservid;
ord.productid = entity.productid;
ord.quantity = entity.quantity;
ord.price = entity.price;
ord.status = entity.status + 1;
ord.Active = true;
ord.CreateBy = "OrderBlu";
ord.CreateDate = DateTime.Now;
db.Orders.Add(ord);
db.SaveChanges();
res.Entity = ord;
}
else
{
Order order = db.Orders.Where(o => o.id == entity.id).FirstOrDefault();
if (order == null)
{
res.Success = false;
res.Message = "Ord Not FOund";
}
else
{
order.status = order.status + 1;
db.SaveChanges();
res.Entity = entity;
}
}
}
}
catch (Exception e)
{
res.Success = false;
res.Message = e.Message;
}
return(res);
}
public static ResponResultViewModel Update(ReservationVIewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
entity.reference = GerReff();
try
{
using (var db = new KitchenContext())
{
if (entity.id == 0)
{
Reservation reserv = new Reservation();
reserv.guest = entity.guest;
reserv.reference = entity.reference;
reserv.tableid = entity.tableid;
reserv.Paid = false;
reserv.CreateBy = "Floofloo";
reserv.CreateDate = DateTime.Now;
reserv.Active = true;
db.Reservations.Add(reserv);
db.SaveChanges();
result.Entity = entity;
}
else
{
Reservation reserv = db.Reservations.Where(r => r.id == entity.id).FirstOrDefault();
reserv.guest = entity.guest;
reserv.ModifyBy = "BlubluRese";
reserv.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ee)
{
result.Success = false;
result.Message = ee.Message;
}
return(result);
}
public static ResponResultViewModel Update(ProductViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Product product = new Product();
product.initial = entity.initial;
product.name = entity.name;
product.description = entity.description;
product.categoryid = entity.categoryid;
product.price = entity.price;
product.Active = entity.Active;
product.CreateBy = "Bloblo";
product.CreateDate = DateTime.Now;
db.Products.Add(product);
db.SaveChanges();
result.Entity = product;
}
//Edit
else
{
Product product = db.Products.Where(o => o.id == entity.id).FirstOrDefault();
if (product != null)
{
product.initial = entity.initial;
product.name = entity.name;
product.description = entity.description;
product.categoryid = entity.categoryid;
product.price = entity.price;
product.Active = entity.Active;
product.ModifyBy = "Bloblo";
product.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Prod not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel Update(StudentViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Student st = new Student();
st.firstname = entity.firstname;
st.lastname = entity.lastname;
st.gender = entity.gender;
st.dob = entity.dob;
st.pob = entity.pob;
st.Active = entity.Active;
st.CreateBy = "Blobloblo";
st.CreateDate = DateTime.Now;
db.Students.Add(st);
db.SaveChanges();
result.Entity = st;
}
//Edit
else
{
Student st = db.Students.Where(o => o.id == entity.id).FirstOrDefault();
if (st != null)
{
st.firstname = entity.firstname;
st.lastname = entity.lastname;
st.gender = entity.gender;
st.dob = entity.dob;
st.pob = entity.pob;
st.Active = entity.Active;
st.ModifyBy = "Booboo";
st.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Student not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}