public string UploadFile()
{
string msg;
string strJSON = null;
if (HttpContext.Current.Request.Files.AllKeys.Any())
{
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
{
for (int iRowIdx = 0; iRowIdx <= sheet.LastRowNum; iRowIdx++) // iRowIdx = 0; HeaderRow
{
if (iRowIdx == 0)
{
rowData = sheet.GetRow(iRowIdx);
if (rowData != null)
{
string col0, col1, col2, col3, col4, col5, field;
col0 = "Whsupid"; col1 = "StateName";
col2 = "CityName"; col3 = "WarehouseName";
col4 = "SupplierName"; col5 = "Active";
cellData = rowData.GetCell(0);
field = cellData.ToString();
if (col0 == field)
{
cellData = rowData.GetCell(1);
field = cellData.ToString();
if (col1 == field)
{
cellData = rowData.GetCell(2); field = cellData.ToString();
if (col2 == field)
{
cellData = rowData.GetCell(3); field = cellData.ToString();
if (col3 == field)
{
cellData = rowData.GetCell(4); field = cellData.ToString();
if (col4 == field)
{
cellData = rowData.GetCell(5); field = cellData.ToString();
if (col5 == field)
{
}
else
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(field); return(strJSON);
}
}
else
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(field); return(strJSON);
}
}
else
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(field); return(strJSON);
}
}
else
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(field); return(strJSON);
}
}
else
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(field); return(strJSON);
}
}//end check col
else
{
msg = "Your Hesder are not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
} //oute if
}
else
{
rowData = sheet.GetRow(iRowIdx);
string obj;
if (rowData != null)
{
WarehouseSupplier ws = new WarehouseSupplier();
cellData = rowData.GetCell(0);
int id = Convert.ToInt32(cellData.ToString());
WarehouseSupplier warehsup = context.DbWarehouseSupplier.Where(s => s.Whsupid.Equals(id)).Select(s => s).FirstOrDefault();
if (warehsup != null)
{
ws.Whsupid = id;
ws.CompanyId = 1; // compid;
cellData = rowData.GetCell(9);
try
{
cellData = rowData.GetCell(1);
obj = cellData.ToString();
State State = context.States.Where(x => x.StateName == obj).Where(x => x.Deleted == false).Select(x => x).FirstOrDefault();
if (State != null)
{
ws.Stateid = State.Stateid;
ws.StateName = State.StateName;
}
else
{
msg = "Your " + obj + " Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(2);
obj = cellData.ToString();
City city = context.Cities.Where(x => x.CityName == obj).Select(x => x).FirstOrDefault();
if (city != null)
{
ws.Cityid = city.Cityid;
ws.CityName = city.CityName;
}
else
{
msg = "Your" + obj + " Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(3);
obj = cellData == null ? "" : cellData.ToString();
Warehouse WareHouse = context.Warehouses.Where(x => x.WarehouseName == obj).Select(x => x).FirstOrDefault();
if (WareHouse != null)
{
ws.Warehouseid = WareHouse.Warehouseid;
ws.WarehouseName = WareHouse.WarehouseName;
}
else
{
msg = "Your" + obj + "Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(4);
obj = cellData == null ? "" : cellData.ToString();
Supplier Suppplier = context.Suppliers.Where(x => x.Name == obj).Select(x => x).FirstOrDefault();
if (Suppplier != null)
{
ws.SupplierId = Suppplier.SupplierId;
ws.SupplierName = Suppplier.Name;
}
else
{
msg = "Your" + obj + "Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(5);
ws.Active = Convert.ToBoolean(cellData == null ? "" : cellData.ToString());
}
catch (Exception ex)
{
}
context.PutWarehouseSupplierExcel(ws);
}
else
{
ws.CompanyId = 1; // compid;
cellData = rowData.GetCell(9);
try
{
cellData = rowData.GetCell(1);
obj = cellData.ToString();
State State = context.States.Where(x => x.StateName == obj).Where(x => x.Deleted == false).Select(x => x).FirstOrDefault();
if (State != null)
{
ws.Stateid = State.Stateid;
ws.StateName = State.StateName;
}
else
{
msg = "Your " + obj + " Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(2);
obj = cellData.ToString();
City city = context.Cities.Where(x => x.CityName == obj).Select(x => x).FirstOrDefault();
if (city != null)
{
ws.Cityid = city.Cityid;
ws.CityName = city.CityName;
}
else
{
msg = "Your" + obj + " Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(3);
obj = cellData == null ? "" : cellData.ToString();
Warehouse WareHouse = context.Warehouses.Where(x => x.WarehouseName == obj).Select(x => x).FirstOrDefault();
if (WareHouse != null)
{
ws.Warehouseid = WareHouse.Warehouseid;
ws.WarehouseName = WareHouse.WarehouseName;
}
else
{
msg = "Your" + obj + "Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(4);
obj = cellData == null ? "" : cellData.ToString();
Supplier Suppplier = context.Suppliers.Where(x => x.Name == obj).Select(x => x).FirstOrDefault();
if (Suppplier != null)
{
ws.SupplierId = Suppplier.SupplierId;
ws.SupplierName = Suppplier.Name;
}
else
{
msg = "Your" + obj + "Does not Exist"; JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize(msg); return(strJSON);
}
cellData = rowData.GetCell(5);
ws.Active = Convert.ToBoolean(cellData == null ? "" : cellData.ToString());
}
catch (Exception ex)
{
}
context.AddWarehouseSupplierExcel(ws);
}
}
}
} //end for
// _UpdateStatus = true;
}
catch (Exception ex)
{
}
}
var FileUrl = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), httpPostedFile.FileName);
httpPostedFile.SaveAs(FileUrl);
}
}
msg = "Sucesss";
return(msg);
}
