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);
}
public JsonResult MovePendingToOk(PlataExtended plata)
{
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]);
Plata p = new Plata(_CURENT_USER_ID, conStr);
PropertyInfo[] pis = plata.Plata.GetType().GetProperties();
foreach (PropertyInfo pi in pis)
{
pi.SetValue(p, pi.GetValue(plata.Plata)); // ca sa avem un obiect si cu credentiale
}
response toReturn = p.UpdateWithErrors();
if (!toReturn.Status)
{
return(Json(toReturn, JsonRequestBehavior.AllowGet));
}
toReturn = p.Validare();
if (!toReturn.Status)
{
return(Json(toReturn, JsonRequestBehavior.AllowGet));
}
PlatiRepository pr = new PlatiRepository(_CURENT_USER_ID, conStr);
toReturn = pr.MovePendingToOk(Convert.ToInt32(p.ID));
return(Json(toReturn, JsonRequestBehavior.AllowGet));
}
public ImportPlataView(int CURENT_USER_ID, string conStr)
{
PlatiRepository pr = new PlatiRepository(CURENT_USER_ID, conStr);
ImportDates = ((List <string>)pr.GetImportDates().Result).ToArray();
SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(CURENT_USER_ID, conStr);
this.SocietatiRCA = (SocietateAsigurare[])sar.GetAll().Result;
}
public JsonResult GetPlatiFromLog(DateTime?ImportDate)
{
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
PlatiRepository pr = new PlatiRepository(Convert.ToInt32(Session["CURENT_USER_ID"]), conStr);
response r = pr.GetPlatiFromLog(ImportDate);
JsonResult result = Json(r, JsonRequestBehavior.AllowGet);
result.MaxJsonLength = Int32.MaxValue;
return(result);
}