public string UploadFile() { if (HttpContext.Current.Request.Files.AllKeys.Any()) { logger.Info("start Item Upload Exel File: "); var identity = User.Identity as ClaimsIdentity; int compid = 0, userid = 0; // Access claims foreach (Claim claim in identity.Claims) { if (claim.Type == "compid") { compid = int.Parse(claim.Value); } if (claim.Type == "userid") { userid = int.Parse(claim.Value); } } // Get the uploaded image from the Files collection System.Web.HttpPostedFile httpPostedFile = HttpContext.Current.Request.Files["file"]; if (httpPostedFile != null) { // Validate the uploaded image(optional) byte[] buffer = new byte[httpPostedFile.ContentLength]; using (BinaryReader br = new BinaryReader(httpPostedFile.InputStream)) { br.Read(buffer, 0, buffer.Length); } XSSFWorkbook hssfwb; using (MemoryStream memStream = new MemoryStream()) { BinaryFormatter binForm = new BinaryFormatter(); memStream.Write(buffer, 0, buffer.Length); memStream.Seek(0, SeekOrigin.Begin); hssfwb = new XSSFWorkbook(memStream); string sSheetName = hssfwb.GetSheetName(0); ISheet sheet = hssfwb.GetSheet(sSheetName); AuthContext context = new AuthContext(); IRow rowData; ICell cellData = null; try { List <Supplier> supCollection = new List <Supplier>(); for (int iRowIdx = 0; iRowIdx <= sheet.LastRowNum; iRowIdx++) // iRowIdx = 0; HeaderRow { if (iRowIdx == 0) { rowData = sheet.GetRow(iRowIdx); if (rowData != null) { string field = string.Empty; field = rowData.GetCell(1).ToString().Trim(); if (field != "SUPPLIERCODES") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(2).ToString().Trim(); if (field != "Name") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(3).ToString().Trim(); if (field != "Brand") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(4).ToString().Trim(); if (field != "MobileNo") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(5).ToString().Trim(); if (field != "OfficePhone") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(6).ToString().Trim(); if (field != "BillingAddress") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(7).ToString().Trim(); if (field != "TINNo") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(8).ToString().Trim(); if (field != "Bank_AC_No") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(9).ToString().Trim(); if (field != "Bank_Name") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(10).ToString().Trim(); if (field != "Bank_Ifsc") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } field = rowData.GetCell(11).ToString().Trim(); if (field != "ShippingAddress") { JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again"); return(strJSON); } } } else { rowData = sheet.GetRow(iRowIdx); cellData = rowData.GetCell(0); rowData = sheet.GetRow(iRowIdx); if (rowData != null) { Supplier sup = new Supplier(); try { sup.CompanyId = 1; cellData = rowData.GetCell(1); col1 = cellData == null ? "" : cellData.ToString(); Supplier supp = context.Suppliers.Where(x => x.SUPPLIERCODES == col1.Trim()).FirstOrDefault(); if (supp == null) { sup.SUPPLIERCODES = col1.Trim(); cellData = rowData.GetCell(2); col2 = cellData == null ? "" : cellData.ToString(); sup.Name = col2.Trim(); cellData = rowData.GetCell(3); col3 = cellData == null ? "" : cellData.ToString(); sup.Brand = col3.Trim(); cellData = rowData.GetCell(4); col4 = cellData == null ? "" : cellData.ToString(); sup.MobileNo = (col4.Trim()); cellData = rowData.GetCell(5); col5 = cellData == null ? "" : cellData.ToString(); sup.OfficePhone = col5.Trim(); cellData = rowData.GetCell(6); col6 = cellData == null ? "" : cellData.ToString(); sup.BillingAddress = col6.Trim(); cellData = rowData.GetCell(7); col7 = cellData == null ? "" : cellData.ToString(); sup.TINNo = col7.Trim(); cellData = rowData.GetCell(8); col8 = cellData == null ? "" : cellData.ToString(); sup.Bank_AC_No = col8.Trim(); cellData = rowData.GetCell(9); col9 = cellData == null ? "" : cellData.ToString(); sup.Bank_Name = col9.Trim(); cellData = rowData.GetCell(10); col10 = cellData == null ? "" : cellData.ToString(); sup.Bank_Ifsc = col10.Trim(); cellData = rowData.GetCell(11); col11 = cellData == null ? "" : cellData.ToString(); sup.ShippingAddress = col11.Trim(); supCollection.Add(sup); } else { logger.Info("skcode Alredy Exist Skcode=:-" + col0); } } catch (Exception ex) { logger.Error("Error adding customer in collection " + "\n\n" + ex.Message + "\n\n" + ex.InnerException + "\n\n" + ex.StackTrace + sup.Name); } } } } context.AddBulkSupplier(supCollection); string m = "save collection"; } catch (Exception ex) { logger.Error("Error loading URL for " + Url + "\n\n" + ex.Message + "\n\n" + ex.InnerException + "\n\n" + ex.StackTrace); } } var FileUrl = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), httpPostedFile.FileName); httpPostedFile.SaveAs(FileUrl); } } if (msgitemname != null) { return(msgitemname); } msg = "Your Exel data is succesfully saved"; return(msg); }
public string UploadFile() { if (HttpContext.Current.Request.Files.AllKeys.Any()) { logger.Info("start Item Upload Exel File: "); var identity = User.Identity as ClaimsIdentity; int compid = 0, userid = 0; // Access claims foreach (Claim claim in identity.Claims) { if (claim.Type == "compid") { compid = int.Parse(claim.Value); } if (claim.Type == "userid") { userid = int.Parse(claim.Value); } } // Get the uploaded image from the Files collection System.Web.HttpPostedFile httpPostedFile = HttpContext.Current.Request.Files["file"]; if (httpPostedFile != null) { // Validate the uploaded image(optional) byte[] buffer = new byte[httpPostedFile.ContentLength]; using (BinaryReader br = new BinaryReader(httpPostedFile.InputStream)) { br.Read(buffer, 0, buffer.Length); } XSSFWorkbook hssfwb; // XSSFWorkbook workbook1; using (MemoryStream memStream = new MemoryStream()) { BinaryFormatter binForm = new BinaryFormatter(); memStream.Write(buffer, 0, buffer.Length); memStream.Seek(0, SeekOrigin.Begin); hssfwb = new XSSFWorkbook(memStream); string sSheetName = hssfwb.GetSheetName(0); ISheet sheet = hssfwb.GetSheet(sSheetName); AuthContext context = new AuthContext(); IRow rowData; ICell cellData = null; try { List <Supplier> supCollection = new List <Supplier>(); for (int iRowIdx = 0; iRowIdx <= sheet.LastRowNum; iRowIdx++) { if (iRowIdx == 0) { } else { rowData = sheet.GetRow(iRowIdx); cellData = rowData.GetCell(0); rowData = sheet.GetRow(iRowIdx); if (rowData != null) { Category cat = null; SubCategory subcat = null; SubsubCategory subsubcat = new SubsubCategory(); BaseCategory basecat = null; try { // sup.CompanyId = 1; cellData = rowData.GetCell(0); col0 = cellData == null ? "" : cellData.ToString(); cat = context.Categorys.Where(x => x.CategoryName.ToLower().Equals(col0.ToLower())).FirstOrDefault(); if (cat == null) { cat = new Category(); cat.CategoryName = col0; cellData = rowData.GetCell(1); col1 = cellData == null ? "" : cellData.ToString(); cat.Code = col1; cat.CompanyId = compid; cat = context.AddCategory(cat); } cellData = rowData.GetCell(2); col2 = cellData == null ? "" : cellData.ToString(); subcat = context.SubCategorys.Where(x => x.SubcategoryName.ToLower().Equals(col2.ToLower()) && x.CategoryName.Equals(cat.CategoryName)).FirstOrDefault(); if (subcat == null) { subcat = new SubCategory(); subcat.CompanyId = compid; subcat.SubcategoryName = col2; subcat.CategoryName = cat.CategoryName; subcat.Categoryid = cat.Categoryid; subcat = context.AddSubCategory(subcat); } cellData = rowData.GetCell(3); col3 = cellData == null ? "" : cellData.ToString(); subsubcat = context.SubsubCategorys.Where(x => x.SubsubcategoryName.ToLower().Equals(col3.ToLower()) && x.CategoryName.Equals(x.CategoryName) && x.SubcategoryName.ToLower().Equals(subcat.SubcategoryName.ToLower())).FirstOrDefault(); if (subsubcat == null) { subsubcat = new SubsubCategory(); subsubcat.CompanyId = compid; subsubcat.SubsubcategoryName = col3; subsubcat.SubCategoryId = subcat.SubCategoryId; cellData = rowData.GetCell(4); col4 = cellData == null ? "" : cellData.ToString(); subsubcat.Code = col4; subsubcat.SubcategoryName = col2; subsubcat.CategoryName = cat.CategoryName; subsubcat.Categoryid = cat.Categoryid; subsubcat = context.AddSubsubCat(subsubcat); } cellData = rowData.GetCell(4); col4 = cellData == null ? "" : cellData.ToString(); basecat = context.BaseCategoryDb.Where(x => x.BaseCategoryName.ToLower().Equals(col4.ToLower())).FirstOrDefault(); if (basecat == null) { basecat = new BaseCategory(); basecat.CompanyId = compid; basecat.BaseCategoryName = col4; basecat = context.AddBaseCategory(basecat); } } catch (Exception ex) { logger.Error("Error adding customer in collection " + "\n\n" + ex.Message + "\n\n" + ex.InnerException + "\n\n" + ex.StackTrace); } } } } context.AddBulkSupplier(supCollection); string m = "save collection"; } catch (Exception ex) { // logger.Error("Error loading URL for " + URL + "\n\n" + ex.Message + "\n\n" + ex.InnerException + "\n\n" + ex.StackTrace); } } var FileUrl = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), httpPostedFile.FileName); httpPostedFile.SaveAs(FileUrl); } } if (msgitemname != null) { return(msgitemname); } msg = "Your Exel data is succesfully saved"; return(msg); }