public JsonResult MonthlyReport(string year, string month) { string[] value = User.Identity.Name.Split('|'); ML.OFW.Contracts.Models.billsPayModel.MonthlyBillsPayReport smodel = new OFW.Contracts.Models.billsPayModel.MonthlyBillsPayReport(); smodel.accountNo = value[1].Trim(); smodel.UserName = value[0].Trim(); smodel.month = Convert.ToInt32(month); smodel.year = Convert.ToInt32(year); ML.OFW.Services.OFW service = new OFW.Services.OFW(); var respVal = service.MonthlySendoutBillsPayReport(smodel); var model = new IenumerableReportResult(); if (respVal.respCode != "0") { model.monthlyReport = respVal.listTransactions; int hasData = model.monthlyReport.Count(); var model1 = new ReportsViewModel(); model1.PrintBy = respVal.printBy; model1.Date = respVal.date; model1.runDate = respVal.runDate; model1.TotalCount = respVal.totalCount.ToString(); model1.TotalCommission = String.Format("{0:#,##0.00}", Convert.ToDecimal(respVal.totalCommission)); model1.TotalAmount = String.Format("{0:#,##0.00}", Convert.ToDecimal(respVal.totalPrincipal)); if (hasData > 0) { return(Json(new { status = true, respCode = "1", msg = respVal.respMsg, transDate = respVal.runDate, printBy = respVal.printBy, Date = respVal.date, hasRecord = hasData, otherData = model1, monthlyReport = RenderPartialViewToString("_reportMonthly", model), }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = true, respCode = "0", msg = respVal.respMsg, hasRecord = hasData }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = false, respCode = "0", msg = respVal.respMsg, }, JsonRequestBehavior.AllowGet)); }
public JsonResult MonthlyCancellationReport(string year, string month) { string[] value = User.Identity.Name.Split('|'); ML.OFW.Contracts.Models.billsPayModel.MonthlyBillsPayReport smodel = new OFW.Contracts.Models.billsPayModel.MonthlyBillsPayReport(); smodel.accountNo = value[1].Trim(); smodel.UserName = value[0].Trim(); smodel.month = Convert.ToInt32(month); smodel.year = Convert.ToInt32(year); ML.OFW.Services.OFW service = new OFW.Services.OFW(); var respVal = service.MonthlyCancelBillsPayReport(smodel); var model = new IenumerableReportResult(); if (respVal.respCode != "0") { model.monthlyReport = respVal.listTransactions; int hasData = model.monthlyReport.Count(); if (hasData > 0) { return(Json(new { status = true, respCode = "1", msg = respVal.respMsg, transDate = respVal.runDate, printBy = respVal.printBy, Date = respVal.date, hasRecord = hasData, monthlyReport = RenderPartialViewToString("_reportMonthly", model), }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = true, respCode = "0", msg = respVal.respMsg, hasRecord = hasData }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = false, respCode = "0", msg = respVal.respMsg, }, JsonRequestBehavior.AllowGet)); }