public ActionResult List() { AccruedSummaryReportService service = new AccruedSummaryReportService(); AccruedDetailReportViewModel model = service.InitialListSearch(); return(View("~/Views/AccruedSummaryReport/AccruedSummaryReportList.cshtml", model)); }
public ActionResult GetCompany(string bu) { AccruedSummaryReportService service = new AccruedSummaryReportService(); AccruedDetailReportViewModel model = new AccruedDetailReportViewModel(); model = service.InitialCompany(bu); return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult SubmitForm(AccruedDetailReportViewModel formData) { AccruedSummaryReportService service = new AccruedSummaryReportService(); byte[] filecontent = service.SubmitFormFileContent(formData); //return null; //DataTable dt = service.ExportReport(); //string g = ""; //string[] columns = dt.Columns.Cast<DataColumn>() // .Select(x => x.ColumnName) // .ToArray(); //byte[] filecontent = ExcelExportHelper.ExportExcel(dt, "Actual TMN Expense 2018", false, columns); string reportTypeName = "All"; if (formData.FEE_TYPE == "2") { reportTypeName = "Accrued"; } else if (formData.FEE_TYPE == "3") { reportTypeName = "Actual"; } if (filecontent == null) { return(List()); } else { return(File(filecontent, ExcelExportHelper.ExcelContentType, reportTypeName + " TMN Expense " + formData.END_YEAR + ".xlsx")); } }
public List <AccruedDetailReportViewModel> GetInvoiceList() { List <AccruedDetailReportViewModel> modelList = new List <AccruedDetailReportViewModel>(); try { using (var context = new PYMFEEEntities()) { var ent_company = (from m in context.COMPANies where m.IsPaymentFee == true select m).ToList(); var ent_invList = (from m in context.FEE_INVOICE orderby m.INV_MONTH, m.INV_YEAR select m).ToList(); //var ent_invItemList = (from m in context.FEE_INVOICE_ITEM orderby m.INV_MONTH, m.INV_YEAR select m).ToList(); var ent_pymList = (from m in context.PAYMENT_ITEMS where m.IS_ACTIVE == true orderby m.GROUP_SEQ_CHANNELS select m).ToList(); //var ent_pymChargeList = (from m in context.PAYMENT_ITEMS_CHAGE select m).ToList(); string getComp = "TI"; var get_invList = (from m in ent_invList where m.INV_MONTH >= 1 && m.INV_MONTH <= DateTime.Now.Date.Month && m.COMPANY_CODE == getComp select m).ToList(); ent_pymList = ent_pymList.Where(m => m.COMPANY_CODE == getComp).ToList(); var culture = CultureInfo.GetCultureInfo("en-US"); var dateTimeInfo = DateTimeFormatInfo.GetInstance(culture); var get_month = (DateTime.Now.Date.Year * 12 + DateTime.Now.Date.Month) - (DateTime.Now.Date.Year * 12 + 1); foreach (var item in ent_pymList) { var data_inv = get_invList.Where(m => m.PAYMENT_ITEMS_CODE == item.PAYMENT_ITEMS_CODE).ToList(); var model = new AccruedDetailReportViewModel(); model.FEE = "Inv. No."; for (int i = 0; i <= get_month; i++) { string inv = ""; //Convert.ToString(string.Format("{0:#,##0.####}", amt))); var data_invMonth = data_inv.Where(m => m.INV_MONTH == i + 1 && m.INV_YEAR == DateTime.Now.Date.Year).FirstOrDefault(); inv = data_invMonth == null ? "" : data_invMonth.INV_NO; string monthIndex = dateTimeInfo.AbbreviatedMonthNames[i]; model.GetType().GetProperty(monthIndex).SetValue(model, inv); } model.CHARGE = "1"; modelList.Add(model); model = new AccruedDetailReportViewModel(); model.FEE = "Inv. Pro."; for (int i = 0; i <= get_month; i++) { string pro = ""; //Convert.ToString(string.Format("{0:#,##0.####}", amt))); var data_invMonth = data_inv.Where(m => m.INV_MONTH == i + 1 && m.INV_YEAR == DateTime.Now.Date.Year).FirstOrDefault(); pro = data_invMonth == null ? "" : data_invMonth.PRO_NO; string monthIndex = dateTimeInfo.AbbreviatedMonthNames[i]; model.GetType().GetProperty(monthIndex).SetValue(model, pro); } model.CHARGE = "2"; modelList.Add(model); model = new AccruedDetailReportViewModel(); model.FEE = item.PAYMENT_ITEMS_NAME; for (int i = 0; i <= get_month; i++) { decimal amt = 0; //Convert.ToString(string.Format("{0:#,##0.####}", amt))); var data_invMonth = data_inv.Where(m => m.INV_MONTH == i + 1 && m.INV_YEAR == DateTime.Now.Date.Year).FirstOrDefault(); amt = data_invMonth == null ?0 :(data_invMonth.NET_AMOUNT ?? 0); string monthIndex = dateTimeInfo.AbbreviatedMonthNames[i]; model.GetType().GetProperty(monthIndex).SetValue(model, Convert.ToString(string.Format("{0:#,##0.####}", amt))); } model.CHARGE = "3"; modelList.Add(model); } } } catch (Exception ex) { throw; } return(modelList); }