public bool UpdateConvertion(int convertionID, int priceFrom, int priceTo, int chargeWeight, ShippingConvertionType type)
{
try
{
lwg_ShippingConvertionConfig config = dbContext.lwg_ShippingConvertionConfig.Where(c => c.ID == convertionID).FirstOrDefault();
if (config != null)
{
config.PriceFrom = priceFrom;
config.PriceTo = priceTo;
config.ChargeWeight = chargeWeight;
config.Type = type.ToString();
dbContext.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
LWGLog.WriteLog("Update Shipping Convertion", ex.ToString());
return(false);
}
}
public int AddConvertion(int priceFrom, int priceTo, int chargeWeight, ShippingConvertionType type)
{
try
{
lwg_ShippingConvertionConfig config = new lwg_ShippingConvertionConfig();
config.PriceFrom = priceFrom;
config.PriceTo = priceTo;
config.Type = type.ToString();
config.ChargeWeight = chargeWeight;
dbContext.lwg_ShippingConvertionConfig.Add(config);
dbContext.SaveChanges();
return(config.ID);;
}
catch (Exception ex)
{
LWGLog.WriteLog("Add Shipping Convertion Config", ex.ToString());
return(0);
}
}
public int GetWeightFromTotalPrice(decimal total, ShippingConvertionType type)
{
lwg_ShippingConvertionConfig config = null;
if (dbContext.lwg_ShippingConvertionConfig.Any(c => total > c.PriceFrom && total <= c.PriceTo && c.Type == type.ToString()))
{
config = dbContext.lwg_ShippingConvertionConfig.Where(c => c.PriceFrom < total && c.PriceTo >= total && c.Type == type.ToString()).FirstOrDefault();
}
else
if (dbContext.lwg_ShippingConvertionConfig.Any(c => total > c.PriceFrom && c.PriceTo == Int32.MaxValue && c.Type == type.ToString()))
{
config = dbContext.lwg_ShippingConvertionConfig.Where(c => c.PriceTo <= total && c.PriceFrom == Int32.MaxValue && c.Type == type.ToString()).FirstOrDefault();
}
else
if (dbContext.lwg_ShippingConvertionConfig.Any(c => total < c.PriceTo && c.PriceFrom == 0 && c.Type == type.ToString()))
{
config = dbContext.lwg_ShippingConvertionConfig.Where(c => c.PriceTo <= total && c.PriceFrom == Int32.MaxValue && c.Type == type.ToString()).FirstOrDefault();
}
if (config == null)
{
return(0);
}
return(config.ChargeWeight);
}
public List <lwg_ShippingConvertionConfig> GetAllConvertionByType(ShippingConvertionType type)
{
return(dbContext.lwg_ShippingConvertionConfig.Where(c => c.Type == type.ToString()).OrderBy(c => c.PriceFrom).ThenBy(c => c.PriceTo).ThenBy(c => c.ChargeWeight).ThenBy(c => c.ID).ToList());
}