public FileContentResult SubmitFormReportExport()
{
AccruedService service = new AccruedService();
//DataTable dt = service.ExportReport();
//string g = "";
var dt = new System.Data.DataTable("test");
dt.Columns.Add("col1", typeof(int));
dt.Columns.Add("col2", typeof(string));
dt.Rows.Add(1, "product 1");
dt.Rows.Add(2, "product 2");
dt.Rows.Add(3, "product 3");
dt.Rows.Add(4, "product 4");
dt.Rows.Add(5, "product 5");
dt.Rows.Add(6, "product 6");
dt.Rows.Add(7, "product 7");
string[] columns = dt.Columns.Cast <DataColumn>()
.Select(x => x.ColumnName)
.ToArray();
byte[] filecontent = ExcelExportHelper.ExportExcel(dt, "Technology", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Technologies.xlsx"));
}
public ActionResult List()
{
ViewBag.Title = UtilityService.GetPagetTitlePrefix(ConstantVariableService.FormStateList);
ViewBag.DisplayOnly = AuthorizeService.CheckDisplayOnly(new[] { AccruedViewModel.RoleForManageData });
AccruedService service = new AccruedService();
AccruedViewModel model = service.InitialListSearch();
return(View("~/Views/Accrued/AccruedList.cshtml", model));
}
public ActionResult Manage(int recordKey, string formState)
{
AccruedService service = new AccruedService();
AccruedViewModel AccruedViewModel = service.InitialDetailView(recordKey, formState);
if (AccruedViewModel != null)
{
ViewBag.Title = UtilityService.GetPagetTitlePrefix(formState);
return(View("~/Views/Accrued/AccruedDetail.cshtml", AccruedViewModel));
}
else
{
//return to List page
ViewBag.Title = UtilityService.GetPagetTitlePrefix(ConstantVariableService.FormStateList);
return(View("~/Views/Accrued/AccruedList.cshtml"));
}
}
//[HttpGet]
//public ActionResult List()
//{
// ViewBag.Title = UtilityService.GetPagetTitlePrefix(ConstantVariableService.FormStateList);
// AccruedService service = new AccruedService();
// AccruedViewModel model = service.InitialListSearch();
// return View("~/Views/Accrued/AccruedDetail.cshtml", model);
//}
////For ajax load list data
//[AuthorizeService(AllowRoleList = new[] { InvoiceViewModel.RoleForDisplayData, InvoiceViewModel.RoleForManageData })]
//public string GetList(string companyCode, int monthValue, int yearValue)
//{
// AccruedService service = new AccruedService();
// return service.GetList(companyCode, monthValue, yearValue);
//}
//[HttpPost]
//[AuthorizeService(AllowRoleList = new[] { InvoiceViewModel.RoleForManageData })]
//public ActionResult SubmitForm(AccruedViewModel formData)
//{
// AccruedService service = new AccruedService();
// ValidationResult result = service.SubmitForm(formData, ModelState);
// return Json(
// new { success = !result.ErrorFlag, responseText = result.Message, errorList = result.ModelStateErrorList },
// JsonRequestBehavior.AllowGet
// );
//}
// [HttpGet]
// [AuthorizeService(AllowRoleList = new[] { InvoiceViewModel.RoleForDisplayData, InvoiceViewModel.RoleForManageData })]
// public ActionResult Detail()
// {
// AccruedService service = new AccruedService();
// AccruedViewModel accruedLst = service.GetDetail(monthID, yearID, companyCode, descriptionCode, ConstantVariableService.FormStateDisplay);
// if (accruedLst != null)
// {
// ViewBag.Title = UtilityService.GetPagetTitlePrefix(ConstantVariableService.FormStateDisplay);
// return View("~/Views/Accrued/AccruedDetail.cshtml", accruedLst);
// }
// else
// {
// //return to List page
// return List();
// }
// }
//// [HttpGet]
// public ActionResult Manage(int month, int year, string compCode)
// {
// AccruedService service = new AccruedService();
// AccruedViewModel accruedLst = service.GetDetail(month, year, compCode, ConstantVariableService.FormStateCreate);
// if (accruedLst != null)
// {
// ViewBag.Title = UtilityService.GetPagetTitlePrefix(ConstantVariableService.FormStateCreate);
// return Json(accruedLst, JsonRequestBehavior.AllowGet);
// // return View("~/Views/Accrued/AccruedDetail.cshtml", accruedLst);
// }
// else
// {
// //return to List page
// return List();
// }
// }
#endregion
//[HttpGet]
public ActionResult InitialAccruedItemsList(string compCode, int month, int year, string formState, int accrued_id)
{
AccruedService service = new AccruedService();
List <AccruedDetailViewModel> accruedItemViewModel = new List <AccruedDetailViewModel>();
var result = service.InitialAccruedItemsList(compCode, month, year, formState, accrued_id);
if (result != null)
{
accruedItemViewModel = result;
//return Json(
// new
// {
// success = true,
// responseText = "",
// html = UtilityService.RenderPartialView(this, "~/Views/Accrued/AccruedItemsDetail.cshtml", accruedItemViewModel)
// },
// JsonRequestBehavior.AllowGet);
return(new JsonResult()
{
Data = new
{
success = true,
responseText = "",
html = UtilityService.RenderPartialView(this, "~/Views/Accrued/AccruedItemsDetail.cshtml", accruedItemViewModel)
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
MaxJsonLength = Int32.MaxValue // Use this value to set your maximum size for all of your Requests
});
}
else
{
return(Json(
new
{
success = true,
responseText = "",
html = ""
},
JsonRequestBehavior.AllowGet));
}
}
public ActionResult SubmitForm(AccruedViewModel formData)
{
foreach (var item in formData.AccruedItemList)
{
AccruedDetailViewModel accruedItem = new AccruedDetailViewModel();
JavaScriptSerializer js = new JavaScriptSerializer();
accruedItem = js.Deserialize <AccruedDetailViewModel>(item.AccruedJSON);
var accruedItemSub = accruedItem.AccruedItemSubList;
item.AccruedItemSubList.AddRange(accruedItemSub);
}
AccruedService service = new AccruedService();
ValidationResult result = service.SubmitForm(formData, ModelState);
return(Json(
new { success = !result.ErrorFlag, responseText = result.Message, errorList = result.ModelStateErrorList },
JsonRequestBehavior.AllowGet
));
}
public ActionResult SubmitReportForm(int recordKey) //(AccruedViewModel formData)
{
AccruedService service = new AccruedService();
//foreach (var item in formData.AccruedItemList)
//{
// AccruedDetailViewModel accruedItem = new AccruedDetailViewModel();
// JavaScriptSerializer js = new JavaScriptSerializer();
// accruedItem = js.Deserialize<AccruedDetailViewModel>(item.AccruedJSON);
// var accruedItemSub = accruedItem.AccruedItemSubList;
// item.AccruedItemSubList.AddRange(accruedItemSub);
//}
byte[] filecontent = service.SubmitFormFileContent(recordKey);//(formData);
if (filecontent == null)
{
return(List());
}
else
{
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Accrued Report.xlsx"));
}
}
public string GetList(string companyCode, int monthValue, int yearValue)
{
AccruedService service = new AccruedService();
return(service.GetList(companyCode, monthValue, yearValue));
}
