//-----------Save and update Costvariant options-------------------------
public static void SaveAndUpdateCostVariant(CostVariantsGetByCostVariantIDInfo variantObj, string variantOptions, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("CostVariantID", variantObj.CostVariantID));
parameterCollection.Add(new KeyValuePair <string, object>("CostVariantName", variantObj.CostVariantName));
parameterCollection.Add(new KeyValuePair <string, object>("Description", variantObj.Description));
parameterCollection.Add(new KeyValuePair <string, object>("InputTypeID", variantObj.InputTypeID));
parameterCollection.Add(new KeyValuePair <string, object>("DisplayOrder", variantObj.DisplayOrder));
parameterCollection.Add(new KeyValuePair <string, object>("ShowInAdvanceSearch", variantObj.ShowInAdvanceSearch));
parameterCollection.Add(new KeyValuePair <string, object>("ShowInComparison", variantObj.ShowInComparison));
parameterCollection.Add(new KeyValuePair <string, object>("IsIncludeInPriceRule", variantObj.IsIncludeInPriceRule));
parameterCollection.Add(new KeyValuePair <string, object>("IsActive", variantObj.IsActive));
parameterCollection.Add(new KeyValuePair <string, object>("IsModified", variantObj.IsModified));
parameterCollection.Add(new KeyValuePair <string, object>("VariantOption", variantOptions));
parameterCollection.Add(new KeyValuePair <string, object>("IsNewFlag", variantObj.Flag));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateCostVariants", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
//-----------Save and update Costvariant options-------------------------
public static void SaveAndUpdateCostVariant(CostVariantsGetByCostVariantIDInfo variantObj, string variantOptions, AspxCommonInfo aspxCommonObj)
{
try
{
AspxCostVarMgntProvider.SaveAndUpdateCostVariant(variantObj, variantOptions, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
//-----------Save and update Costvariant options-------------------------
public void SaveAndUpdateCostVariant(CostVariantsGetByCostVariantIDInfo variantObj, string variantOptions, AspxCommonInfo aspxCommonObj)
{
try
{
AspxCostVarMgntController.SaveAndUpdateCostVariant(variantObj, variantOptions, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
//-----------Save and update Costvariant options-------------------------
public static void SaveAndUpdateCostVariant(CostVariantsGetByCostVariantIDInfo variantObj, string variantOptions, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@CostVariantID", variantObj.CostVariantID));
parameterCollection.Add(new KeyValuePair<string, object>("@CostVariantName", variantObj.CostVariantName));
parameterCollection.Add(new KeyValuePair<string, object>("@Description", variantObj.Description));
parameterCollection.Add(new KeyValuePair<string, object>("@InputTypeID", variantObj.InputTypeID));
parameterCollection.Add(new KeyValuePair<string, object>("@DisplayOrder", variantObj.DisplayOrder));
parameterCollection.Add(new KeyValuePair<string, object>("@ShowInAdvanceSearch", variantObj.ShowInAdvanceSearch));
parameterCollection.Add(new KeyValuePair<string, object>("@ShowInComparison", variantObj.ShowInComparison));
parameterCollection.Add(new KeyValuePair<string, object>("@IsIncludeInPriceRule", variantObj.IsIncludeInPriceRule));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", variantObj.IsActive));
parameterCollection.Add(new KeyValuePair<string, object>("@IsModified", variantObj.IsModified));
parameterCollection.Add(new KeyValuePair<string, object>("@VariantOption", variantOptions));
parameterCollection.Add(new KeyValuePair<string, object>("@IsNewFlag", variantObj.Flag));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateCostVariants", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
