public void ClearAll(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_ClearCompareItems", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void DeleteCompareItem(int compareItemID, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("CompareItemID", compareItemID));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_DeleteCompareItem", parameter);
}
catch (Exception e)
{
throw e;
}
}
public bool CheckCompareItems(int ID, AspxCommonInfo aspxCommonObj, string costVariantValueIDs)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", ID));
parameter.Add(new KeyValuePair <string, object>("CostVariantValueIDs", costVariantValueIDs));
OracleHandler sqlH = new OracleHandler();
string isExist = sqlH.ExecuteNonQueryAsGivenType <string>("usp_Aspx_CheckCompareItems", parameter, "IsExist");
return(Convert.ToBoolean(isExist));
}
catch (Exception e)
{
throw e;
}
}
public bool CheckCompareItems(int ID, AspxCommonInfo aspxCommonObj, string costVariantValueIDs)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", ID));
parameter.Add(new KeyValuePair <string, object>("@CostVariantValueIDs", costVariantValueIDs));
SQLHandler sqlH = new SQLHandler();
bool isExist = sqlH.ExecuteNonQueryAsGivenType <bool>("[usp_Aspx_CheckCompareItems]", parameter, "@IsExist");
return(isExist);
}
catch (Exception e)
{
throw e;
}
}
public int SaveCompareItems(SaveCompareItemInfo saveCompareItemObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", saveCompareItemObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("CompareItemID", 0));
parameter.Add(new KeyValuePair <string, object>("IP", saveCompareItemObj.IP));
parameter.Add(new KeyValuePair <string, object>("CountryName", saveCompareItemObj.CountryName));
parameter.Add(new KeyValuePair <string, object>("CostVariantValueIDs", saveCompareItemObj.CostVariantIDs));
OracleHandler sqlH = new OracleHandler();
int compareID = sqlH.ExecuteNonQuery("usp_Aspx_AddItemsToCompare", parameter, "CompareAddedItemID");
return(compareID);
}
catch (Exception e)
{
throw e;
}
}