public ActionResult Index(Users users, HttpPostedFileBase upload)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string EPCOSS = ConfigurationManager.AppSettings["EPCOSS"];
ViewBag.EPCOSS = EPCOSS;
string uid = ConfigurationManager.AppSettings["uid"];
string EMPLOYER_ID = (string)Session["EMPLOYER_ID"];
string LoginUser = (string)Session["LoginSAPID"];
//Session.Remove("StatusMsg");
DataTable dt = new DataTable();
if (upload != null && upload.ContentLength > 0)
{
if (upload.FileName.EndsWith(".csv"))
{
StreamReader streamCsv = new StreamReader(upload.InputStream);
string csvDataLine = ""; int CurrentLine = 0; int statusLine = 0;
string[] ScheduleData = null;
//string listCreated = "";
dt.Columns.Add("S/N", typeof(string));
dt.Columns.Add("Client Name", typeof(string));
dt.Columns.Add("RSAPIN", typeof(string));
dt.Columns.Add("Employee Mandatory", typeof(string));
dt.Columns.Add("Employer Mandatory", typeof(string));
dt.Columns.Add("Employee VC", typeof(string));
dt.Columns.Add("Employer VC", typeof(string));
dt.Columns.Add("Total", typeof(string));
dt.Columns.Add("Error Status", typeof(string));
dt.Columns.Add("Comment", typeof(string));
csvDataLine = streamCsv.ReadLine();
Employer.Employer employer = new Employer.Employer();
try
{
while ((csvDataLine = streamCsv.ReadLine()) != null)
{
if (CurrentLine != 1)
{
ScheduleData = csvDataLine.Split(',');
var validationStatus = employer.ValidateSchedule(ScheduleData[1], ScheduleData[2], ScheduleData[3], ScheduleData[4], ScheduleData[5], ScheduleData[6], ScheduleData[7], EMPLOYER_ID, userkey, uid);
var statusMessage = validationStatus.Split('~');
if (statusMessage[9] == "true")
{
statusLine += 1;
}
dt.Rows.Add(ScheduleData[0], ScheduleData[1], ScheduleData[2], ScheduleData[3], ScheduleData[4], ScheduleData[5], ScheduleData[6], ScheduleData[7], statusMessage[9], statusMessage[10]);
}
}
dt.Rows.Add();
dt.Rows.Add("Error Count", statusLine);
CurrentLine += 1;
Session["StatusMsg"] = statusLine;
WriteExcelWithNPOI(dt, "xlsx");
return(RedirectToAction("Index"));
//return View();
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Schedules/Index", "Schedules", "Index", "ValidateSchedule Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
return(View());
}
}
else
{
TempData["error"] = "Invalid File Type (Only accepts .csv filetype)";
return(View());
}
}
else
{
TempData["error"] = "Invalid File Type (Only accepts .csv filetype)";
return(View());
}
}
public JsonResult ValidateAESSchedules()
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string EMPLOYER_ID = (string)Session["EMPLOYER_ID"];
string LoginUser = (string)Session["LoginSAPID"];
var file = Request.Files["UploadedImage"];
DataTable dt = new DataTable();
if (file != null && file.ContentLength > 0)
{
if (file.FileName.EndsWith(".csv"))
{
StreamReader streamCsv = new StreamReader(file.InputStream);
string csvDataLine = ""; int CurrentLine = 0;
string[] ScheduleData = null;
//string listCreated = "";
dt.Columns.Add("S/N", typeof(string));
dt.Columns.Add("Client Name", typeof(string));
dt.Columns.Add("RSAPIN", typeof(string));
dt.Columns.Add("Employee Mandatory", typeof(string));
dt.Columns.Add("Employer Mandatory", typeof(string));
dt.Columns.Add("Employee VC", typeof(string));
dt.Columns.Add("Employer VC", typeof(string));
dt.Columns.Add("Total", typeof(string));
dt.Columns.Add("Error Status", typeof(string));
dt.Columns.Add("Comment", typeof(string));
csvDataLine = streamCsv.ReadLine();
Employer.Employer employer = new Employer.Employer();
try
{
while ((csvDataLine = streamCsv.ReadLine()) != null)
{
if (CurrentLine != 1)
{
ScheduleData = csvDataLine.Split(',');
var validationStatus = employer.ValidateSchedule(ScheduleData[1], ScheduleData[2], ScheduleData[3], ScheduleData[4], ScheduleData[5], ScheduleData[6], ScheduleData[7], EMPLOYER_ID, userkey, uid);
var statusMessage = validationStatus.Split('~');
if (statusMessage[9] == "true")
{
return(Json(new { data = "Schedules Is faulty " }, JsonRequestBehavior.AllowGet));
}
//dt.Rows.Add(ScheduleData[0], ScheduleData[1], ScheduleData[2], ScheduleData[3], ScheduleData[4], ScheduleData[5], ScheduleData[6], ScheduleData[7], statusMessage[9], statusMessage[10]);
}
}
CurrentLine += 1;
//ViewBag.dat = dt;
//WriteExcelWithNPOI(dt, "xlsx");
return(Json(new { data = "Schedule Validation successful" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Schedules/Index", "Schedules", "Index", "ValidateSchedule Error", ex.Message.ToString(), 0);
return(Json(new { data = ex.Message.ToString() }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { data = "Invalid File Type (Only accepts .csv filetype" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { data = "Invalid File Type (Only accepts .csv filetype" }, JsonRequestBehavior.AllowGet));
}
}