public static Responses Delete(int id)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
t_promotion promotion = db.t_promotion.Where(o => o.id == id).FirstOrDefault();
if (promotion != null)
{
promotion.is_delete = true;
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);
}
