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));
}
