public JsonResult Event_Check_Import_Template_Event_Payment()
{
int totalRecord = 0;
int totalRecord2 = 0;
int totalRecord3 = 0;
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
DataTable dt3 = new DataTable();
dt = Services_Files.Get_Import_Excel(Server, "Template_Event_Payment", Request.Files, "file");
dt2 = Services_Files.Get_Import_Excel(Server, "Template_History_Payment", Request.Files, "file");
dt3 = Services_Files.Get_Import_Excel(Server, "Template_Service_Cost", Request.Files, "file");
Session["event_payment"] = dt;
Session["history_payment"] = dt2;
Session["service_cost"] = dt3;
Session["event_payment_error"] = null;
Session["history_payment_error"] = null;
Session["service_cost_error"] = null;
totalRecord = dt.Rows.Count;
totalRecord2 = dt2.Rows.Count;
totalRecord3 = dt3.Rows.Count;
return(Json(new { total = totalRecord, total2 = totalRecord2, total3 = totalRecord3 }));
}
public ActionResult Event_Payment_Template_File()
{
MemoryStream stream = Services_Files.Get_Template_Excel(Server, "Template_Event_Payment");
string fileName = "Template_Event_Payment_" + DateTime.Now.ToShortDateString() + ".xlsx";
return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public JsonResult Event_Check_ImportFile_HCP_Info()
{
int totalRecord = 0;
DataTable dt = new DataTable();
dt = Services_Files.Get_Import_Excel(Server, "Template_HCP_Info", Request.Files, "file");
Session["hcp_info"] = dt;
Session["hcp_info_error"] = null;
totalRecord = dt.Rows.Count;
return(Json(new { total = totalRecord }));
}
