private APIResponse ValidatePromo(UpdatePromoInfo updatePromoInfo) { AddComboPromoInfo comboPrice = new AddComboPromoInfo(); comboPrice.CountryCode = new List <string>(); comboPrice.CountryCode.Add(updatePromoInfo.CountryCode); comboPrice.MainProductCode = updatePromoInfo.ProductCode; comboPrice.BV = updatePromoInfo.CUV; comboPrice.StartDate = updatePromoInfo.StartDate; comboPrice.EndDate = updatePromoInfo.EndDate; comboPrice.PriceSchemeIds = updatePromoInfo.PriceSchemeId; comboPrice.ComboPriceDetails = new List <ComboPriceDetails>(); comboPrice.ComboPriceDetails.Add(new ComboPriceDetails { ProductCode = updatePromoInfo.ProductCode, IRPrice = updatePromoInfo.IRRegularPrice, IRPromoPrice = updatePromoInfo.IRPromoPrice, RetailPrice = updatePromoInfo.RetailRegularPrice, RetailPromoPrice = updatePromoInfo.RetailPromoPrice, PricePlanId = updatePromoInfo.PricePlanId }); APIResponse aPIResponse = this.ValidatePromoForCombo(comboPrice); return(aPIResponse); }
public APIResponse ValidatePromoForCombo(AddComboPromoInfo comboPrice) { APIResponse aPIResponse = new APIResponse(); try { foreach (string country in comboPrice.CountryCode) { foreach (ComboPriceDetails comboPriceDetails in comboPrice.ComboPriceDetails) { string query = "[dbo].[usp_ValidatePromoProductForCombo]"; using (SqlConnection con = new SqlConnection(this.settings.Value.GQNet)) { con.Open(); using (SqlCommand command = new SqlCommand(query, con)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@MainProductCode", comboPrice.MainProductCode); command.Parameters.AddWithValue("@MainProdPricePlanId", comboPrice.PricePlanId); command.Parameters.AddWithValue("@ProdCode", comboPriceDetails.ProductCode); command.Parameters.AddWithValue("@PricePlanID", comboPriceDetails.PricePlanId); command.Parameters.AddWithValue("@IRPrice", comboPriceDetails.IRPromoPrice); command.Parameters.AddWithValue("@ReIRPrice", comboPriceDetails.IRPrice); command.Parameters.AddWithValue("@RetailPrice", comboPriceDetails.RetailPromoPrice); command.Parameters.AddWithValue("@ReRetailPrice", comboPriceDetails.RetailPrice); command.Parameters.AddWithValue("@CountryCode", country); command.Parameters.AddWithValue("@BV", comboPrice.BV); command.Parameters.AddWithValue("@EndDate", comboPrice.StartDate); command.Parameters.AddWithValue("@StartDate", comboPrice.EndDate); command.Parameters.AddWithValue("@PriceSchemeIds", comboPrice.PriceSchemeIds); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { aPIResponse.ErrorMessage = Convert.ToString(reader["Error"]); aPIResponse.IsSuccess = string.IsNullOrEmpty(aPIResponse.ErrorMessage) ? true : false; } else { aPIResponse.IsSuccess = true; } } } } } } catch (Exception ex) { aPIResponse.IsSuccess = false; aPIResponse.ErrorMessage = ex.Message; } return(aPIResponse); }
public APIResponse UpdateCombotPromo(AddComboPromoInfo addComboPromo) { return(iPromoLaunchRepository.UpdateCombotPromo(addComboPromo)); }
public APIResponse ValidatePromoForCombo(AddComboPromoInfo addComboPromoInfo) { return(iPromoLaunchRepository.ValidatePromoForCombo(addComboPromoInfo)); }
public APIResponse AddCombotPromo(AddComboPromoInfo updatePromoInfo) { return(iPromoLaunchRepository.AddCombotPromo(updatePromoInfo)); }
public ActionResult UpdateCombotPromo([FromBody] AddComboPromoInfo updateComboProd) { return(Json(iPromoLaunchService.UpdateCombotPromo(updateComboProd))); }
public ActionResult AddCombo([FromBody] AddComboPromoInfo addComboProd) { return(Json(iPromoLaunchService.AddCombotPromo(addComboProd))); }
public ActionResult ValidateComboPromo([FromBody] AddComboPromoInfo addComboProd) { return(Json(iPromoLaunchService.ValidatePromoForCombo(addComboProd))); }