public ActionResult Add(string categoryTitle, string categoryTitleSelected)
{
categoryTitle = categoryTitle.Trim();
// if it's empty then
if (string.IsNullOrEmpty(categoryTitle))
{
return(SendJsonErrorResponse("Empty category name"));
}
var category = new productCategory
{
masterID = string.IsNullOrEmpty(categoryTitleSelected) ? repository.AddMasterProductCategory(categoryTitle).id : long.Parse(categoryTitleSelected),
details = "",
subdomain = subdomainid.Value
};
try
{
repository.AddProductCategory(category, subdomainid.Value);
}
catch (Exception ex)
{
return(SendJsonErrorResponse(ex));
}
if (category.id == 0)
{
return(Json(string.Format("Category <strong>{0}</strong> already exist", categoryTitle).ToJsonFail()));
}
return(Json(category.ToModel().ToJsonOKData()));
}
public ActionResult Create(int id)
{
productCategory oproductCategory = new productCategory();
oproductCategory.SupplierFor = id;
return(View(oproductCategory));
}
public ActionResult DeleteConfirmed(int id)
{
productCategory productCategory = db.productCategory.Find(id);
db.productCategory.Remove(productCategory);
db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public static ProductCategory ToModel(this productCategory obj)
{
return(new ProductCategory
{
details = obj.details,
title = obj.MASTERproductCategory.name,
id = obj.id
});
}
public ActionResult Edit(productCategory productCat)
{
if (ModelState.IsValid)
{
db.Entry(productCat).State = EntityState.Modified;
db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(productCat));
}
public ActionResult createCategory(productCategory model)
{
if (!ModelState.IsValid)
{
return(View());
}
db.productCategory.Add(model);
db.SaveChanges();
return(RedirectToAction("Create", "Product", new { categoryID = model.ID }));
}
public static CategoryColumn ToSyncModel(this productCategory v, CFlag flag, long?offlineid = null)
{
return(new CategoryColumn
{
cflag = flag,
id = offlineid,
name = v.MASTERproductCategory.name,
parentid = v.parentID,
serverid = v.id
});
}
public async Task <ActionResult> Edit(productCategory productCategories)
{
if (ModelState.IsValid)
{
db.Entry(productCategories).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index", new { id = productCategories.SupplierFor }));
}
return(View(productCategories));
}
public ActionResult Create(productCategory productCategory)
{
if (ModelState.IsValid)
{
db.productCategory.Add(productCategory);
db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(productCategory));
}
public ActionResult Create(productCategory productCategory)
{
if (!ModelState.IsValid)
{
return(View(productCategory));
}
else
{
context.Insert(productCategory);
}
return(RedirectToAction("Index"));
}
public void Delete(string Id)
{
productCategory productCategoryToDelete = productCategories.Find(p => p.Id == Id);
if (productCategoryToDelete != null)
{
productCategories.Remove(productCategoryToDelete);
}
else
{
throw new Exception("product no Found");
}
}
public productCategory Find(string Id)
{
productCategory productCategory = productCategories.Find(p => p.Id == Id);
if (productCategory != null)
{
return(productCategory);
}
else
{
throw new Exception("product category no found");
}
}
public ActionResult Delete(string Id)
{
productCategory productCategoryToDelete = context.Find(Id);
if (productCategoryToDelete == null)
{
return(HttpNotFound());
}
else
{
return(View(productCategoryToDelete));
}
}
public ActionResult Edit(string Id)
{
productCategory ProductCategory = context.Find(Id);
if (ProductCategory == null)
{
return(HttpNotFound());
}
else
{
return(View(ProductCategory));
}
}
public void Update(productCategory productCategory)
{
productCategory productCategoryToUpdate = productCategories.Find(p => p.Id == productCategory.Id);
if (productCategoryToUpdate != null)
{
productCategoryToUpdate = productCategory;
}
else
{
throw new Exception("product category no found");
}
}
public List <publicListingViewModel> loadProductData(List <productModel> productsIN)
{
List <publicListingViewModel> updatedList = new List <publicListingViewModel>();
productCategory cat = db.productCategory.Find(productsIN[0].categoryID);
foreach (productModel product in productsIN)
{
product.sellerModel = db.Users.Find(product.sellerID);
}
updatedList.Add(new publicListingViewModel {
products = productsIN, productCat = cat
});
return(updatedList);
}
// GET: productCategories/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
productCategory productCategory = db.productCategory.Find(id);
if (productCategory == null)
{
return(HttpNotFound());
}
return(View(productCategory));
}
public ActionResult ConfirmDelete(string Id)
{
productCategory productCategoryToDelete = context.Find(Id);
if (productCategoryToDelete == null)
{
return(HttpNotFound());
}
else
{
context.Delete(Id);
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create(productCategory productCategory)
{
ViewBag.result = "f";
if (ModelState.IsValid)
{
productCategory.isActive = true;
db.productCategories.Add(productCategory);
await db.SaveChangesAsync();
ViewBag.result = "s";
return(View(productCategory));
}
return(View(productCategory));
}
public ActionResult AddSub(string id, string categoryTitle, string categoryTitleSelected)
{
categoryTitle = categoryTitle.Trim();
// if it's empty then
if (string.IsNullOrEmpty(categoryTitle))
{
return(SendJsonErrorResponse("Empty category name"));
}
// check if subcategory already exist
if (string.IsNullOrEmpty(id))
{
return(SendJsonErrorResponse("Missing category id"));
}
var parentid = long.Parse(id);
var subcategories = repository.GetProductCategories(parentid, subdomainid.Value);
if (subcategories.Where(x => x.MASTERproductCategory.name == categoryTitle).Count() != 0)
{
return(SendJsonErrorResponse(string.Format("Subcategory <strong>{0}</strong> already exists", categoryTitle)));
}
var category = new productCategory
{
masterID = string.IsNullOrEmpty(categoryTitleSelected) ? repository.AddMasterProductCategory(categoryTitle).id : long.Parse(categoryTitleSelected),
details = "",
subdomain = subdomainid.Value,
parentID = parentid
};
try
{
repository.AddProductCategory(category, subdomainid.Value);
}
catch (Exception ex)
{
return(SendJsonErrorResponse(ex));
}
if (category.id == 0)
{
return(SendJsonErrorResponse(string.Format("Subcategory <strong></strong> already exists", categoryTitle)));
}
return(Json(category.ToModel().ToJsonOKData()));
}
public void AddProduct()
{
var owner = TestUtils.addTestMember();
var th = new TestHelpers();
th.FakeHttpContext();
HttpContextBase httpContext = th.httpContext.Object;
var controller = new productsController();
var context = new ControllerContext(new RequestContext(httpContext, new RouteData()), controller);
controller.ControllerContext = context;
// product category
var mastercatid = repository.AddMasterProductCategory("Ingredients").id;
var productcategory = new productCategory();
productcategory.masterID = mastercatid;
//productcategory.subdomain = s;
var pcid = repository.AddProductCategory(productcategory, 0);
// stock unit
var su = new stockUnit();
su.unitID = repository.AddMasterStockUnit("bottle").id;
su.owner = owner;
var suid = repository.AddStockUnit(su);
controller.Session["id"] = owner;
// supplier
var supid = repository.GetProductSupplier("Example Supplier Co.").id;
var result = controller.Create("TEST001", "Tomato Sauce", "red tomato sauce\nvery yummy", pcid,
suid, "1", "2", "", "", "", new[] { "2" }, new[] { "" }, new[] { "" }, "", "", "", "", "", "");
Product product = (Product)((JsonResult)(result)).Data;
// delete product supplier
//repository.DeleteProductSuppliers(owner);
// delete product
repository.DeleteProduct(product.id.Value, 0);
// delete stock unit
repository.DeleteStockUnits(owner);
// delete test user
TestUtils.deleteTestMember();
}
public ActionResult Edit(productCategory product, string Id)
{
productCategory productCategoryToEdit = context.Find(Id);
if (productCategoryToEdit == null)
{
return(HttpNotFound());
}
else
{
if (!ModelState.IsValid)
{
return(View(product));
}
productCategoryToEdit.Category = product.Category;
}
context.commit();
return(RedirectToAction("Index"));
}
public static string[] ToArray(this productCategory category)
{
if (category == null)
{
return(new string[0]);
}
var categories = new List <string>();
if (category.parentID.HasValue)
{
string parentCategoryName = category.productCategory1.MASTERproductCategory.name;
categories.Add(parentCategoryName);
var categoryName = category.MASTERproductCategory.name;
categories.Add(categoryName);
return(categories.ToArray());
}
categories.Add(category.MASTERproductCategory.name);
return(categories.ToArray());
}
public static string ToGoogleProductType(this productCategory category)
{
StringBuilder sb = new StringBuilder();
if (category == null)
{
return(sb.ToString());
}
if (category.parentID.HasValue)
{
string parentCategoryName = category.productCategory1.MASTERproductCategory.name;
sb.Append(parentCategoryName);
var categoryName = category.MASTERproductCategory.name;
sb.Append(string.Concat(" > ", categoryName));
return(sb.ToString());
}
sb.Append(category.MASTERproductCategory.name);
return(sb.ToString());
}
public long AddProductCategory(productCategory category, long subdomain)
{
productCategory result;
if (category.parentID.HasValue)
{
result = db.productCategories.Where(x => x.masterID == category.masterID &&
x.subdomain == subdomain && x.parentID == category.parentID).SingleOrDefault();
}
else
{
result = db.productCategories.Where(x => x.masterID == category.masterID &&
x.subdomain == subdomain && !x.parentID.HasValue).SingleOrDefault();
}
if (result != null)
{
return(result.id);
}
db.productCategories.InsertOnSubmit(category);
db.SubmitChanges();
CacheHelper.Instance.invalidate_dependency(DependencyType.categories, subdomain.ToString());
CacheHelper.Instance.invalidate_dependency(DependencyType.organisation, subdomain.ToString());
return(category.id);
}
public void Insert(productCategory p)
{
productCategories.Add(p);
}
public ActionResult Index(RequestSync syncdata)
{
var serializer = new JavaScriptSerializer();
IEnumerable <IColumn> receivedrows = null;
// deserialize what we have from the client
try
{
switch (syncdata.type)
{
case TableName.PRODUCTS:
receivedrows = serializer.Deserialize <ProductColumn[]>(syncdata.data);
break;
case TableName.CATEGORY:
receivedrows = serializer.Deserialize <CategoryColumn[]>(syncdata.data);
break;
case TableName.PHOTOS:
receivedrows = serializer.Deserialize <PhotosColumn[]>(syncdata.data);
break;
case TableName.INVENTORYLOC:
receivedrows = serializer.Deserialize <InventoryLocColumn[]>(syncdata.data);
break;
case TableName.INVENTORYLOCITEM:
receivedrows = serializer.Deserialize <InventoryLocItemColumn[]>(syncdata.data);
break;
case TableName.SETTINGS:
receivedrows = serializer.Deserialize <SettingsColumn[]>(syncdata.data);
break;
case TableName.STOCKUNIT:
receivedrows = serializer.Deserialize <StockUnitColumn[]>(syncdata.data);
break;
case TableName.ORDERS:
receivedrows = serializer.Deserialize <OrderColumn[]>(syncdata.data);
break;
case TableName.ORGS:
receivedrows = serializer.Deserialize <OrgColumn[]>(syncdata.data);
break;
default:
return(new EmptyResult());
}
}
catch (Exception ex)
{
Syslog.Write(ex);
return(new EmptyResult());
}
dynamic returnrows;
#region get new rows
// checking against maxid ensures that we return new rows or if nothing from offline db
// then online ids will be definately > 0
long maxid = 0;
if (receivedrows != null && receivedrows.Count() != 0)
{
// no need to check for NONE cflag as maxid from client could be update row that will have the largest id
var maxidrows = receivedrows.Where(x => x.serverid.HasValue);
if (maxidrows.Count() != 0)
{
maxid = maxidrows.Max(x => x.serverid.Value);
}
}
switch (syncdata.type)
{
// commented out because of implementation of product variant
//case TableName.PRODUCTS:
// returnrows =
// repository.GetProducts(subdomainid.Value, "").Where(x => x.id > maxid).ToSyncModel(CFlag.CREATE);
// break;
case TableName.CATEGORY:
returnrows =
repository.GetProductCategories(subdomainid.Value).Where(x => x.id > maxid).ToSyncModel(CFlag.CREATE);
break;
// commented out because of new image photos
/*
* case TableName.PHOTOS:
* // don't include PRODUCT where contextid = 0 as these are photos that are uploaded when abandoining product creation
* returnrows =
* db.product_images.Where(
* x =>
* x.subdomainid == subdomainid.Value && x.id > maxid &&
* x.productid != 0).ToSyncModel(CFlag.CREATE);
* break;
* */
case TableName.INVENTORYLOC:
returnrows =
repository.GetInventoryLocationsExceptSyncNetworks(subdomainid.Value).Where(x => x.id > maxid).ToSyncModel(CFlag.CREATE);
break;
case TableName.INVENTORYLOCITEM:
returnrows =
repository.GetInventoryLocationsExceptSyncNetworks(subdomainid.Value)
.SelectMany(x => x.inventoryLocationItems).Where(x => x.id > maxid).ToSyncModel(CFlag.CREATE);
break;
case TableName.SETTINGS:
var settings = repository.GetSubDomains().Where(x => x.id == subdomainid.Value && x.id > maxid).SingleOrDefault();
if (settings != null)
{
returnrows = settings.ToSyncModel(CFlag.CREATE);
}
else
{
returnrows = new List <SettingsColumn>();
}
break;
case TableName.STOCKUNIT:
returnrows =
db.stockUnits.Where(
x => x.subdomainid == subdomainid.Value && x.id > maxid).
ToSyncModel(CFlag.CREATE);
break;
case TableName.ORDERS:
returnrows =
db.orders.Where(
x => x.user.organisation1.MASTERsubdomain.id == subdomainid.Value && x.id > maxid).
ToSyncModel(CFlag.CREATE);
break;
case TableName.ORGS:
returnrows =
db.organisations.Where(
x => x.MASTERsubdomain.id == subdomainid.Value && x.id > maxid).
ToSyncModel(CFlag.CREATE);
break;
default:
return(new EmptyResult());
}
#endregion
#region check for updates since our last offline check
// only tables that allow user editing needs to be checked
// this has to be before values added from client because lastUpdate time will be before lastOfflinkCheck
// since the server will only be touched after update
var usr = repository.GetUserById(sessionid.Value, subdomainid.Value);
if (!usr.lastOfflineCheck.HasValue)
{
usr.lastOfflineCheck = DateTime.UtcNow;
repository.Save();
}
else
{
DateTime?lastCheck = usr.lastOfflineCheck;
dynamic changedRows = null;
switch (syncdata.type)
{
case TableName.PRODUCTS:
changedRows =
db.products.Where(
x => x.subdomainid == subdomainid.Value && x.updated > lastCheck).
ToSyncModel(CFlag.UPDATE);
break;
case TableName.CATEGORY:
changedRows =
db.productCategories.Where(x => x.subdomain == subdomainid.Value && x.lastUpdate > lastCheck)
.ToSyncModel(CFlag.UPDATE);
break;
case TableName.PHOTOS:
// not editable
break;
case TableName.INVENTORYLOC:
changedRows =
db.inventoryLocations.Where(
x => x.subdomain == subdomainid.Value && x.lastUpdate > lastCheck)
.ToSyncModel(CFlag.UPDATE);
break;
case TableName.INVENTORYLOCITEM:
changedRows = db.inventoryLocationItems.Where(
x => x.inventoryLocation.subdomain == subdomainid.Value && x.lastUpdate > lastCheck)
.ToSyncModel(CFlag.UPDATE);
break;
case TableName.SETTINGS:
break;
case TableName.STOCKUNIT:
// not editable or deletable at the moment
break;
case TableName.ORDERS:
changedRows = db.orders.Where(
x => x.user1.organisation1.subdomain == subdomainid.Value && x.lastUpdate > lastCheck)
.ToSyncModel(CFlag.UPDATE);
break;
case TableName.ORGS:
changedRows = db.organisations.Where(
x => x.subdomain == subdomainid.Value && x.lastUpdate > lastCheck)
.ToSyncModel(CFlag.UPDATE);
break;
case TableName.USER:
changedRows = repository.GetContacts(subdomainid.Value, sessionid.Value, null, null, null).Where
(x => x.lastUpdate > lastCheck)
.ToSyncModel(CFlag.UPDATE);
break;
default:
return(new EmptyResult());
}
if (changedRows != null)
{
foreach (var changedRow in changedRows)
{
returnrows.Add(changedRow);
}
}
}
#endregion
#region handle changes from client
if (receivedrows != null && receivedrows.Count() != 0)
{
foreach (var receivedrow in receivedrows)
{
try
{
/////////////////////////////////// UPDATE
// serverid is used to identify online db id
switch (receivedrow.cflag)
{
case CFlag.UPDATE:
// handle change flag
switch (syncdata.type)
{
case TableName.PRODUCTS:
var p = repository.GetProduct(receivedrow.serverid.Value, subdomainid.Value);
if (p != null)
{
var col = (ProductColumn)receivedrow;
p.category = col.categoryid;
p.costPrice = col.costPrice;
p.details = col.details;
p.flags = col.flags;
p.otherNotes = col.notes;
p.sellingPrice = col.sellingPrice;
//p.SKU = col.SKU;
p.stockUnitId = col.stockunitid;
p.thumb = col.thumbnailid;
p.title = col.title;
p.updated = DateTime.UtcNow;
repository.Save();
CacheHelper.Instance.invalidate_dependency(
DependencyType.products_subdomain, subdomainid.Value.ToString());
CacheHelper.Instance.invalidate_dependency(DependencyType.products_single,
receivedrow.serverid.ToString());
}
else
{
Syslog.Write("SYNC: Can't find product " + receivedrow.id);
}
break;
case TableName.CATEGORY:
// cannot update product category
break;
case TableName.PHOTOS:
// cannot update photos
break;
case TableName.INVENTORYLOC:
// cannot update inventory locations
break;
case TableName.INVENTORYLOCITEM:
var ilocitem = repository.GetInventoryLocationItem(receivedrow.serverid.Value,
subdomainid.Value);
if (ilocitem != null)
{
var col = (InventoryLocItemColumn)receivedrow;
ilocitem.available = col.inventoryLevel;
ilocitem.alarmLevel = col.alarmLevel;
repository.Save();
}
else
{
Syslog.Write("SYNC: Can't find inventoryLocationItem " + receivedrow.id);
}
break;
case TableName.STOCKUNIT:
// cannot update stockunit
break;
case TableName.ORDERS:
case TableName.ORGS:
case TableName.SETTINGS:
default:
throw new NotImplementedException();
}
receivedrow.cflag = CFlag.CLEAR;
returnrows.Add(receivedrow as dynamic);
break;
case CFlag.CREATE:
switch (syncdata.type)
{
// commented out due to implementation of product variants
/*
* case TableName.PRODUCTS:
* var col = (ProductColumn) receivedrow;
* // check for duplicate rows
* if(repository.GetProduct(col.SKU, subdomainid.Value) == null)
* {
* var p = new product()
* {
* subdomainid = subdomainid.Value,
* category = col.categoryid,
* costPrice = col.costPrice,
* details = col.details ?? "",
* flags = col.flags,
* otherNotes = col.notes,
* paymentTerms = col.paymentterms,
* sellingPrice = col.sellingPrice,
* shippingTerms = col.shippingterms,
* //SKU = col.SKU,
* stockUnitId = col.stockunitid,
* thumbnail = col.thumbnailid,
* title = col.title
* };
* repository.AddProduct(new ProductInfo(){p = p}, subdomainid.Value);
* receivedrow.serverid = p.id;
* receivedrow.cflag = CFlag.CLEAR;
* returnrows.Add(receivedrow as dynamic);
* }
* else
* {
* Syslog.Write("Duplicate SKU: " + subdomainid.Value + " " + col.SKU);
* }
* break;
* */
case TableName.CATEGORY:
var catcol = (CategoryColumn)receivedrow;
var mpc = repository.AddMasterProductCategory(catcol.name);
var c = new productCategory()
{
masterID = mpc.id,
parentID = catcol.parentid,
subdomain = subdomainid.Value
};
repository.AddProductCategory(c, subdomainid.Value);
receivedrow.serverid = c.id;
receivedrow.cflag = CFlag.CLEAR;
returnrows.Add(receivedrow as dynamic);
break;
case TableName.PHOTOS:
var pcol = (PhotosColumn)receivedrow;
var imageurl = pcol.url.ToSavedImageUrl(sessionid.Value, subdomainid.Value);
if (!string.IsNullOrEmpty(imageurl))
{
var photo = new image()
{
url = imageurl,
contextID = pcol.contextid,
imageType = pcol.type,
subdomain = subdomainid.Value
};
repository.AddImage(photo);
receivedrow.serverid = photo.id;
receivedrow.cflag = CFlag.CLEAR;
returnrows.Add(receivedrow as dynamic);
}
break;
case TableName.INVENTORYLOC:
var il = (InventoryLocColumn)receivedrow;
var loc = new inventoryLocation()
{
name = il.name
};
repository.AddInventoryLocation(loc, subdomainid.Value);
receivedrow.serverid = loc.id;
receivedrow.cflag = CFlag.CLEAR;
returnrows.Add(receivedrow as dynamic);
break;
case TableName.INVENTORYLOCITEM:
var ili = (InventoryLocItemColumn)receivedrow;
if (ili.productid.HasValue)
{
var locitem = new inventoryLocationItem()
{
locationid = ili.locationid,
available = ili.inventoryLevel,
onOrder = ili.onOrder,
variantid = ili.productid.Value,
alarmLevel = ili.alarmLevel
};
repository.AddInventoryLocationItem(locitem, subdomainid.Value);
receivedrow.serverid = locitem.id;
receivedrow.cflag = CFlag.CLEAR;
returnrows.Add(receivedrow as dynamic);
}
break;
case TableName.STOCKUNIT:
var scol = (StockUnitColumn)receivedrow;
var msu = repository.AddMasterStockUnit(scol.name);
var sunit = new stockUnit()
{
unitID = msu.id,
subdomainid = subdomainid.Value
};
repository.AddStockUnit(sunit);
receivedrow.serverid = sunit.id;
receivedrow.cflag = CFlag.CLEAR;
returnrows.Add(receivedrow as dynamic);
break;
case TableName.SETTINGS:
break;
case TableName.ORDERS:
case TableName.ORGS:
default:
throw new NotImplementedException();
}
break;
case CFlag.DELETE: /////////// DELETE
switch (syncdata.type)
{
case TableName.PRODUCTS:
repository.DeleteProduct(receivedrow.serverid.Value, subdomainid.Value);
break;
case TableName.CATEGORY:
repository.DeleteProductCategories(subdomainid.Value,
new[] { receivedrow.serverid.Value.ToString() });
break;
case TableName.PHOTOS:
repository.DeleteImage(receivedrow.serverid.Value, subdomainid.Value, PhotoType.ALL);
break;
case TableName.INVENTORYLOC:
try
{
var loc = db.inventoryLocations.Where(
x => x.id == receivedrow.serverid.Value && x.subdomain == subdomainid.Value).Single();
db.inventoryLocations.DeleteOnSubmit(loc);
db.SubmitChanges();
}
catch // suppress error when deleting iloc before ilocitem entry due to constraint
{
}
break;
case TableName.SETTINGS:
break;
case TableName.INVENTORYLOCITEM:
repository.DeleteInventoryLocationItem(receivedrow.serverid.Value, subdomainid.Value);
break;
case TableName.STOCKUNIT:
repository.DeleteStockUnit(receivedrow.serverid.Value, subdomainid.Value);
break;
case TableName.ORDERS:
case TableName.ORGS:
default:
throw new NotImplementedException();
}
receivedrow.cflag = CFlag.CLEAR;
returnrows.Add(receivedrow as dynamic);
break;
default:
break;
}
}
catch (Exception ex)
{
Syslog.Write(ex);
}
}
}
#endregion
return(Json(((object)returnrows).ToJsonOKData()));
}
public List <ProductInfo> Import(Stream inputStream, long owner, long subdomain)
{
var templateWorkbook = new HSSFWorkbook(inputStream, true);
var sheet = templateWorkbook.GetSheet("Products");
int count = 0;
var productsList = new List <ProductInfo>();
using (var repository = new TradelrRepository())
{
while (true)
{
var row = sheet.GetRow(count++);
if (row == null)
{
break;
}
var sku = GetCellValueAsString(row.GetCell(0, MissingCellPolicy.RETURN_NULL_AND_BLANK));
if (sku.StartsWith(";"))
{
continue;
}
if (string.IsNullOrEmpty(sku))
{
break;
}
var title = GetCellValueAsString(row.GetCell(1, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var description = GetCellValueAsString(row.GetCell(2, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var maincategory = GetCellValueAsString(row.GetCell(3, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var subcategory = GetCellValueAsString(row.GetCell(4, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var stockunit = GetCellValueAsString(row.GetCell(5, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var costprice = GetCellValueAsDecimal(row.GetCell(6, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var sellingprice = GetCellValueAsDecimal(row.GetCell(7, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var instock = GetCellValueAsInt(row.GetCell(8, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var photos = GetCellValueAsString(row.GetCell(9, MissingCellPolicy.RETURN_NULL_AND_BLANK));
var product = new product
{
subdomainid = subdomain,
details = description,
title = title,
costPrice = costprice,
sellingPrice = sellingprice
};
if (!string.IsNullOrEmpty(stockunit))
{
var masterunit = repository.AddMasterStockUnit(stockunit);
var su = new stockUnit {
unitID = masterunit.id, subdomainid = subdomain
};
product.stockUnitId = repository.AddStockUnit(su);
}
product.otherNotes = "";
var inventoryloc =
repository.GetInventoryLocation(GeneralConstants.INVENTORY_LOCATION_DEFAULT,
subdomain);
// create inventoryLocItem
var inventoryLocItem = new inventoryLocationItem
{
locationid = inventoryloc.id,
lastUpdate = DateTime.UtcNow
};
var invWorker = new InventoryWorker(inventoryLocItem, subdomain, true, false);
invWorker.SetValues("product created", instock, null, null, null);
MASTERproductCategory mastercat;
long?catid = null;
if (!string.IsNullOrEmpty(maincategory))
{
mastercat = repository.AddMasterProductCategory(maincategory);
var cat = new productCategory()
{
masterID = mastercat.id,
subdomain = subdomain
};
catid = repository.AddProductCategory(cat, subdomain);
}
// add sub category
if (!string.IsNullOrEmpty(subcategory) && !string.IsNullOrEmpty(maincategory))
{
mastercat = repository.AddMasterProductCategory(subcategory);
var subcat = new productCategory()
{
masterID = mastercat.id,
subdomain = subdomain,
parentID = catid
};
catid = repository.AddProductCategory(subcat, subdomain);
}
product.category = catid;
product.created = DateTime.UtcNow;
product.updated = product.created;
if (!productsList.Where(x => x.p.product_variants.Count(y => y.sku == sku) != 0).Any())
{
var pi = new ProductInfo()
{
p = product
};
if (!string.IsNullOrEmpty(photos))
{
var photourls = photos.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (var photourl in photourls)
{
pi.AddPhotoUrl(photourl);
}
}
var variant = new product_variant {
sku = sku
};
variant.inventoryLocationItems.Add(inventoryLocItem);
pi.p.product_variants.Add(variant);
productsList.Add(pi);
}
}
}
return(productsList);
}
public ActionResult Create()
{
productCategory ProductCategory = new productCategory();
return(View(ProductCategory));
}