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; } }