public List <CashBookPostCostData> UpdatePostCostData(int userId, object dtoItem, out Notification notification) { notification = new Notification() { Type = NotificationType.Success }; CashBookPostCostData dataItem = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <CashBookPostCostData>(); List <CashBookPostCostData> postCostData = new List <CashBookPostCostData>(); try { using (var context = CreateContext()) { CashBookPostCost dbItem; if (dataItem.CashBookPostCostID > 0) { dbItem = context.CashBookPostCost.FirstOrDefault(o => o.CashBookPostCostID == dataItem.CashBookPostCostID); if (dbItem == null) { notification.Type = NotificationType.Error; notification.Message = "Can not found data!"; return(postCostData); } } else { dbItem = new CashBookPostCost(); context.CashBookPostCost.Add(dbItem); } converter.DTO2DB_CashBookPostCost(dataItem, ref dbItem); dbItem.UpdatedBy = userId; dbItem.UpdatedDate = DateTime.Now; context.SaveChanges(); postCostData = converter.DB2DTO_CashBookPostCost(context.CashBookMng_CashBookPostCost_View.ToList()); } return(postCostData); } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = ex.Message; return(postCostData); } }
public bool DeletePostCostData(int id, out Notification notification) { notification = new Notification() { Type = NotificationType.Success }; try { using (var context = CreateContext()) { CashBookPostCost dbItem = context.CashBookPostCost.FirstOrDefault(o => o.CashBookPostCostID == id); if (dbItem == null) { notification.Type = NotificationType.Error; notification.Message = "Can not found data!"; return(false); } // set null for all item using it. var dbItem2 = context.CashBook.Where(o => o.CashBookPostCostID == dbItem.CashBookPostCostID); foreach (var item in dbItem2) { item.CashBookPostCostID = null; item.CashBookCostItemID = null; item.CashBookCostItemDetailID = null; } context.CashBookPostCost.Remove(dbItem); context.SaveChanges(); return(true); } } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = ex.Message; return(false); } }
public void DTO2DB_CashBookPostCost(DTO.CashBookPostCostData dataItem, ref CashBookPostCost dbItem) { AutoMapper.Mapper.Map <DTO.CashBookPostCostData, CashBookPostCost>(dataItem, dbItem); }