public CampaignTier ViewCampaignTierById(Int64 CampaignTierId)
{
CampaignTier response = null;
DataTable lQueryResult = ExecuteProcedureQuery("VIEW_CAMPAIGN_TIER_BY_ID",
new SqlParameter("@CampaignTierId", CampaignTierId),
iCommandTimeout: 30);
if (lQueryResult.Rows.Count > 0)
{
response = AutoMap <CampaignTier> .FromDataRow(lQueryResult.Rows[0]);
}
return(response);
}
public bool CreateNewCampaignTier(CampaignTier campaigntier)
{
return(ExecuteProcedureNonQuery("CREATE_NEW_CAMPAIGN_TIER",
new List <SqlParameter>()
{
new SqlParameter("@CampaignId", campaigntier.CampaignId),
new SqlParameter("@TierAmount", campaigntier.TierAmount),
new SqlParameter("@FirstPlacePrize", campaigntier.FirstPlacePrize),
new SqlParameter("@SecondPlacePrize", campaigntier.SecondPlacePrize),
new SqlParameter("@ThirdPlacePrize", campaigntier.ThirdPlacePrize),
new SqlParameter("@FourthPlacePrize", campaigntier.FourthPlacePrize),
new SqlParameter("@FifthPlacePrize", campaigntier.FifthPlacePrize),
new SqlParameter("@SixthPlacePrize", campaigntier.SixthPlacePrize),
},
iCommandTimeout: 60));
}
