private UnderBankingDTO Map(tblRecollection tbl) { var costcentre = _context.tblCostCentre.FirstOrDefault(s => s.Id == tbl.FromCostCentreId); var dto = new UnderBankingDTO(); dto.MasterId = tbl.Id; dto.DateCreated = tbl.IM_DateCreated; dto.DateLastUpdated = tbl.IM_DateLastUpdated; dto.StatusId = tbl.IM_Status; dto.Description = tbl.Description; dto.Amount = tbl.Amount; dto.CostCentreId = tbl.FromCostCentreId; var items = tbl.tblRecollectionItem.ToList(); dto.TotalReceivedAmount = items.Sum(s => s.Amount); dto.Items = items.Select(s => new UnderBankingItemDTO{Amount = s.Amount,Id = s.Id,IsConfirmed = s.IsComfirmed, UnderBankingId = s.RecollectionId} ).ToArray(); dto.CostCentreName = costcentre != null ? costcentre.Name : ""; return dto; }
private UnderBankingItemSummary MapSummary(tblRecollection s) { if (s == null) return null; var salesman = _ctx.tblCostCentre.FirstOrDefault(n => n.Id == s.CostCentreId); var costcentre = _ctx.tblCostCentre.FirstOrDefault(n => n.Id == s.FromCostCentreId); var reco = new UnderBankingItemSummary(s.Id) { CostCentreId = s.FromCostCentreId, CostCentreName = costcentre!=null?costcentre.Name:"", CostCentreType = costcentre != null ? ((CostCentreType)costcentre.CostCentreType).ToString() : "", SalesmanId = s.CostCentreId, SalesmanName = salesman != null ? salesman.Name : "", Description = s.Description, Amount = s.Amount, ReceivedAmount = s.tblRecollectionItem.Sum(o => o.Amount), ConfirmedAmount = s.tblRecollectionItem.Where(o=>o.IsComfirmed).Sum(o => o.Amount), _DateCreated = s.IM_DateCreated, _DateLastUpdated = s.IM_DateLastUpdated, }; return reco; }
/// <summary> /// Create a new tblRecollection object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="costCentreId">Initial value of the CostCentreId property.</param> /// <param name="fromCostCentreId">Initial value of the FromCostCentreId property.</param> /// <param name="amount">Initial value of the Amount property.</param> /// <param name="isReceived">Initial value of the IsReceived property.</param> /// <param name="dateInserted">Initial value of the DateInserted property.</param> /// <param name="iM_DateCreated">Initial value of the IM_DateCreated property.</param> /// <param name="iM_DateLastUpdated">Initial value of the IM_DateLastUpdated property.</param> /// <param name="iM_Status">Initial value of the IM_Status property.</param> public static tblRecollection CreatetblRecollection(global::System.Guid id, global::System.Guid costCentreId, global::System.Guid fromCostCentreId, global::System.Decimal amount, global::System.Boolean isReceived, global::System.DateTime dateInserted, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status) { tblRecollection tblRecollection = new tblRecollection(); tblRecollection.Id = id; tblRecollection.CostCentreId = costCentreId; tblRecollection.FromCostCentreId = fromCostCentreId; tblRecollection.Amount = amount; tblRecollection.IsReceived = isReceived; tblRecollection.DateInserted = dateInserted; tblRecollection.IM_DateCreated = iM_DateCreated; tblRecollection.IM_DateLastUpdated = iM_DateLastUpdated; tblRecollection.IM_Status = iM_Status; return tblRecollection; }
/// <summary> /// Deprecated Method for adding a new object to the tblRecollection EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotblRecollection(tblRecollection tblRecollection) { base.AddObject("tblRecollection", tblRecollection); }
private UnderBankingItem Map(tblRecollection s) { if (s == null) return null; var reco = new UnderBankingItem(s.Id) { FromCostCentreId = s.CostCentreId, Description = s.Description, Amount = s.Amount, _DateCreated = s.IM_DateCreated, _DateLastUpdated = s.IM_DateLastUpdated, TotalReceivedAmount = s.tblRecollectionItem.Sum(o=>o.Amount), }; return reco; }