public static Responses Update(T_PromotionItemFileViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
t_promotion_item_file tpifile = db.t_promotion_item_file.Where(tpif => tpif.id == entity.Id).FirstOrDefault();
if (tpifile != null)
{
tpifile.t_promotion_id = entity.TPromotionId;
tpifile.filename = entity.FileName;
tpifile.size = entity.Size;
tpifile.extention = entity.Extention;
tpifile.start_date = entity.StartDate;
tpifile.end_date = entity.EndDate;
tpifile.request_due_date = entity.RequestDueDate;
tpifile.qty = entity.Qty;
tpifile.todo = entity.Todo;
tpifile.note = entity.Note;
tpifile.is_delete = entity.IsDelete;
tpifile.updated_by = "Soleh";
tpifile.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
t_promotion_item_file tpifile = new t_promotion_item_file();
tpifile.t_promotion_id = entity.TPromotionId;
tpifile.filename = 0;
tpifile.size = entity.Size;
tpifile.extention = entity.Extention;
tpifile.start_date = entity.StartDate;
tpifile.end_date = entity.EndDate;
tpifile.request_due_date = entity.RequestDueDate;
tpifile.qty = entity.Qty;
tpifile.todo = entity.Todo;
tpifile.note = entity.Note;
tpifile.is_delete = false;
tpifile.created_by = "Soleh";
tpifile.created_date = DateTime.Now;
db.t_promotion_item_file.Add(tpifile);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(T_DesignItemViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
t_design_item di = db.t_design_item.Where(o => o.id == entity.Id).FirstOrDefault();
if (di != null)
{
di.t_design_id = entity.TDesignId;
di.m_product_id = entity.MProductId;
di.title_item = entity.TitleItem;
di.request_pic = entity.RequestPic;
di.start_date = entity.StartDate;
di.end_date = entity.EndDate;
di.request_due_date = entity.RequestDueDate;
di.note = entity.Note;
di.is_delete = entity.IsDelete;
di.updated_by = "Andra";
di.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
t_design_item di = new t_design_item();
di.t_design_id = entity.TDesignId;
di.m_product_id = entity.MProductId;
di.title_item = entity.TitleItem;
di.request_pic = entity.RequestPic;
di.start_date = entity.StartDate;
di.end_date = entity.EndDate;
di.request_due_date = entity.RequestDueDate;
di.note = entity.Note;
di.is_delete = entity.IsDelete;
di.created_by = "Andra";
di.created_date = DateTime.Now;
db.t_design_item.Add(di);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(T_DesignViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
t_design design = db.t_design.Where(o => o.id == entity.Id).FirstOrDefault();
if (design != null)
{
design.code = entity.Code;
design.t_event_id = entity.TEventId;
design.title_header = entity.TitleHeader;
design.request_by = entity.RequestBy;
design.request_date = entity.RequestDate;
design.assign_to = entity.AssignTo;
design.status = entity.Status;
design.note = entity.Note;
design.is_delete = false;
design.updated_by = "Ryan";
design.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
t_design design = new t_design();
design.code = entity.Code;
design.t_event_id = entity.TEventId;
design.title_header = entity.TitleHeader;
design.request_by = 6;
design.request_date = DateTime.Now;
design.assign_to = null;
design.status = 1;
design.note = entity.Note;
design.is_delete = false;
design.created_by = "Ryan";
design.created_date = DateTime.Now;
db.t_design.Add(design);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(M_EmployeeViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_employee employee = db.m_employee.Where(o => o.id == entity.Id).FirstOrDefault();
if (employee != null)
{
employee.id = entity.Id;
employee.employee_number = entity.EmployeeNumber;
employee.first_name = entity.FirstName;
employee.last_name = entity.LastName;
employee.m_company_id = entity.MCompanyId;
employee.email = entity.Email;
employee.is_delete = entity.IsDelete;
employee.updated_by = "Ryan";
employee.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_employee employee = new m_employee();
employee.id = entity.Id;
employee.employee_number = GetNewCode();
employee.first_name = entity.FirstName;
employee.last_name = entity.LastName;
employee.m_company_id = entity.MCompanyId;
employee.email = entity.Email;
employee.is_delete = false;
employee.created_by = "Ryan";
employee.created_date = DateTime.Now;
db.m_employee.Add(employee);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Delete(int Id)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
m_product m_product = db.m_product.Where(o => o.id == Id).FirstOrDefault();
if (m_product != null)
{
m_product.is_delete = true;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(M_CompanyViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_company company = db.m_company.Where(o => o.id == entity.Id).FirstOrDefault();
if (company != null)
{
company.code = entity.Code;
company.name = entity.Name;
company.address = entity.Address;
company.phone = entity.Phone;
company.email = entity.Email;
company.is_delete = entity.IsDelete;
company.updated_by = "Andra";
company.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_company company = new m_company();
company.code = GetNewCode();
company.name = entity.Name;
company.address = entity.Address;
company.phone = entity.Phone;
company.email = entity.Email;
company.is_delete = false;
company.created_by = "Andra";
company.created_date = DateTime.Now;
db.m_company.Add(company);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(M_SouvenirViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_souvenir souvenir = db.m_souvenir.Where(o => o.id == entity.Id).FirstOrDefault();
if (souvenir != null)
{
souvenir.id = entity.Id;
souvenir.code = entity.Code;
souvenir.name = entity.Name;
souvenir.description = entity.Description;
souvenir.m_unit_id = entity.mUnitId;
souvenir.is_delete = entity.isDelete;
souvenir.updated_by = "Asyam";
souvenir.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_souvenir souvenir = new m_souvenir();
souvenir.id = entity.Id;
souvenir.code = entity.Code;
souvenir.name = entity.Name;
souvenir.description = entity.Description;
souvenir.m_unit_id = entity.mUnitId;
souvenir.is_delete = false;
souvenir.created_by = "Asyam";
souvenir.created_date = DateTime.Now;
db.m_souvenir.Add(souvenir);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(M_UserViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_user mUser = db.m_user.Where(u => u.id == entity.Id).FirstOrDefault();
if (mUser != null)
{
mUser.username = entity.Username;
mUser.password = entity.Password;
mUser.m_employee_id = entity.MEmployeeId;
mUser.m_role_id = entity.MRoleId;
mUser.updated_by = "Admin";
mUser.updated_date = DateTime.Now;
mUser.is_delete = false;
db.SaveChanges();
}
}
else
{
m_user mUser = new m_user();
mUser.username = entity.Username;
mUser.password = entity.Password;
mUser.m_employee_id = entity.MEmployeeId;
mUser.m_role_id = entity.MRoleId;
mUser.created_by = "Admin";
mUser.created_date = DateTime.Now;
mUser.is_delete = false;
db.m_user.Add(mUser);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(M_MenuViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_menu menu = db.m_menu.Where(m => m.id == entity.Id && m.id != entity.ParentId).FirstOrDefault();
if (menu != null)
{
menu.code = entity.Code;
menu.name = entity.Name;
menu.controller = entity.Controller;
menu.parent_id = entity.ParentId;
menu.is_delete = entity.IsDelete;
menu.updated_by = "Soleh";
menu.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_menu menu = new m_menu();
menu.code = GetNewCode();
menu.name = entity.Name;
menu.controller = entity.Controller;
menu.parent_id = entity.ParentId;
menu.is_delete = false;
menu.created_by = "Soleh";
menu.created_date = DateTime.Now;
db.m_menu.Add(menu);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses update(M_ProductViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_product m_product = db.m_product.Where(o => o.id == entity.Id).FirstOrDefault();
if (m_product != null)
{
m_product.code = entity.Code;
m_product.name = entity.Name;
m_product.description = entity.Description;
m_product.is_delete = entity.IsDelete;
m_product.updated_by = "David";
m_product.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_product m_product = new m_product();
m_product.code = entity.Code;
m_product.name = entity.Name;
m_product.description = entity.Description;
m_product.is_delete = entity.IsDelete;
m_product.created_by = entity.CreatedBy;
m_product.created_date = DateTime.Now;
db.m_product.Add(m_product);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(M_RoleViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_role role = db.m_role.Where(o => o.id == entity.Id).FirstOrDefault();
if (role != null)
{
role.code = entity.Code;
role.name = entity.Name;
role.description = entity.Description;
role.is_delete = entity.IsDelete;
role.updated_by = "Freeska";
role.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_role role = new m_role();
role.code = entity.Code;
role.name = entity.Name;
role.description = entity.Description;
role.is_delete = entity.IsDelete;
role.created_by = "Freeska";
role.created_date = DateTime.Now;
db.m_role.Add(role);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(M_MenuAccessViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_menu_access mAccess = db.m_menu_access.Where(o => o.id == entity.Id).FirstOrDefault();
if (mAccess != null)
{
mAccess.m_menu_id = entity.MMenuId;
mAccess.m_role_id = entity.MRoleId;
mAccess.is_delete = entity.IsDelete;
mAccess.created_by = "csk";
mAccess.created_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_menu_access mAccess = new m_menu_access();
mAccess.m_menu_id = entity.MMenuId;
mAccess.m_role_id = entity.MRoleId;
mAccess.is_delete = false;
mAccess.created_by = "csk";
mAccess.created_date = DateTime.Now;
db.m_menu_access.Add(mAccess);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Delete(int id)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
m_user mUser = db.m_user.Where(u => u.id == id).FirstOrDefault();
if (mUser != null)
{
mUser.is_delete = true;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Delete(int id)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
t_design design = db.t_design.Where(o => o.id == id).FirstOrDefault();
if (design != null)
{
design.is_delete = true;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Delete(int id)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
t_promotion_item_file tpifile = db.t_promotion_item_file.Where(m => m.id == id).FirstOrDefault();
if (tpifile != null)
{
tpifile.is_delete = true;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(T_PromotionItemViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
t_promotion_item promotion = db.t_promotion_item.Where(o => o.id == entity.Id).FirstOrDefault();
if (promotion != null)
{
promotion.id = entity.Id;
promotion.t_promotion_id = entity.TPromotionId;
promotion.t_design_item_id = entity.TDesignItemId;
promotion.m_product_id = entity.MProductId;
promotion.title = entity.Title;
promotion.request_pic = entity.RequestPic;
promotion.start_date = entity.StartDate;
promotion.end_date = entity.EndDate;
promotion.request_due_date = entity.RequestDueDate;
promotion.qty = entity.Qty;
promotion.todo = entity.ToDo;
promotion.note = entity.Note;
promotion.is_delete = entity.isDelete;
promotion.updated_by = "Asyam";
promotion.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
t_promotion_item promotion = new t_promotion_item();
promotion.id = entity.Id;
promotion.t_promotion_id = entity.TPromotionId;
promotion.t_design_item_id = entity.TDesignItemId;
promotion.m_product_id = entity.MProductId;
promotion.title = entity.Title;
promotion.request_pic = entity.RequestPic;
promotion.start_date = entity.StartDate;
promotion.end_date = entity.EndDate;
promotion.request_due_date = entity.RequestDueDate;
promotion.qty = entity.Qty;
promotion.todo = entity.ToDo;
promotion.note = entity.Note;
promotion.is_delete = entity.isDelete;
promotion.created_by = "Asyam";
promotion.created_date = DateTime.Now;
db.t_promotion_item.Add(promotion);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(T_EventViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
t_event ev = db.t_event.Where(o => o.id == entity.Id).FirstOrDefault();
if (ev != null)
{
ev.id = entity.Id;
ev.code = entity.Code;
ev.event_name = entity.EventName;
ev.start_date = entity.StartDate;
ev.end_date = entity.EndDate;
ev.place = entity.Place;
ev.budget = entity.Budget;
ev.request_by = entity.RequestBy;
ev.request_date = entity.RequestDate;
ev.approved_by = entity.ApprovedBy;
ev.approved_date = entity.ApprovedDate;
ev.assign_to = entity.AssignTo;
ev.closed_date = entity.ClosedDate;
ev.note = entity.Note;
ev.status = entity.Status;
ev.reject_reason = entity.RejectReason;
ev.is_delete = entity.IsDelete;
ev.updated_by = "Admin";
ev.updated_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
t_event ev = new t_event();
ev.id = entity.Id;
ev.code = GetNewCode();
ev.event_name = entity.EventName;
ev.start_date = entity.StartDate;
ev.end_date = entity.EndDate;
ev.place = entity.Place;
ev.budget = entity.Budget;
ev.request_by = entity.RequestBy;
ev.request_date = DateTime.Now;
ev.approved_by = entity.ApprovedBy;
ev.approved_date = entity.ApprovedDate;
ev.assign_to = entity.AssignTo;
ev.closed_date = entity.ClosedDate;
ev.note = entity.Note;
ev.status = 1;
ev.reject_reason = entity.RejectReason;
ev.is_delete = false;
ev.created_by = "Admin";
ev.created_date = DateTime.Now;
db.t_event.Add(ev);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
public static Responses Update(T_PromotionViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
t_promotion promotion = db.t_promotion.Where(o => o.id == entity.Id).FirstOrDefault();
if (promotion != null)
{
t_promotion p = new t_promotion();
p.id = entity.Id;
p.code = entity.Code;
p.flag_design = entity.FlagDesign;
p.t_event_id = entity.TEventId;
p.t_design_id = entity.TDesignId;
p.request_by = entity.RequestBy;
p.request_date = entity.RequestDate;
p.approved_by = entity.ApprovedBy;
p.approved_date = entity.ApprovedDate;
p.assign_to = entity.AssignTo;
p.close_date = entity.CloseDate;
p.note = entity.Note;
p.status = entity.Status;
p.reject_reason = entity.RejectReason;
p.is_delete = entity.IsDelete;
p.updated_by = "Freeska";
p.updated_date = DateTime.Now;
foreach (var item in entity.DetailItem)
{
t_promotion_item pItem = db.t_promotion_item.Where(o => o.t_promotion_id == entity.Id).FirstOrDefault();
if (pItem != null)
{
t_promotion_item pi = new t_promotion_item();
pi.id = item.Id;
pi.t_promotion_id = entity.Id;
pi.t_design_item_id = item.TDesignItemId;
pi.m_product_id = item.MProductId;
pi.title = item.Title;
pi.request_pic = item.RequestPic;
pi.start_date = item.StartDate;
pi.end_date = item.EndDate;
pi.request_due_date = item.RequestDueDate;
pi.qty = item.Qty;
pi.todo = item.ToDo;
pi.note = item.Note;
pi.is_delete = item.isDelete;
pi.updated_by = "Freeska";
pi.updated_date = DateTime.Now;
}
}
db.SaveChanges();
}
}
else
{
t_promotion p = new t_promotion();
p.id = entity.Id;
p.code = "TRWOMP0000012";
p.flag_design = "1";
p.t_event_id = entity.TEventId;
p.t_design_id = entity.TDesignId;
p.request_by = entity.RequestBy;
p.request_date = entity.RequestDate;
p.approved_by = entity.ApprovedBy;
p.approved_date = entity.ApprovedDate;
p.assign_to = entity.AssignTo;
p.close_date = entity.CloseDate;
p.note = entity.Note;
p.status = entity.Status;
p.reject_reason = entity.RejectReason;
p.is_delete = entity.IsDelete;
p.created_by = "Freeska";
p.created_date = DateTime.Now;
foreach (var item in entity.DetailItem)
{
t_promotion_item pi = new t_promotion_item();
pi.id = item.Id;
pi.t_promotion_id = entity.Id;
pi.t_design_item_id = item.TDesignItemId;
pi.m_product_id = item.MProductId;
pi.title = item.Title;
pi.request_pic = 2;
pi.start_date = item.StartDate;
pi.end_date = item.EndDate;
pi.request_due_date = item.RequestDueDate;
pi.qty = item.Qty;
pi.todo = item.ToDo;
pi.note = item.Note;
pi.is_delete = item.isDelete;
pi.created_by = "Freeska";
pi.created_date = DateTime.Now;
db.t_promotion_item.Add(pi);
}
db.t_promotion.Add(p);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}