public static List <AdvertChargeRates> GetAdvertChargeRatesByCategoryId(string CurrencyId, string AdvertCategoryId)
{
List <AdvertChargeRates> lstAdvertChargeRates = new List <AdvertChargeRates>();
//Accessing DB Layer
DbCommand dbCommand = db.GetStoredProcCommand("prSelAdvertChargeRatesByCategoryId");
db.AddInParameter(dbCommand, "CurrencyId", DbType.AnsiString, CurrencyId);
db.AddInParameter(dbCommand, "AdvertCategoryId", DbType.AnsiString, AdvertCategoryId);
IDataReader dr = null;
try
{
// Execute command
dr = db.ExecuteReader(dbCommand);
//Set Output and add to the list
while (dr.Read())
{
AdvertChargeRates objAdvertChargeRates = new AdvertChargeRates();
objAdvertChargeRates.ChargeRateId = Convert.ToInt32(dr["ChargeRateId"].ToString());
objAdvertChargeRates.Description = dr["Description"].ToString();
objAdvertChargeRates.MonthCount = Convert.ToInt32(dr["MonthCount"].ToString());
objAdvertChargeRates.CategoryId = dr["CategoryId"].ToString();
objAdvertChargeRates.CurrencyId = dr["CurrencyId"].ToString();
objAdvertChargeRates.Rate = Convert.ToDecimal(dr["Rate"].ToString());
objAdvertChargeRates.FreeYN = Convert.ToBoolean(dr["FreeYN"].ToString());
objAdvertChargeRates.UntilYouBuyYN = Convert.ToBoolean(dr["UntilYouBuyYN"].ToString());
lstAdvertChargeRates.Add(objAdvertChargeRates);
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
dr.Close();
}
return(lstAdvertChargeRates);
}
public static AdvertChargeRates GetAdvertChargeRatesById(int ChargeRatesId)
{
//Accessing DB Layer
DbCommand dbCommand = db.GetStoredProcCommand("prSelAdvertChargeRatesByID");
//Adding Input parameters
db.AddInParameter(dbCommand, "ChargeRateId", DbType.Int32, ChargeRatesId);
IDataReader dr = null;
AdvertChargeRates objAdvertChargeRates = new AdvertChargeRates();
try
{
// Execute command
dr = db.ExecuteReader(dbCommand);
//Set Output
while (dr.Read())
{
//Set Output
objAdvertChargeRates.ChargeRateId = Convert.ToInt32(dr["ChargeRateId"].ToString());
objAdvertChargeRates.Description = dr["Description"].ToString();
objAdvertChargeRates.MonthCount = Convert.ToInt32(dr["MonthCount"].ToString());
objAdvertChargeRates.CategoryId = dr["CategoryId"].ToString();
objAdvertChargeRates.CurrencyId = dr["CurrencyId"].ToString();
objAdvertChargeRates.Rate = Convert.ToDecimal(dr["Rate"].ToString());
objAdvertChargeRates.FreeYN = Convert.ToBoolean(dr["FreeYN"].ToString());
objAdvertChargeRates.UntilYouBuyYN = Convert.ToBoolean(dr["UntilYouBuyYN"].ToString());
}
}
catch (Exception ex)
{
objAdvertChargeRates.RespCode = 1;
objAdvertChargeRates.RespDesc = ex.ToString();
}
finally
{
dr.Close();
}
return(objAdvertChargeRates);
}
