public int CreateReferralCampaign(ReferralCampaign referralCampaign)
 {
     var repo = Repo.Instance;
     using (var db = repo.OpenConnectionFromPool())
     {
         var id = repo.CreateReferralCampaign(db, referralCampaign);
         referralCampaign.order_number = id;
         referralCampaign.id = id;
         repo.UpdateReferralCampaign(db, referralCampaign);
         return id;
     }
 }
 public bool UpdateReferralCampaigns(ReferralCampaign referralCampaign)
 {
     var repo = Repo.Instance;
     using (var db = repo.OpenConnectionFromPool())
     {
         return repo.UpdateReferralCampaign(db, referralCampaign);
     }
 }