public static DesignRequestViewModel GetById(int id)
{
DesignRequestViewModel result = new DesignRequestViewModel();
using (var db = new MarComContext())
{
result = (from d in db.T_Design
join e in db.T_Event
on d.T_Event_Id equals e.Id
join em in db.M_Employee
on d.Request_By equals em.Id
where id == d.Id
select new DesignRequestViewModel
{
Id = d.Id,
Code = d.Code,
T_Event_Id = d.T_Event_Id,
EventCode = e.Code,
Title_Header = d.Title_Header,
Status = d.Status,
Request_By = d.Request_By,
NameRequest = em.First_Name + " " + em.Last_Name,
Request_Date = d.Request_Date,
Note = d.Note
}).FirstOrDefault();
}
return(result);
}
public static DesignRequestViewModel GetId(int id)
{
DesignRequestViewModel result = new DesignRequestViewModel();
using (var db = new MarComContext())
{
result = (from dr in db.T_Design
join pr in db.T_Promotion
on dr.Id equals pr.T_Design_Id
join em in db.M_Employee
on dr.Request_By equals em.Id
join di in db.T_Design_Item
on dr.Id equals di.T_Design_Id
where pr.Id == id
select new DesignRequestViewModel
{
Id = dr.Id,
Code = dr.Code,
Title_Header = dr.Title_Header,
Request_By = dr.Request_By,
NameRequest = em.First_Name + "" + em.Last_Name,
Request_Date = dr.Request_Date,
Note = dr.Note
}).FirstOrDefault();
}
return(result);
}
//bikin list untuk view design request
public static DesignRequestViewModel GetDesReq(int id)
{
DesignRequestViewModel result = new DesignRequestViewModel();
using (var db = new MarComContext())
{
result = (from de in db.T_Design
join ev in db.T_Event on de.T_Event_Id equals ev.Id
join em in db.M_Employee on de.Request_By equals em.Id
//where id == de.Id
where de.Id == id
select new DesignRequestViewModel
{
Id = de.Id,
T_Event_Id = de.T_Event_Id,
Code = de.Code,
Request_By = de.Request_By,
Title_Header = de.Title_Header,
NameRequest = em.First_Name + " " + em.Last_Name,
Request_Date = de.Request_Date,
Note = de.Note
}).FirstOrDefault();
}
return(result);
}
public ActionResult Create(DesignRequestViewModel model, List <DesignItemViewModel> item)
{
model.Create_By = User.Identity.Name;
ResultResponse result = DesignRequestRepo.Update(model, item);
return(Json(new
{
success = result.Success,
entity = model,
message = result.Message
}, JsonRequestBehavior.AllowGet));
}
//EDIT
public ActionResult Edit(int id)
{
DesignRequestViewModel model = DesignRequestRepo.GetById(id);
ViewBag.DesignRequest = new SelectList(EventRepo.Get(), "Id", "Code");
UserViewModel access = DesignApproveRepo.GetIdByName(User.Identity.Name);
if (access.Role == "Requester" || access.Role == "Admin")
{
return(PartialView("_Edit", model));
}
else
{
return(new RedirectToRouteResult(new RouteValueDictionary(new { controller = "AccessDenied", action = "Index" })));
}
}
//GET : New Product
public ActionResult Create()
{
UserViewModel result = DesignRequestRepo.GetIdByName(User.Identity.Name);
DesignRequestViewModel model = new DesignRequestViewModel();
model.Request_By = result.M_Employee_Id;
model.NameRequest = result.Fullname;
model.Code = DesignRequestRepo.GetNewCode();
ViewBag.DesignRequest = new SelectList(EventRepo.Get(), "Id", "Code");
UserViewModel access = DesignApproveRepo.GetIdByName(User.Identity.Name);
if (access.Role == "Requester" || access.Role == "Admin")
{
return(PartialView("_Create", model));
}
else
{
return(new RedirectToRouteResult(new RouteValueDictionary(new { controller = "AccessDenied", action = "Index" })));
}
}
public static List <DesignRequestViewModel> Filter(DesignRequestViewModel entity)
{
List <DesignRequestViewModel> result = new List <DesignRequestViewModel>();
using (var db = new MarComContext())
{
result = (from d in db.T_Design
where d.Code.Contains(entity.Code) || d.Request_By == entity.Request_By || d.Request_Date == entity.Request_Date || d.Assign_To == entity.Assign_To || d.Status == entity.Status || d.Create_Date == entity.Create_Date || d.Create_By.Contains(entity.Create_By)
select new DesignRequestViewModel
{
Code = d.Code,
Request_By = d.Request_By,
Request_Date = d.Request_Date,
Assign_To = d.Assign_To,
Status = d.Status,
Create_Date = d.Create_Date,
Create_By = d.Create_By
}).ToList();
}
return(result);
}
//CREATE and EDIT
public static ResultResponse Update(DesignRequestViewModel entity, List <DesignItemViewModel> entityitem)
{
ResultResponse result = new ResultResponse();
try
{
using (var db = new MarComContext())
{
if (entity.Id == 0)
{
string newCode = GetNewCode();
T_Design design = new T_Design();
design.Code = newCode;
design.Title_Header = entity.Title_Header;
design.T_Event_Id = entity.T_Event_Id;
design.Request_By = entity.Request_By;
design.Request_Date = DateTime.Now;
design.Note = entity.Note;
design.Status = 1;
design.Create_Date = DateTime.Now;
design.Create_By = entity.Create_By;
db.T_Design.Add(design);
foreach (var item in entityitem)
{
T_Design_Item designItem = new T_Design_Item();
designItem.T_Design_Id = entity.Id;
designItem.M_Product_Id = item.M_Product_Id;
designItem.Title_Item = item.Title_Item;
designItem.Request_Pic = item.Request_Pic;
designItem.Request_Due_Date = item.Request_Due_Date;
designItem.Note = item.Note;
designItem.Is_Delete = item.Is_Delete;
designItem.Create_By = entity.Create_By;
designItem.Create_Date = DateTime.Now;
db.T_Design_Item.Add(designItem);
}
db.SaveChanges();
result.Message = "Data Saved ! Transaction Design Request has been add with code " + entity.Code;
}
else
{
T_Design design = db.T_Design.Where(td => td.Id == entity.Id).FirstOrDefault();
if (design != null)
{
design.Code = entity.Code;
design.T_Event_Id = entity.T_Event_Id;
design.Title_Header = entity.Title_Header;
design.Request_By = entity.Request_By;
design.Request_Date = DateTime.Now;
design.Note = entity.Note;
design.Status = 1;
design.Update_Date = DateTime.Now;
design.Update_By = entity.Update_By;
foreach (var item in entityitem)
{
T_Design_Item designItem = new T_Design_Item();
designItem.T_Design_Id = entity.Id;
designItem.M_Product_Id = item.M_Product_Id;
designItem.Title_Item = item.Title_Item;
designItem.Request_Pic = item.Request_Pic;
designItem.Request_Due_Date = item.Request_Due_Date;
designItem.Note = item.Note;
designItem.Is_Delete = item.Is_Delete;
if (item.Id == 0)
{
designItem.Create_By = entity.Update_By;
designItem.Create_Date = DateTime.Now;
}
else
{
designItem.Update_By = entity.Update_By;
designItem.Update_Date = DateTime.Now;
}
db.T_Design_Item.Add(designItem);
}
db.SaveChanges();
}
result.Message = "Data Update ! Transaction Design Request with code " + entity.Code + " has been update";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public ActionResult Filter(DesignRequestViewModel model)
{
return(PartialView("_List", DesignRequestRepo.Filter(model)));
}
//untuk view design request, menu ADD
public ActionResult DesignReq(int id)
{
DesignRequestViewModel model = PromotionRepo.GetDesReq(id);
return(PartialView("_DesignReq", model));
}
