public long UpdateMessageTemplate(StoreMessageTemplateObject messageTemplate)
{
try
{
if (messageTemplate == null)
{
return(-2);
}
var messageTemplateEntity = ModelCrossMapper.Map <StoreMessageTemplateObject, StoreMessageTemplate>(messageTemplate);
if (messageTemplateEntity == null || messageTemplateEntity.Id < 1)
{
return(-2);
}
using (var db = new ShopKeeperStoreEntities())
{
db.StoreMessageTemplates.Attach(messageTemplateEntity);
db.Entry(messageTemplateEntity).State = EntityState.Modified;
db.SaveChanges();
return(messageTemplate.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public long UpdateMessage(StoreMessageObject message)
{
try
{
if (message == null)
{
return(-2);
}
using (var db = new ShopKeeperStoreEntities())
{
var msgs = db.StoreMessages.Where(k => k.Id == message.Id).ToList();
if (!msgs.Any())
{
return(-2);
}
var msg = msgs[0];
msg.MessageTemplateId = message.MessageTemplateId;
msg.Status = message.Status;
msg.DateSent = msg.DateSent;
msg.MessageBody = message.MessageBody;
db.Entry(msg).State = EntityState.Modified;
db.SaveChanges();
return(msg.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public bool UpdateProfileImage(string profileImage, long userId)
{
try
{
using (var db = new ShopKeeperStoreEntities("name=ShopKeeperStoreEntities"))
{
var profiles = db.UserProfiles.Where(s => s.Id == userId).ToList();
if (!profiles.Any())
{
return(false);
}
var profile = profiles[0];
profile.PhotofilePath = profileImage;
db.Entry(profile).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(false);
}
}
public int UpdateAdmin(EmployeeObject employee)
{
try
{
if (employee == null)
{
return(-2);
}
using (var db = new ShopKeeperStoreEntities("name=ShopKeeperStoreEntities"))
{
var duplicates = db.UserProfiles.Count(m => employee.PhoneNumber == m.MobileNumber && m.Id != employee.UserId);
if (duplicates > 0)
{
return(-3);
}
var userprofiles = db.UserProfiles.Where(p => p.Id == employee.UserId).Include("AspNetUsers").ToList();
if (!userprofiles.Any())
{
return(-2);
}
var user = userprofiles[0];
var users = user.AspNetUsers;
if (!users.Any())
{
return(-2);
}
var userInfo = users.ToList()[0];
userInfo.Email = employee.Email;
userInfo.UserName = employee.Email;
user.ContactEmail = employee.Email;
user.MobileNumber = employee.PhoneNumber;
user.OtherNames = employee.OtherNames;
user.LastName = employee.LastName;
user.Birthday = employee.Birthday;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
db.Entry(userInfo).State = EntityState.Modified;
db.SaveChanges();
return(5);
}
}
catch (DbEntityValidationException e)
{
var str = "";
foreach (var eve in e.EntityValidationErrors)
{
str += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State) + "\n";
str = eve.ValidationErrors.Aggregate(str, (current, ve) => current + (string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage) + " \n"));
}
ErrorLogger.LogError(e.StackTrace, e.Source, str);
return(0);
}
}
public bool ProcessPrices(List <ItemPrice> priceList, long stockId)
{
try
{
using (var db = new ShopKeeperStoreEntities(_connectionString))
{
if (priceList.Any())
{
var existingPriceList = db.ItemPrices.Where(i => i.StoreItemStockId == stockId).ToList();
priceList.ForEach(p =>
{
var matchFound = false;
if (existingPriceList.Any())
{
var pr = existingPriceList.Find(f => f.Price.Equals(p.Price));
if (pr != null && pr.ItemPriceId > 0)
{
if (!pr.MinimumQuantity.Equals(p.MinimumQuantity))
{
pr.MinimumQuantity = p.MinimumQuantity;
db.Entry(pr).State = EntityState.Modified;
db.SaveChanges();
matchFound = true;
}
else
{
matchFound = true;
}
}
else
{
var prq = existingPriceList.Find(f => f.MinimumQuantity.Equals(p.MinimumQuantity));
if (prq != null && prq.ItemPriceId > 0)
{
if (!prq.Price.Equals(p.Price))
{
prq.Price = p.Price;
db.Entry(prq).State = EntityState.Modified;
db.SaveChanges();
matchFound = true;
}
else
{
matchFound = true;
}
}
}
}
if (!matchFound || !existingPriceList.Any())
{
p.StoreItemStockId = stockId;
db.ItemPrices.Add(p);
db.SaveChanges();
}
});
return(true);
}
return(false);
}
}
catch (DbEntityValidationException e)
{
var str = "";
foreach (var eve in e.EntityValidationErrors)
{
str += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State) + "\n";
foreach (var ve in eve.ValidationErrors)
{
str += string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage) + " \n";
}
}
ErrorLogger.LogError(e.StackTrace, e.Source, str);
return(true);
}
}
private GenericValidator ProcessRecord(DataRowView dv, long currencyId, int outletId)
{
var gVal = new GenericValidator();
if (dv == null)
{
gVal.Code = -1;
gVal.Error = "An unknown error was encountered.";
return(gVal);
}
try
{
var mInfo = new StoreItemStock
{
StoreOutletId = outletId
};
var productCode = dv.Row["Code/SKU"].ToString().Trim();
var productNameModel = dv.Row["Product_Name/Model"].ToString().Trim();
StoreItemStock existingStock;
StoreItem existingItem;
if (!string.IsNullOrEmpty(productNameModel))
{
existingItem = VerifyExistingProduct(productNameModel, productCode, out existingStock);
}
else
{
gVal.Code = -1;
gVal.Error = "Please provide Product Name/Model.";
return(gVal);
}
if (string.IsNullOrEmpty(productCode))
{
gVal.Code = -1;
gVal.Error = "Please provide Product Code/SKU.";
return(gVal);
}
mInfo.SKU = productCode;
var product = new StoreItem
{
Name = productNameModel
};
#region brand category type
var brandStr = dv.Row["Brand(eg: Samsung)"].ToString().Trim();
if (string.IsNullOrEmpty(brandStr))
{
gVal.Code = -1;
gVal.Error = "Please provide Product Brand.";
return(gVal);
}
var brand = AddBrand(new StoreItemBrand {
Name = brandStr
});
product.StoreItemBrandId = brand.StoreItemBrandId;
existingItem.StoreItemBrandId = brand.StoreItemBrandId;
var categoryStr = dv.Row["Category(eg: Monitor)"].ToString().Trim();
if (string.IsNullOrEmpty(categoryStr))
{
gVal.Code = -1;
gVal.Error = "Please provide Product Category.";
return(gVal);
}
var category = ProcessCategory(new StoreItemCategory {
Name = categoryStr, LastUpdated = DateTime.Now
});
product.StoreItemCategoryId = category.StoreItemCategoryId;
existingItem.StoreItemCategoryId = category.StoreItemCategoryId;
var typeStr = dv.Row["Type(Eg: Opticals)"].ToString().Trim();
if (string.IsNullOrEmpty(typeStr))
{
gVal.Code = -1;
gVal.Error = "Please provide Product Type.";
return(gVal);
}
var type = AddType(new StoreItemType {
Name = typeStr
});
product.StoreItemTypeId = type.StoreItemTypeId;
existingItem.StoreItemTypeId = type.StoreItemTypeId;
#endregion
#region generic
var decscription = dv.Row["Description(optional)"].ToString().Trim();
if (!string.IsNullOrEmpty(decscription))
{
product.Description = decscription;
existingItem.Description = decscription;
}
var techStr = dv.Row["Technical_Specifications(optional)"].ToString().Trim();
if (!string.IsNullOrEmpty(techStr))
{
product.TechSpechs = techStr;
existingItem.TechSpechs = techStr;
}
var quantityStr = dv.Row["Quantity_In_Stock"].ToString().Trim();
if (!string.IsNullOrEmpty(quantityStr))
{
double quantity;
var res = double.TryParse(quantityStr, out quantity);
if (res && quantity > 0)
{
mInfo.QuantityInStock = quantity;
existingStock.QuantityInStock = quantity;
}
else
{
gVal.Code = -1;
gVal.Error = "Please provide a valid value for Quantity in Stock.";
return(gVal);
}
}
else
{
gVal.Code = -1;
gVal.Error = "Please provide Quantity in Stock.";
return(gVal);
}
var expiryDateStr = dv.Row["Expiry_Date(yyyy/MM/dd)"].ToString().Trim();
if (!string.IsNullOrEmpty(expiryDateStr))
{
DateTime expiryDate;
var res = DateTime.TryParse(expiryDateStr, out expiryDate);
if (res)
{
mInfo.ExpirationDate = expiryDate;
}
}
var costStr = dv.Row["Cost_Price(optional)"].ToString().Trim();
if (!string.IsNullOrEmpty(costStr) && costStr != "0")
{
double costPrice;
var res = double.TryParse(costStr, out costPrice);
if (res && costPrice > 0)
{
mInfo.CostPrice = costPrice;
existingStock.CostPrice = costPrice;
}
else
{
gVal.Code = -1;
gVal.Error = "Please provide a valid value for Cost Price.";
return(gVal);
}
}
#endregion
#region price setup
var priceList = new List <ItemPrice>();
var priceStr1 = dv.Row["Price_1"].ToString().Trim();
var priceStr2 = dv.Row["Price_2"].ToString().Trim();
var priceStr3 = dv.Row["Price_3"].ToString().Trim();
var qtyStr1 = dv.Row["Quantity_1"].ToString().Trim();
var qtyStr2 = dv.Row["Quantity_2"].ToString().Trim();
var qtyStr3 = dv.Row["Quantity_3"].ToString().Trim();
var uomStr = dv.Row["Unit_of_measurement_Code(eg: Kg)"].ToString().Trim();
long uomId = 0;
if (!string.IsNullOrEmpty(uomStr))
{
var codeRes = AddUomCode(new UnitsOfMeasurement {
UoMCode = uomStr
});
if (codeRes.UnitOfMeasurementId < 1)
{
gVal.Code = -1;
gVal.Error = "Product's unit of measurement could not processed.";
return(gVal);
}
uomId = codeRes.UnitOfMeasurementId;
}
if (!string.IsNullOrEmpty(priceStr1) || !string.IsNullOrEmpty(priceStr2) || !string.IsNullOrEmpty(priceStr3))
{
if (uomId < 1)
{
gVal.Code = -1;
gVal.Error = "Please provide Product's unit of measurement.";
return(gVal);
}
}
if (!string.IsNullOrEmpty(priceStr1))
{
if (string.IsNullOrEmpty(qtyStr1))
{
gVal.Code = -1;
gVal.Error = "Please provide Quantity_1.";
return(gVal);
}
double price1;
var pr1Res = double.TryParse(priceStr1, out price1);
if (pr1Res && price1 > 0)
{
double quantity1;
var qty1Res = double.TryParse(qtyStr1, out quantity1);
if (qty1Res && quantity1 > 0)
{
var itemPrice1 = new ItemPrice
{
StoreItemStockId = 0,
Price = price1,
MinimumQuantity = quantity1,
UoMId = uomId
};
priceList.Add(itemPrice1);
}
}
}
if (!string.IsNullOrEmpty(priceStr2))
{
if (string.IsNullOrEmpty(qtyStr2))
{
gVal.Code = -1;
gVal.Error = "Please provide Quantity_2.";
return(gVal);
}
double price2;
var pr2Res = double.TryParse(priceStr2, out price2);
if (pr2Res && price2 > 0)
{
double quantity2;
var qty2Res = double.TryParse(qtyStr2, out quantity2);
if (qty2Res && quantity2 > 0)
{
var itemPrice2 = new ItemPrice
{
StoreItemStockId = 0,
Price = price2,
MinimumQuantity = quantity2,
UoMId = uomId
};
priceList.Add(itemPrice2);
}
}
}
if (!string.IsNullOrEmpty(priceStr3))
{
if (string.IsNullOrEmpty(qtyStr3))
{
gVal.Code = -1;
gVal.Error = "Please provide Quantity_3.";
return(gVal);
}
double price3;
var pr3Res = double.TryParse(priceStr3, out price3);
if (pr3Res && price3 > 0)
{
double quantity3;
var qty3Res = double.TryParse(qtyStr3, out quantity3);
if (qty3Res && quantity3 > 0)
{
var itemPrice3 = new ItemPrice
{
StoreItemStockId = 0,
Price = price3,
MinimumQuantity = quantity3,
UoMId = uomId
};
priceList.Add(itemPrice3);
}
}
}
#endregion
#region others
var reorderQuantitySoldStr = dv.Row["Reorder_Quantity(optional)"].ToString().Trim();
if (!string.IsNullOrEmpty(reorderQuantitySoldStr))
{
int reorderQuantity;
var res = int.TryParse(reorderQuantitySoldStr, out reorderQuantity);
if (res && reorderQuantity > 0)
{
mInfo.ReorderQuantity = reorderQuantity;
existingStock.ReorderQuantity = reorderQuantity;
}
}
var reorderLevelStr = dv.Row["Reorder_Level(optional)"].ToString().Trim();
if (!string.IsNullOrEmpty(reorderLevelStr))
{
int reorderLevel;
var res = int.TryParse(reorderLevelStr, out reorderLevel);
if (res && reorderLevel > 0)
{
mInfo.ReorderLevel = reorderLevel;
existingStock.ReorderLevel = reorderLevel;
}
}
var productVariationPropStr = dv.Row["Distinguishing_Property(eg: Color, Size, Weight)"].ToString().Trim();
if (!string.IsNullOrEmpty(productVariationPropStr))
{
var resP = ProcessVariation(productVariationPropStr);
if (resP < 1)
{
gVal.Code = -1;
gVal.Error = "Product Distinguishing Property Information could not be Processed.";
return(gVal);
}
mInfo.StoreItemVariationId = resP;
existingStock.StoreItemVariationId = resP;
}
else
{
gVal.Code = -1;
gVal.Error = "Please provide Product Distinguishing Property.";
return(gVal);
}
var productVariationValueStr = dv.Row["Distinguishing_Value(eg: Black, medium, 15kg)"].ToString().Trim();
if (!string.IsNullOrEmpty(productVariationValueStr))
{
var res = ProcessValue(productVariationValueStr);
if (res < 1)
{
gVal.Code = -1;
gVal.Error = "Product Distinguishing Value could not be processed.";
return(gVal);
}
mInfo.StoreItemVariationValueId = res;
existingStock.StoreItemVariationValueId = res;
}
else
{
gVal.Code = -1;
gVal.Error = "Please provide Product Distinguishing Value.";
return(gVal);
}
#endregion
#region process stock
using (var db = new ShopKeeperStoreEntities("name=ShopKeeperStoreEntities"))
{
StoreItem processedProduct;
StoreItemStock processedProductStock;
if (existingItem.StoreItemId > 0)
{
db.Entry(existingItem).State = EntityState.Modified;
db.SaveChanges();
processedProduct = existingItem;
mInfo.LastUpdated = DateTime.Now;
mInfo.StoreCurrencyId = currencyId;
mInfo.StoreItemId = processedProduct.StoreItemId;
if (existingStock.StoreItemStockId < 1)
{
processedProductStock = db.StoreItemStocks.Add(mInfo);
db.SaveChanges();
}
else
{
db.Entry(existingStock).State = EntityState.Modified;
db.SaveChanges();
processedProductStock = existingStock;
}
}
else
{
processedProduct = db.StoreItems.Add(product);
db.SaveChanges();
mInfo.LastUpdated = DateTime.Now;
mInfo.StoreCurrencyId = currencyId;
mInfo.StoreItemId = processedProduct.StoreItemId;
processedProductStock = db.StoreItemStocks.Add(mInfo);
db.SaveChanges();
}
if (priceList.Any())
{
ProcessPrices(priceList, processedProductStock.StoreItemStockId);
}
gVal.Code = processedProductStock.StoreItemStockId;
return(gVal);
}
#endregion
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
gVal.Code = -1;
gVal.Error = ex.Message;
return(gVal);
}
}
private long ProcessData(DataRowView dv, ref string msg)
{
if (dv == null)
{
return(0);
}
try
{
using (var db = new ShopKeeperStoreEntities(_connectionString))
{
var mInfo = new StoreItemStock();
var sku = dv.Row["SKU"].ToString().Trim();
if (!string.IsNullOrEmpty(sku))
{
var result = db.StoreItemStocks.Where(m => m.SKU == sku.Trim()).ToList();
if (result.Any())
{
mInfo = result[0];
}
else
{
msg = "Product could not be found.";
return(0);
}
}
else
{
msg = "Please provide SKU.";
return(0);
}
var quantityInStockStr = dv.Row["Quantity_In_Stock"].ToString().Trim();
if (!string.IsNullOrEmpty(quantityInStockStr))
{
int quantity;
var res = int.TryParse(quantityInStockStr, out quantity);
if (res && quantity > 0)
{
mInfo.QuantityInStock = quantity;
}
else
{
msg = "Please provide a valid value for Quantity in Stock.";
return(0);
}
}
else
{
msg = "Please provide Quantity in Stock.";
return(0);
}
var expiryDateStr = dv.Row["Expiry_Date(yyyy/MM/dd)"].ToString().Trim();
if (!string.IsNullOrEmpty(expiryDateStr))
{
DateTime expiryDate;
var res = DateTime.TryParse(expiryDateStr, out expiryDate);
if (res)
{
mInfo.ExpirationDate = expiryDate;
}
}
var processedProductStock = db.StoreItemStocks.Attach(mInfo);
db.Entry(mInfo).State = EntityState.Modified;
db.SaveChanges();
return(processedProductStock.StoreItemStockId);
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}