public bool EditProductPricing(product_price_mapping productPrice, long update_by)
{
try
{
int save = 0;
var priceing = _entities.product_price_mapping.Find(productPrice.product_price_mapping_id);
if (InsertLogTable(priceing, update_by))
{
priceing.product_id = productPrice.product_id;
priceing.product_version_id = productPrice.product_version_id;
priceing.color_id = productPrice.color_id;
priceing.is_active = productPrice.is_active;
priceing.updated_by = update_by;
priceing.updated_date = DateTime.Now;
priceing.b2b_cost = productPrice.b2b_cost;
priceing.corporate_cost = productPrice.corporate_cost;
priceing.dealer_cost = productPrice.dealer_cost;
priceing.emi_cost = productPrice.emi_cost;
priceing.gift_cost = productPrice.gift_cost;
priceing.internal_cost = productPrice.internal_cost;
priceing.online_cost = productPrice.online_cost;
priceing.telco_cost = productPrice.telco_cost;
priceing.land_cost = productPrice.land_cost;
priceing.fin_cost = productPrice.fin_cost;
priceing.incentive_cost = productPrice.incentive_cost;
priceing.price_protection = productPrice.price_protection;
priceing.promotional_cost = productPrice.promotional_cost;
priceing.marketing_cost = productPrice.marketing_cost;
priceing.distribution_cost = productPrice.distribution_cost;
priceing.qc_cost = productPrice.qc_cost;
priceing.we_wifi = productPrice.we_wifi;
priceing.we_cloud = productPrice.we_cloud;
priceing.cost_price = productPrice.cost_price;
priceing.package_cost = productPrice.package_cost;
priceing.total_package_cost = productPrice.total_package_cost;
priceing.amra_margin = productPrice.amra_margin;
priceing.dealer_margin = productPrice.dealer_margin;
priceing.retailer_margin = productPrice.retailer_margin;
priceing.retailer_cost = productPrice.retailer_cost;
priceing.mrp_cost = productPrice.mrp_cost;
priceing.last_grn_no = productPrice.last_grn_no;
save = _entities.SaveChanges();
}
if (save > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public bool AddProductPriceing(product_price_mapping productPrice, long create_by)
{
try
{
var priceing = new product_price_mapping();
priceing.product_id = productPrice.product_id;
priceing.product_version_id = productPrice.product_version_id;
priceing.color_id = productPrice.color_id;
priceing.is_active = productPrice.is_active;
priceing.created_by = create_by;
priceing.created_date = DateTime.Now;
priceing.b2b_cost = productPrice.b2b_cost;
priceing.corporate_cost = productPrice.corporate_cost;
priceing.dealer_cost = productPrice.dealer_cost;
priceing.emi_cost = productPrice.emi_cost;
priceing.gift_cost = productPrice.gift_cost;
priceing.internal_cost = productPrice.internal_cost;
priceing.online_cost = productPrice.online_cost;
priceing.telco_cost = productPrice.telco_cost;
priceing.is_deleted = false;
priceing.land_cost = productPrice.land_cost;
priceing.fin_cost = productPrice.fin_cost;
priceing.incentive_cost = productPrice.incentive_cost;
priceing.price_protection = productPrice.price_protection;
priceing.promotional_cost = productPrice.promotional_cost;
priceing.marketing_cost = productPrice.marketing_cost;
priceing.distribution_cost = productPrice.distribution_cost;
priceing.qc_cost = productPrice.qc_cost;
priceing.we_wifi = productPrice.we_wifi;
priceing.we_cloud = productPrice.we_cloud;
priceing.cost_price = productPrice.cost_price;
priceing.package_cost = productPrice.package_cost;
priceing.total_package_cost = productPrice.total_package_cost;
priceing.amra_margin = productPrice.amra_margin;
priceing.dealer_margin = productPrice.dealer_margin;
priceing.retailer_margin = productPrice.retailer_margin;
priceing.retailer_cost = productPrice.retailer_cost;
priceing.mrp_cost = productPrice.mrp_cost;
priceing.last_grn_no = productPrice.last_grn_no;
_entities.product_price_mapping.Add(priceing);
int save = _entities.SaveChanges();
if (save > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool InsertLogTable(product_price_mapping productPrice, long update_by)
{
var priceing = new product_price_mapping_log();
priceing.product_price_mapping_id = productPrice.product_price_mapping_id;
priceing.product_id = productPrice.product_id;
priceing.product_version_id = productPrice.product_version_id;
priceing.color_id = productPrice.color_id;
priceing.is_active = productPrice.is_active;
priceing.updated_by = update_by;
priceing.updated_date = DateTime.Now;
priceing.b2b_cost = productPrice.b2b_cost;
priceing.corporate_cost = productPrice.corporate_cost;
priceing.dealer_cost = productPrice.dealer_cost;
priceing.emi_cost = productPrice.emi_cost;
priceing.gift_cost = productPrice.gift_cost;
priceing.internal_cost = productPrice.internal_cost;
priceing.online_cost = productPrice.online_cost;
priceing.telco_cost = productPrice.telco_cost;
priceing.created_by = productPrice.created_by;
priceing.created_date = productPrice.created_date;
priceing.land_cost = productPrice.land_cost;
priceing.fin_cost = productPrice.fin_cost;
priceing.incentive_cost = productPrice.incentive_cost;
priceing.price_protection = productPrice.price_protection;
priceing.promotional_cost = productPrice.promotional_cost;
priceing.marketing_cost = productPrice.marketing_cost;
priceing.distribution_cost = productPrice.distribution_cost;
priceing.qc_cost = productPrice.qc_cost;
priceing.we_wifi = productPrice.we_wifi;
priceing.we_cloud = productPrice.we_cloud;
priceing.cost_price = productPrice.cost_price;
priceing.package_cost = productPrice.package_cost;
priceing.total_package_cost = productPrice.total_package_cost;
priceing.amra_margin = productPrice.amra_margin;
priceing.dealer_margin = productPrice.dealer_margin;
priceing.retailer_margin = productPrice.retailer_margin;
priceing.retailer_cost = productPrice.retailer_cost;
priceing.mrp_cost = productPrice.mrp_cost;
priceing.last_grn_no = productPrice.last_grn_no;
_entities.product_price_mapping_log.Add(priceing);
int save = _entities.SaveChanges();
return(true);
}
public bool CheckDuplicatePriceing(product_price_mapping productPrice)
{
try
{
var check =
_entities.product_price_mapping.SingleOrDefault(
a =>
a.product_id == productPrice.product_id && a.color_id == productPrice.color_id &&
a.product_version_id == productPrice.product_version_id);
if (check == null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
