Exemplo n.º 1
0
        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);
        }