コード例 #1
0
 public bool CreateNewCampaignDiscount(CampaignDiscount campaigndiscount)
 {
     return(ExecuteProcedureNonQuery("CREATE_NEW_CAMPAIGN_DISCOUNT",
                                     new List <SqlParameter>()
     {
         new SqlParameter("@CampaignId", campaigndiscount.CampaignId),
         new SqlParameter("@AmountOfTickets", campaigndiscount.AmountOfTickets),
         new SqlParameter("@Price", campaigndiscount.Price),
     },
                                     iCommandTimeout: 60));
 }
コード例 #2
0
        public CampaignDiscount ViewCampaignDiscountById(Int64 CampaignDiscountId)
        {
            CampaignDiscount response     = null;
            DataTable        lQueryResult = ExecuteProcedureQuery("VIEW_CAMPAIGN_DISCOUNT_BY_ID",
                                                                  new SqlParameter("@CampaignDiscountId", CampaignDiscountId),
                                                                  iCommandTimeout: 30);

            if (lQueryResult.Rows.Count > 0)
            {
                response = AutoMap <CampaignDiscount> .FromDataRow(lQueryResult.Rows[0]);
            }
            return(response);
        }