public static T_DesignItemViewModel GetById(int id) { T_DesignItemViewModel result = new T_DesignItemViewModel(); using (var db = new MarcomContext()) { result = (from di in db.t_design_item join d in db.t_design on di.t_design_id equals d.id join p in db.m_product on di.m_product_id equals p.id select new T_DesignItemViewModel { Id = di.id, TDesignId = d.id, MProductId = di.m_product_id, TitleItem = di.title_item, RequestPic = di.request_pic, StartDate = di.start_date, EndDate = di.end_date, RequestDueDate = di.request_due_date, Note = di.note, IsDelete = di.is_delete, CreatedBy = di.created_by, CreatedDate = di.created_date, UpdatedBy = di.updated_by, UpdatedDate = di.updated_date }).FirstOrDefault(); } 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); }