public JsonResult PostExcelFile()
{
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
HttpPostedFileBase f = Request.Files[0];
string initFName = f.FileName;
string extension = f.FileName.Substring(f.FileName.LastIndexOf('.'));
string newFName = Guid.NewGuid() + extension;
Request.Files[0].SaveAs(System.IO.Path.Combine(CommonFunctions.GetImportsFolder(), newFName));
PlatiRepository pr = new PlatiRepository(Convert.ToInt32(Session["CURENT_USER_ID"]), conStr);
response r = pr.GetPlatiFromExcel("Sheet1", newFName);
bool societateDiferita = false;
foreach (object[] o in (object[])r.Result)
{
if (((PlataExtended)o[1]).Dosar.ID_SOCIETATE_CASCO != Convert.ToInt32(Session["ID_SOCIETATE"])) // se incearca incarcarea pt. alta societate decat cea a utilizatorului curent
{
societateDiferita = true;
break;
}
}
if (societateDiferita)
{
response toReturn = new response(false, String.Format("Nu puteti incarca plati pentru alta societate decat cea curenta ({0})!", ((SocietateAsigurare)Session["SOCIETATE_ASIGURARE"]).DENUMIRE), null, null, null);
return(Json(toReturn, JsonRequestBehavior.AllowGet));
}
r = pr.ImportPlatiDirect("Sheet1", newFName, 0); // 0 = import manual
JsonResult result = Json(r, JsonRequestBehavior.AllowGet);
result.MaxJsonLength = Int32.MaxValue;
return(result);
}
