public static T_DesignViewModel GetById(int id)
{
T_DesignViewModel result = new T_DesignViewModel();
using (var db = new MarcomContext())
{
result = (from d in db.t_design
where d.id == id
select new T_DesignViewModel
{
Id = d.id,
Code = d.code,
TitleHeader = d.title_header,
RequestBy = d.request_by,
RequestDate = d.request_date,
AssignTo = d.assign_to,
Status = d.status,
Note = d.note,
IsDelete = d.is_delete,
CreatedBy = d.created_by,
CreatedDate = d.created_date
}).FirstOrDefault();
}
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);
}
// POST: api/T_Designs
public Responses Post([FromBody] T_DesignViewModel entity)
{
//Responses result = new Responses();
//if (ModelState.IsValid)
//{
return(T_DesignRepo.Update(entity));
//}
//else
//{
// result.Success = false;
//}
//return result;
}
// PUT: api/T_Designs/5
public Responses Put(int id, [FromBody] T_DesignViewModel entity)
{
entity.Id = id;
Responses result = new Responses();
if (ModelState.IsValid)
{
result = T_DesignRepo.Update(entity);
}
else
{
result.Success = false;
}
return(result);
}
