public IHttpActionResult PutWarehouseCategory(int id, WarehouseCategory warehouseCategory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != warehouseCategory.WhCategoryid)
{
return(BadRequest());
}
db.Entry(warehouseCategory).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!WarehouseCategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetWarehouseCategory(int id)
{
WarehouseCategory warehouseCategory = db.DbWarehouseCategory.Find(id);
if (warehouseCategory == null)
{
return(NotFound());
}
return(Ok(warehouseCategory));
}
public IHttpActionResult PostWarehouseCategory(WarehouseCategory warehouseCategory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DbWarehouseCategory.Add(warehouseCategory);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = warehouseCategory.WhCategoryid }, warehouseCategory));
}
public IHttpActionResult DeleteWarehouseCategory(int id)
{
WarehouseCategory warehouseCategory = db.DbWarehouseCategory.Find(id);
if (warehouseCategory == null)
{
return(NotFound());
}
db.DbWarehouseCategory.Remove(warehouseCategory);
db.SaveChanges();
return(Ok(warehouseCategory));
}
public void UploadFile()
{
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;
// public static bool ScanForText(Worksheet worksheet, object search,
// out int columnIndex, out int rowIndex)
//{
// string searchText = search.ToString().ToLower();
// for (int i = 1; i <= 100; i++)
// {
// for (rowIndex = 1, columnIndex = i; rowIndex <= i; rowIndex++, columnIndex--)
// if (worksheet.Cells[rowIndex, columnIndex].Value != null &&
// worksheet.Cells[rowIndex, columnIndex].Value.ToString().
// ToLower() == searchText)
// return true;
// }
// columnIndex = -1; rowIndex = -1;
// return false;
//}
//public WorksheetReader(Excel.Worksheet worksheet)
//{
// _worksheet = worksheet;
// _headerColumns = valueValidators.Select
// (i => new HeaderTextColumn(i.HeaderText, i.Required)).ToArray();
// _valueValidators = valueValidators;
//}
//private bool ScanForHeaders(int rowIndex)
//{
// int counter = 0;
// for (var columnIndex = 1; columnIndex < 100; columnIndex++)
// {
// if (_worksheet.Cells[rowIndex, columnIndex].Value != null)
// {
// Excel.Range cell = _worksheet.Cells[rowIndex, columnIndex];
// string cellText = cell.Value.ToString().ToLower();
// var headerColumn = _headerColumns.FirstOrDefault
// (i => i.CellText.ToLower() == cellText);
// if (headerColumn != null)
// {
// headerColumn.SetColumn(cell);
// //No need to proceed further if found all titles
// if (_headerColumns.Count() == ++counter) break;
// }
// }
// }
// return _headerColumns.All(i => !i.Required || i.ColumnIndex > 0);
//}
//private string HeadersErrorMessage()
//{
// IEnumerable<string> names = _headerColumns.Where(
// i => i.Required && i.ColumnIndex == 0).Select(i => i.CellText);
// return string.Format(
// "The following required headers are missing from the header row:{0} {1}.",
// Environment.NewLine, string.Join(", ", names));
//}
try
{
for (int iRowIdx = 1; iRowIdx <= sheet.LastRowNum; iRowIdx++) // iRowIdx = 0; HeaderRow
{
rowData = sheet.GetRow(iRowIdx);
if (rowData != null)
{
WarehouseCategory whcategory = new WarehouseCategory();
whcategory.CompanyId = 1; // compid;
cellData = rowData.GetCell(12);
try
{
cellData = rowData.GetCell(0);
if (cellData != null)
{
whcategory.WhCategoryid = int.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(1);
if (cellData != null)
{
whcategory.Warehouseid = int.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(2);
if (cellData != null)
{
whcategory.WarehouseName = cellData == null ? "" : cellData.ToString();
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(3);
if (cellData != null)
{
whcategory.Stateid = int.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(4);
if (cellData != null)
{
whcategory.State = cellData == null ? "" : cellData.ToString();
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(5);
if (cellData != null)
{
whcategory.Cityid = int.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(6);
if (cellData != null)
{
whcategory.City = cellData == null ? "" : cellData.ToString();
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(7);
if (cellData != null)
{
whcategory.Categoryid = int.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(8);
if (cellData != null)
{
whcategory.CategoryName = cellData == null ? "" : cellData.ToString();
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(9);
whcategory.IsVisible = bool.Parse(cellData.ToString());
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(10);
if (cellData != null)
{
whcategory.SortOrder = int.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(11);
if (cellData != null)
{
whcategory.Discription = cellData == null ? "" : cellData.ToString();
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(13);
if (cellData != null)
{
whcategory.CreatedDate = DateTime.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(14);
if (cellData != null)
{
whcategory.UpdatedDate = DateTime.Parse(cellData.ToString());
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(15);
if (cellData != null)
{
whcategory.CreatedBy = cellData == null ? "" : cellData.ToString();
}
}
catch (Exception ex) { }
try
{
cellData = rowData.GetCell(16);
if (cellData != null)
{
whcategory.UpdateBy = cellData == null ? "" : cellData.ToString();
}
}
catch (Exception ex) { }
context.Addwarehousecatxl(whcategory);
}
}
// _UpdateStatus = true;
}
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);
}
}
}
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 = 1, 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 <ItemMaster> ItemCollection = new List <ItemMaster>();
List <Category> wcat = new List <Category>();
for (int iRowIdx = 0; iRowIdx <= sheet.LastRowNum; iRowIdx++)
{
if (iRowIdx == 0)
{
rowData = sheet.GetRow(iRowIdx);
if (rowData != null)
{
string field = string.Empty;
field = rowData.GetCell(0).ToString();
if (field != "CityName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(1).ToString();
if (field != "Cityid")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(2).ToString();
if (field != "CategoryName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(3).ToString();
if (field != "CategoryCode")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(4).ToString();
if (field != "SubcategoryName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(5).ToString();
if (field != "SubsubcategoryName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(6).ToString();
if (field != "BrandCode")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(7).ToString();
if (field != "itemname")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(8).ToString();
if (field != "itemcode")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(9).ToString();
if (field != "Number")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(10).ToString();
if (field != "SellingSku")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(11).ToString();
if (field != "price")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(12).ToString();
if (field != "PurchasePrice")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(13).ToString();
if (field != "UnitPrice")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(14).ToString();
if (field != "MinOrderQty")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(15).ToString();
if (field != "SellingUnitName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(16).ToString();
if (field != "PurchaseMinOrderQty")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(17).ToString();
if (field != "StoringItemName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(18).ToString();
if (field != "PurchaseSku")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(19).ToString();
if (field != "PurchaseUnitName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(20).ToString();
if (field != "SupplierName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(21).ToString();
if (field != "SUPPLIERCODES")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(22).ToString();
if (field != "BaseCategoryName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(23).ToString();
if (field != "TGrpName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(24).ToString();
if (field != "TotalTaxPercentage")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(25).ToString();
if (field != "WarehouseName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(26).ToString();
if (field != "HindiName")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(27).ToString();
if (field != "SizePerUnit")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(28).ToString();
if (field != "Barcode")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(29).ToString();
if (field != "Active")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(30).ToString();
if (field != "Deleted")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(31).ToString();
if (field != "Margin")
{
JavaScriptSerializer objJSSerializer = new JavaScriptSerializer(); strJSON = objJSSerializer.Serialize("Header Name " + field + " does not exist..try again");
return(strJSON);
}
field = rowData.GetCell(32).ToString();
if (field != "PromoPoint")
{
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)
{
ItemMaster item = new ItemMaster();
try
{
item.CompanyId = 1;
Category cat = null;
SubCategory subcat = null;
SubsubCategory subsubcat = new SubsubCategory();
BaseCategory basecat = null;
//City Name -1
cellData = rowData.GetCell(0);
col0 = cellData == null ? "" : cellData.ToString();
if (col0.Trim() == "")
{
break;
}
item.CityName = col0.Trim();
//City Code -2
cellData = rowData.GetCell(1);
col1 = cellData == null ? "" : cellData.ToString();
string CityCode = col1.Trim();
City city = context.Cities.Where(x => x.CityName.Trim().ToLower() == item.CityName.Trim().ToLower()).SingleOrDefault();
if (city != null)
{
item.Cityid = city.Cityid;
}
//Warehouse Name 26
cellData = rowData.GetCell(25);
col25 = cellData == null ? "" : cellData.ToString();
item.WarehouseName = col25.Trim();
Warehouse w = context.Warehouses.Where(x => x.WarehouseName.Trim().ToLower() == item.WarehouseName.Trim().ToLower()).SingleOrDefault();
if (w != null)
{
item.warehouse_id = w.Warehouseid;
}
//base Category Name - 23
cellData = rowData.GetCell(22);
col22 = cellData == null ? "" : cellData.ToString();
string basecategory = col22.Trim();
basecat = context.BaseCategoryDb.Where(x => x.BaseCategoryName.ToLower().Equals(basecategory.ToLower())).SingleOrDefault();
if (basecat == null && col22.Trim() != "")
{
basecat = new BaseCategory();
basecat.BaseCategoryName = basecategory;
basecat.CompanyId = item.CompanyId;
if (w != null)
{
basecat.Warehouseid = w.Warehouseid;
}
else
{
basecat.Warehouseid = 1;
}
basecat.IsActive = true;
basecat = context.AddBaseCategory(basecat);
}
item.BaseCategoryName = basecat.BaseCategoryName;
item.BaseCategoryid = basecat.BaseCategoryId;
//Category Name -3
cellData = rowData.GetCell(2);
col2 = cellData == null ? "" : cellData.ToString();
item.CategoryName = col2.Trim();
//Category Code -4
cellData = rowData.GetCell(3);
col3 = cellData == null ? "" : cellData.ToString();
string CategoryCode = col3.Trim();
cat = context.Categorys.Where(x => x.CategoryName.Trim().Equals(col2.Trim())).SingleOrDefault();
if (cat == null && col3.Trim() != "")
{
cat = new Category();
cat.CategoryName = col2.Trim();
cat.Code = CategoryCode;
cat.BaseCategoryId = basecat.BaseCategoryId;
cat.CompanyId = item.CompanyId;
if (w != null)
{
cat.Warehouseid = w.Warehouseid;
}
else
{
cat.Warehouseid = 0;
}
cat.CompanyId = compid;
cat.IsActive = true;
cat = context.AddCategory(cat);
var wc = wcat.Where(x => x.Categoryid == cat.Categoryid).FirstOrDefault();
if (wc == null)
{
wcat.Add(cat);
}
}
else
{
if (w != null)
{
cat.Warehouseid = w.Warehouseid;
}
else
{
cat.Warehouseid = 0;
}
cat.CompanyId = compid;
cat.IsActive = true;
var wc = wcat.Where(x => x.Categoryid == cat.Categoryid).FirstOrDefault();
if (wc == null)
{
wcat.Add(cat);
}
}
item.Categoryid = cat.Categoryid;
item.CategoryName = cat.CategoryName;
//SubCategory Name - 5
cellData = rowData.GetCell(4);
col4 = cellData == null ? "" : cellData.ToString();
item.SubcategoryName = col4.Trim();
subcat = context.SubCategorys.Where(x => x.SubcategoryName.Trim().ToLower().Equals(col4.Trim().ToLower()) && x.Categoryid.Equals(cat.Categoryid)).SingleOrDefault();
if (subcat == null && col4.Trim() != "")
{
subcat = new SubCategory();
subcat.CompanyId = compid;
subcat.SubcategoryName = col4;
subcat.CategoryName = cat.CategoryName;
subcat.Categoryid = cat.Categoryid;
subcat.IsActive = true;
subcat = context.AddSubCategory(subcat);
}
item.SubCategoryId = subcat.SubCategoryId;
item.SubcategoryName = subcat.SubcategoryName;
//Brand Name ie. SubSubCategory - 6
cellData = rowData.GetCell(5);
col5 = cellData == null ? "" : cellData.ToString();
item.SubsubcategoryName = col5.Trim();
//Brand Code -7
cellData = rowData.GetCell(6);
col6 = cellData == null ? "" : cellData.ToString();
string BrandCode = col6.Trim();
subsubcat = context.SubsubCategorys.Where(x => x.SubsubcategoryName.Trim().ToLower().Equals(col5.Trim().ToLower()) && x.Categoryid.Equals(x.Categoryid) && x.SubCategoryId.Equals(subcat.SubCategoryId)).FirstOrDefault();
if (subsubcat == null && col6.Trim() != "")
{
subsubcat = new SubsubCategory();
subsubcat.CompanyId = compid;
subsubcat.SubsubcategoryName = col5;
subsubcat.SubCategoryId = subcat.SubCategoryId;
subsubcat.Code = col6;
subsubcat.SubcategoryName = col4;
subsubcat.CategoryName = cat.CategoryName;
subsubcat.Categoryid = cat.Categoryid;
subsubcat.IsActive = true;
subsubcat = context.AddSubsubCat(subsubcat);
}
item.SubsubCategoryid = subsubcat.SubsubCategoryid;
item.SubsubcategoryName = subsubcat.SubsubcategoryName;
//Item Name - 8
cellData = rowData.GetCell(7);
col7 = cellData == null ? "" : cellData.ToString();
item.itemname = col7.Trim();
//Item Code - 9
cellData = rowData.GetCell(8);
col8 = cellData == null ? "" : cellData.ToString();
item.itemcode = col8.Trim();
//Item Number - 10
cellData = rowData.GetCell(9);
col9 = cellData == null ? "" : cellData.ToString();
if (col9.Trim() == "" || col9 == null || col9 == "null")
{
break;
}
item.Number = col9.Trim();
//selling Sku - 11
cellData = rowData.GetCell(10);
col10 = cellData == null ? "" : cellData.ToString();
if (col10.Trim() == "" || col10 == null || col10 == "null")
{
break;
}
item.SellingSku = col10.Trim();
//MRP -12
cellData = rowData.GetCell(11);
col11 = cellData == null ? "" : cellData.ToString();
try {
item.price = Convert.ToDouble(col11);
}
catch (Exception e) { }
// Purchase Price - 13
cellData = rowData.GetCell(12);
col12 = cellData == null ? "" : cellData.ToString();
try
{
item.PurchasePrice = Convert.ToDouble(col12);
}
catch (Exception e) { }
//Selling Price - 14
cellData = rowData.GetCell(13);
col13 = cellData == null ? "" : cellData.ToString();
try
{
item.UnitPrice = Convert.ToDouble(col13);
}
catch (Exception e) { }
//selling MOQ -15
cellData = rowData.GetCell(14);
col14 = cellData == null ? "" : cellData.ToString();
try
{
item.MinOrderQty = Convert.ToInt32(col14);
}
catch (Exception e) { }
//selling Unit -16
cellData = rowData.GetCell(15);
col15 = cellData == null ? "" : cellData.ToString();
item.SellingUnitName = col15.Trim();
//ConversionFactor ,purchase qty -17
cellData = rowData.GetCell(16);
col16 = cellData == null ? "" : cellData.ToString();
try
{
item.PurchaseMinOrderQty = int.Parse(col16);
}
catch (Exception e) { }
//StoringItemName -18
cellData = rowData.GetCell(17);
col17 = cellData == null ? "" : cellData.ToString();
item.StoringItemName = col17.Trim();
//purchase sku -19
cellData = rowData.GetCell(18);
col18 = cellData == null ? "" : cellData.ToString();
if (col18.Trim() == "" || col18 == null || col18 == "null")
{
break;
}
item.PurchaseSku = col18.Trim();
//Purchase Unit -20
cellData = rowData.GetCell(19);
col19 = cellData == null ? "" : cellData.ToString();
item.PurchaseUnitName = col19.Trim();
//Supplier -21
cellData = rowData.GetCell(20);
col20 = cellData == null ? "" : cellData.ToString();
string spname = col20.Trim();
//Supplier code -22
cellData = rowData.GetCell(21);
col21 = cellData == null ? "" : cellData.ToString();
string sp_code = col21.Trim();
Supplier supplier = null;
supplier = context.Suppliers.Where(x => x.SUPPLIERCODES.Trim().Equals(sp_code.Trim())).SingleOrDefault();
if (supplier == null && col21.Trim() != "")
{
supplier = new Supplier();
supplier.Name = spname;
supplier.SUPPLIERCODES = sp_code;
supplier.CompanyId = compid;
supplier = context.AddSupplier(supplier);
}
item.SupplierId = supplier.SupplierId;
item.SupplierName = supplier.Name;
item.SUPPLIERCODES = supplier.SUPPLIERCODES;
// TaxGroup -24
cellData = rowData.GetCell(23);
col23 = cellData == null ? "" : cellData.ToString();
TaxGroup grp = context.DbTaxGroup.Where(x => x.TGrpName.Trim().ToLower().Equals(col23.Trim().ToLower())).SingleOrDefault();
item.TGrpName = col23.Trim();
if (grp != null)
{
item.GruopID = grp.GruopID;
}
// TotalTaxPercentage -25
cellData = rowData.GetCell(24);
col24 = cellData == null ? "" : cellData.ToString();
try
{
item.TotalTaxPercentage = double.Parse(col24);
}
catch (Exception e) { }
//item.active = true;
//hindi Nmae -27
cellData = rowData.GetCell(26);
col26 = cellData == null ? "" : cellData.ToString();
item.HindiName = col26.Trim();
//Sizeperunit Area-28
cellData = rowData.GetCell(27);
col27 = cellData == null ? "" : cellData.ToString();
try
{
item.SizePerUnit = double.Parse(col27);
}
catch (Exception e) {
item.SizePerUnit = 0;
}
//barcode -29
cellData = rowData.GetCell(28);
col28 = cellData == null ? "" : cellData.ToString();
item.Barcode = col28.Trim();
cellData = rowData.GetCell(29);
col29 = cellData == null ? "" : cellData.ToString();
if (col29.Trim().ToLower() == "true")
{
item.active = true;
}
else if (col29.Trim().ToLower() == "false")
{
item.active = false;
}
else
{
item.active = false;
}
cellData = rowData.GetCell(30);
col30 = cellData == null ? "" : cellData.ToString();
if (col30.Trim().ToLower() == "true")
{
item.Deleted = true;
}
else if (col30.Trim().ToLower() == "false")
{
item.Deleted = false;
}
else
{
item.Deleted = false;
}
cellData = rowData.GetCell(31);
col31 = cellData == null ? "" : cellData.ToString();
try
{
item.Margin = double.Parse(col31);
}
catch (Exception e)
{
item.Margin = 0;
}
cellData = rowData.GetCell(32);
col32 = cellData == null ? "" : cellData.ToString();
try
{
item.promoPoint = int.Parse(col32);
}
catch (Exception e)
{
item.promoPoint = 0;
}
//barcode -29
cellData = rowData.GetCell(33);
col33 = cellData == null ? "" : cellData.ToString();
item.HSNCode = col33.Trim();
ItemCollection.Add(item);
}
catch (Exception ex)
{
logger.Error("Error adding item in collection " + "\n\n" + ex.Message + "\n\n" + ex.InnerException + "\n\n" + ex.StackTrace + item.itemname);
}
}
}
}
List <WarehouseCategory> wc1 = new List <WarehouseCategory>();
foreach (Category c in wcat)
{
Warehouse w = context.Warehouses.Where(x => x.Warehouseid == c.Warehouseid).SingleOrDefault();
WarehouseCategory wc = new WarehouseCategory();
wc.Categoryid = c.Categoryid;
wc.CategoryName = c.CategoryName;
wc.Warehouseid = w.Warehouseid;
wc.WarehouseName = w.WarehouseName;
wc.Stateid = w.Stateid;
wc.Cityid = w.Cityid;
wc.IsVisible = true;
wc1.Add(wc);
}
context.AddWarehouseCategory(wc1, "");
context.AddBulkItemMaster(ItemCollection);
try
{
var ass = context.AllWarehouseCategory(compid).ToList();
foreach (var a in ass)
{
AngularJSAuthentication.API.Helper.refreshItemMaster(a.Warehouseid, a.Categoryid);
}
}
catch (Exception ex)
{
logger.Error("Error in update Cache " + ex.Message);
}
}
catch (Exception ex)
{
logger.Error("Error in update Cache " + ex.Message);
}
}
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 IEnumerable <WarehouseCategory> Get(string recordtype, int whid)
{
if (recordtype == "warehouse")
{
logger.Info("start Category: ");
List <Category> Category = new List <Category>();
List <Warehouse> Warehouse = new List <Warehouse>();
List <WarehouseCategory> WarehouseCategory = new List <WarehouseCategory>();
List <WarehouseCategory> wareH = new List <WarehouseCategory>();
try
{
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);
}
}
logger.Info("User ID : {0} , Company Id : {1}", compid, userid);
Category = context.AllCategory(compid).ToList();
Warehouse = context.AllWarehouse(compid).ToList();
wareH = context.AllWarehouseCategory(compid).ToList();
//var cat = (from c in Category where c.Warehouseid.Equals(whid) select c).ToList();
var cat = Category;
var war = (from c in Warehouse where c.Warehouseid.Equals(whid) select c).SingleOrDefault();
//var cat = (from c in Category where c.Warehouseid.Equals(whid) select c).ToList();
for (int i = 0; i < cat.Count; i++)
{
//var wcat = (from c in wareH where c.Warehouseid == whid && c.Categoryid == cat[i].Categoryid select c).SingleOrDefault();
List <WarehouseCategory> wcat = (from c in wareH where c.Warehouseid == whid && c.Deleted == false select c).ToList();
WarehouseCategory wc = new WarehouseCategory();
wc.Categoryid = cat[i].Categoryid;
wc.CategoryName = cat[i].CategoryName;
wc.Warehouseid = whid;
wc.Stateid = war.Stateid;
wc.State = war.StateName;
wc.Cityid = war.Cityid;
wc.City = war.CityName;
foreach (var c in wcat)
{
if (c.Categoryid.Equals(cat[i].Categoryid))
{
wc.WhCategoryid = c.WhCategoryid;
wc.IsVisible = true;
wc.SortOrder = c.SortOrder;
}
}
WarehouseCategory.Add(wc);
}
logger.Info("End Category: ");
return(WarehouseCategory);
}
catch (Exception ex)
{
logger.Error("Error in Category " + ex.Message);
logger.Info("End Category: ");
return(null);
}
}
return(null);
}
