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);
}
