public JsonResult InsertDMFlashBudgetDetails([FromBody] DMFlashBudgetDetails dmFlashViewData) { _log.LogInformation("DMFlashBudgetController : InsertDMFlashBudgetDetails - Start"); int res = 0; List <DMFlashBudgetViewModel> lstOfModifiedData = new List <DMFlashBudgetViewModel>(); lstOfModifiedData = dmFlashViewData.ListOfDMFlashBudgetData.Where(x => x.CurrentStatus.ToString().ToUpper().Equals("ADDED")).ToList(); if (lstOfModifiedData != null && lstOfModifiedData.Count() > 0) { decimal MaxFlashBudgetId = _dmFlashRepository.GetMaxDMFlashBudgetID(); List <TBK_Flash_Budget> listOfDMFlashBudget = new List <TBK_Flash_Budget>(); listOfDMFlashBudget = (from budgetData in lstOfModifiedData select new TBK_Flash_Budget { CAMPAIGN_ID = budgetData.CampaignId, SEGMENT_ID = budgetData.SegmentId, MAIL_VOLUME = budgetData.MailVolume, AVERAGE_TERM = budgetData.AverageTerm, AVERAGE_VALUE = budgetData.AverageValue, GROSS_SUBS = budgetData.GrossSubs, NET_SUBS = budgetData.NetSubs, MAIL_VOLUME_RFCT = budgetData.MailVolumeRfct, GROSS_SUBS_RFCT = budgetData.GrossSubsRfct, NET_SUBS_RFCT = budgetData.NetSubsRfct, AVERAGE_TERM_RFCT = budgetData.AverageTermRfct, AVERAGE_VALUE_RFCT = budgetData.AverageValueRfct, LAST_MODIFIED_DATE = DateTime.Now, LAST_MODIFIED_BY = budgetData.UpdatedBy }).ToList(); listOfDMFlashBudget.ForEach(x => x.FLASH_BUDGET_ID = ++MaxFlashBudgetId); res = _dmFlashRepository.InsertDMFlashBudgetData(listOfDMFlashBudget); } _log.LogInformation("DMFlashBudgetController : InsertDMFlashBudgetDetails - End"); return(Json(res)); }
public JsonResult GetDMFlashBudgetDetails(string magCode, string campYear, string campName, bool addMode) { _log.LogInformation("DMFlashBudgetController : GetDMFlashBudgetDetails - Start"); DMFlashBudgetDetails data = new DMFlashBudgetDetails(); List <DMFlashBudget> listOfData = new List <DMFlashBudget>(); _log.LogInformation("For MagCode {0}, Year {1}, CampaignName {2} and AddMode {3} ", magCode, campYear, campName, addMode); listOfData = _dmFlashRepository.GetDMFlashBudgetDetails(magCode, campYear, campName, addMode); data.ListOfDMFlashBudgetData = (from budgetData in listOfData select new DMFlashBudgetViewModel { FlashBudgetId = budgetData.Flash_Budget_Id, CampaignId = budgetData.Campaign_Id, SegmentId = budgetData.Segment_Id, Magazine = budgetData.Mag_Name, CampaignName = budgetData.Campaign_Name, MailDate = budgetData.Mail_Date, Segment = budgetData.Segment_Name, MailVolume = budgetData.Mail_Volume, GrossSubs = budgetData.Gross_Subs, NetSubs = budgetData.Net_Subs, AverageTerm = budgetData.Average_Term, AverageValue = budgetData.Average_Value, MailVolumeRfct = budgetData.Mail_Volume_Rfct, GrossSubsRfct = budgetData.Gross_Subs_Rfct, NetSubsRfct = budgetData.Net_Subs_Rfct, AverageTermRfct = budgetData.Average_Term_Rfct, AverageValueRfct = budgetData.Average_Value_Rfct, CurrentStatus = "ORIGINAL" }).ToList(); _log.LogInformation("DMFlashBudgetController : GetDMFlashBudgetDetails - End"); return(Json(data)); }