public ActionResult Create(int idEvent, int idDesign)
{
T_PromotionViewModel model = new T_PromotionViewModel();
model.TEventId = idEvent;
model.TDesignId = idDesign;
T_MarketingPromotionViewModel models = new T_MarketingPromotionViewModel();
models.Promotion = model;
//models.Promotion.TDesignId = model.TDesignId;
return(View("_Create", models));
}
public static T_PromotionViewModel GetById(int id)
{
T_PromotionViewModel result = new T_PromotionViewModel();
using (var db = new MarcomContext())
{
result = (from p in db.t_promotion
join e in db.t_event
on p.t_event_id equals e.id
where p.id == id
select new T_PromotionViewModel
{
Id = p.id,
Code = p.code,
FlagDesign = p.flag_design,
TEventId = p.t_event_id,
TEventCode = e.code,
TDesignId = p.t_design_id,
RequestBy = p.request_by,
RequestDate = p.request_date,
ApprovedBy = p.approved_by,
ApprovedDate = p.approved_date,
AssignTo = p.assign_to,
CloseDate = p.close_date,
Note = p.note,
Status = p.status,
RejectReason = p.reject_reason,
IsDelete = p.is_delete,
CreatedBy = p.created_by,
CreatedDate = p.created_date,
UpdatedBy = p.updated_by,
UpdatedDate = p.updated_date
}).FirstOrDefault();
}
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);
}
// POST: api/T_Promotions
public Responses Post([FromBody] T_PromotionViewModel entity)
{
return(T_PromotionRepo.Update(entity));
}
