当前位置: 首页>>代码示例>>C#>>正文


C# DataAccess.GetParameterValue方法代码示例

本文整理汇总了C#中DataAccess.GetParameterValue方法的典型用法代码示例。如果您正苦于以下问题:C# DataAccess.GetParameterValue方法的具体用法?C# DataAccess.GetParameterValue怎么用?C# DataAccess.GetParameterValue使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在DataAccess的用法示例。


在下文中一共展示了DataAccess.GetParameterValue方法的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: CreateDonation

 public Donation CreateDonation(Donation donation)
 {
     using (var db = new DataAccess())
     {
         db.CreateStoredProcCommand("dbo.CreateDonation");
         db.AddInputParameter("@DonationProviderId", donation.DonationProviderId);
         db.AddInputParameter("@UserId", donation.UserId);
         db.AddInputParameter("@ExternalId", donation.ExternalId);
         db.AddInputParameter("@ExternalStatus", donation.ExternalStatus);
         db.AddInputParameter("@IsCompleted", donation.IsCompleted);
         db.AddInputParameter("@CountryId", donation.CountryId);
         db.AddInputParameter("@StateId", donation.StateId);
         db.AddInputParameter("@CityId", donation.CityId);
         db.AddInputParameter("@Amount", donation.Amount);
         db.AddInputParameter("@Currency", donation.Currency);
         db.AddInputParameter("@UserMessage", donation.UserMessage);
         db.AddInputParameter("@ProviderData", donation.ProviderXml);                
         db.AddInputParameter("@DonationSubscriptionId", donation.DonationSubscriptionId);
         db.AddInputParameter("@TransactionType", donation.TransactionType);
         db.AddOutputParameter("@DonationId", DbType.Int32);
         try
         {
             db.ExecuteNonQuery();
             donation.DonationId = db.GetParameterValue<int>("@DonationId");
         }
         catch (Exception ex)
         {
             Log.Error("Error while creating donation.", ex);
             throw;
         }
     }
     return donation;
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:33,代码来源:DonationRepository.cs

示例2: TryGetUserRegistered

 public bool TryGetUserRegistered(string email, string provider, out int? userId, out bool isOAuthUser)
 {
     userId = null;
     using (var db = new DataAccess())
     {
         db.CreateStoredProcCommand("dbo.GetUserRegistered");
         db.AddInputParameter("@Email", DbType.String, email);
         db.AddInputParameter("@Provider", DbType.String, provider);
         db.AddOutputParameter("@UserId", DbType.Int32);
         db.AddOutputParameter("@IsOAuthUser", DbType.Boolean);
         try
         {
             db.ExecuteNonQuery();
             userId = db.GetParameterValue<int?>("@UserId");
             isOAuthUser = db.GetParameterValue<bool>("@IsOAuthUser");
         }
         catch (Exception ex)
         {
             Logger.Error("Error while checking registered user.", ex);
             throw;
         }
     }
     return userId.HasValue;
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:24,代码来源:AccountRepository.cs

示例3: CreateUser

        public User CreateUser(User user)
        {
            using (var tran = new DbTransactionManager())
            {
                tran.BeginTransaction();
                using (var db = new DataAccess(tran))
                {
                    try
                    {
                        db.CreateStoredProcCommand("dbo.CreateUser");
                        db.AddInputParameter("@Email", DbType.String, user.Email);
                        db.AddInputParameter("@DisplayName", DbType.String, user.DisplayName);
                        db.AddOutputParameter("@UserId", DbType.Int32);
                        db.ExecuteNonQuery();
                        user.UserId = db.GetParameterValue<int>("@UserId");

                        user.OAuth.UserId = user.UserId;
                        user.OAuth = CreateOAuthUser(user.OAuth, tran);

                        db.CreateStoredProcCommand("dbo.CreateUserProfile");
                        db.AddInputParameter("@UserId", DbType.String, user.UserId);
                        db.AddInputParameter("@LanguageId", DbType.String, user.Profile.Lang.LanguageId);
                        db.AddInputParameter("@Dob", DbType.String, user.Profile.Dob);
                        db.AddInputParameter("@Nationality", DbType.String, user.Profile.Nationality);
                        db.AddOutputParameter("@UserProfileId", DbType.Int32);
                        db.ExecuteNonQuery();
                        user.Profile.UserProfileId = db.GetParameterValue<int>("@UserProfileId");

                        user = GetUser(user.UserId);
                        tran.Commit();
                    }
                    catch (Exception ex)
                    {
                        tran.Rollback();
                        Logger.Error("Error while creating user.", ex);
                        throw;
                    }
                    return user;
                }
            }
        }
开发者ID:August2008,项目名称:August2008.org,代码行数:41,代码来源:AccountRepository.cs

示例4: CreateHero

 public int CreateHero(Hero hero, IEnumerable<IPostedFile> photos)
 {
     var heroId = 0;
     using (var tran = new DbTransactionManager())
     {
         tran.BeginTransaction();
         using (var db = new DataAccess(tran))
         {
             db.CreateStoredProcCommand("dbo.CreateHero");
             db.AddInputParameter("@FirstName", DbType.String, hero.FirstName);
             db.AddInputParameter("@LastName", DbType.String, hero.LastName);
             db.AddInputParameter("@MiddleName", DbType.String, hero.MiddleName);
             db.AddInputParameter("@Dob", DbType.DateTime, hero.Dob);
             db.AddInputParameter("@Died", DbType.DateTime, hero.Died);
             db.AddInputParameter("@MilitaryGroupId", DbType.Int32, hero.MilitaryGroupId);
             db.AddInputParameter("@MilitaryRankId", DbType.Int32, hero.MilitaryRankId);
             db.AddInputParameter("@MilitaryAwardId", DbType.Int32, hero.MilitaryAwardId);
             db.AddInputParameter("@Biography", DbType.String, hero.Biography);
             db.AddInputParameter("@LanguageId", DbType.Int32, hero.LanguageId);
             db.AddInputParameter("@UpdatedBy", DbType.Int32, hero.UpdatedBy);
             db.AddInputParameter("@Photos", DbType.Xml, photos.ToDbXml());
             db.AddOutputParameter("@HeroId", DbType.Int32);
             try
             {
                 db.ExecuteNonQuery();
                 heroId = db.GetParameterValue<int>("@HeroId");
                 SaveBlobs(heroId, photos);
                 tran.Commit();
             }
             catch (SqlException ex)
             {
                 tran.Rollback();
                 Logger.Error("Error while creating hero", ex);
                 throw new RepositoryException("Oops! Something went wrong... :(", ex);
             }
             catch (Exception ex)
             {
                 tran.Rollback();
                 Logger.Error("Error while creating hero", ex);
                 throw new RepositoryException("Oops! Something went wrong... :(", ex);
             }
             return heroId;
         }
     }
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:45,代码来源:HeroRepository.cs

示例5: SearchHeros

        public HeroSearchCriteria SearchHeros(HeroSearchCriteria criteria)
        {
            var heros = new List<Hero>();
            var photos = new List<HeroPhoto>();

            using (var db = new DataAccess())
            {
                db.CreateStoredProcCommand("dbo.GetHeros");
                db.AddInputParameter("@PageNo", DbType.Int32, criteria.PageNo);
                db.AddInputParameter("@Name", DbType.String, criteria.Name);
                db.AddInputParameter("@PageSize", DbType.Int32, criteria.PageSize);
                db.AddInputParameter("@LanguageId", DbType.Int32, criteria.LanguageId);
                db.AddOutputParameter("@TotalCount", DbType.Int32);
                try
                {
                    db.ReadInto(heros, photos);
                    heros.ForEach(x => x.Photos = photos.Where(y => y.HeroId == x.HeroId));
                    GetBlobs(heros, new CloudDataAccess());
                    criteria.Result = heros;
                    criteria.TotalCount = db.GetParameterValue<int>("@TotalCount");
                }
                catch (Exception ex)
                {
                    Logger.Error("Error while searching hero", ex);
                    throw;
                }
                return criteria;
            }
        }
开发者ID:August2008,项目名称:August2008.org,代码行数:29,代码来源:HeroRepository.cs

示例6: CreateDonationSubscription

 public DonationSubscription CreateDonationSubscription(DonationSubscription subscription)
 {
     using (var db = new DataAccess())
     {
         db.CreateStoredProcCommand("dbo.CreateDonationSubscription");
         db.AddInputParameter("@StartDate", subscription.StartDate);
         db.AddInputParameter("@EndDate", subscription.EndDate);
         db.AddInputParameter("@RecurrenceTimes", subscription.RecurrenceTimes);
         db.AddInputParameter("@SubscriptionId", subscription.SubscriptionId);
         db.AddInputParameter("@UserId", subscription.UserId);
         db.AddInputParameter("@Username", subscription.Username);
         db.AddInputParameter("@Password", subscription.Password);
         db.AddInputParameter("@ProviderData", subscription.ProviderXml);
         db.AddOutputParameter("@DonationSubscriptionId", DbType.Int32);
         try
         {
             db.ExecuteNonQuery();
             subscription.DonationSubscriptionId = db.GetParameterValue<int>("@DonationSubscriptionId");
         }
         catch (Exception ex)
         {
             Log.Error("Error while crating subscription.", ex);
             throw;
         }
     }
     return subscription;
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:27,代码来源:DonationRepository.cs

示例7: CreateOAuthUser

 private OAuthUser CreateOAuthUser(OAuthUser user, DbTransactionManager tran)
 {
     using (var db = new DataAccess(tran))
     {
         db.CreateStoredProcCommand("dbo.CreateOAuthUser");
         db.AddInputParameter("@UserId", DbType.String, user.UserId);
         db.AddInputParameter("@Email", DbType.String, user.Email);
         db.AddInputParameter("@ProviderId", DbType.String, user.ProviderId);
         db.AddInputParameter("@ProviderName", DbType.String, user.ProviderName);
         db.AddInputParameter("@ProviderData", DbType.Xml, user.ProviderData.ToDbXml());
         db.AddOutputParameter("@OAuthUserId", DbType.Int32);
         try
         {
             db.ExecuteNonQuery();
             user.OAuthUserId = db.GetParameterValue<int>("@OAuthUserId");
         }
         catch (Exception ex)
         {
             Logger.Error("Error while creating OAuth user", ex);
             throw;
         }
     }
     return user;
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:24,代码来源:AccountRepository.cs

示例8: CreateCity

 public City CreateCity(City city)
 {
     using (var db = new DataAccess())
     {
         db.CreateStoredProcCommand("dbo.CreateCity");
         db.AddInputParameter("@StateId", DbType.Int32, city.StateId);
         db.AddInputParameter("@State", DbType.String, city.State);
         db.AddInputParameter("@Name", DbType.String, city.Name);
         db.AddInputParameter("@PostalCode", DbType.String, city.PostalCode);                
         db.AddInputParameter("@Latitude", DbType.Double, city.Latitude);
         db.AddInputParameter("@Longitude", DbType.Double, city.Longitude);
         db.AddOutputParameter("@CityId", DbType.Int32);
         try
         {
             db.ExecuteNonQuery();
             city.CityId = db.GetParameterValue<int>("@CityId");
         }
         catch (Exception ex)
         {
             Logger.Error("Error while creating city.", ex);
             throw;
         }
     }
     return city;
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:25,代码来源:MetadataRepository.cs

示例9: CreateState

 public State CreateState(State state)
 {
     using (var db = new DataAccess())
     {
         db.CreateStoredProcCommand("dbo.CreateState");
         db.AddInputParameter("@CountryId", DbType.Int32, state.CountryId);
         db.AddInputParameter("@Country", DbType.String, state.Country);
         db.AddInputParameter("@Name", DbType.String, state.Name);
         db.AddInputParameter("@FullName", DbType.String, state.FullName);
         db.AddInputParameter("@Latitude", DbType.Double, state.Latitude);
         db.AddInputParameter("@Longitude", DbType.Double, state.Longitude);
         db.AddOutputParameter("@StateId", DbType.Int32);
         try
         {
             db.ExecuteNonQuery();
             state.StateId = db.GetParameterValue<int>("@StateId");
         }
         catch (Exception ex)
         {
             Logger.Error("Error while creating state.", ex);
             throw;
         }
     }
     return state;
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:25,代码来源:MetadataRepository.cs

示例10: CreateCountry

 public Country CreateCountry(Country country)
 {
     using (var db = new DataAccess())
     {
         db.CreateStoredProcCommand("dbo.CreateCountry");
         db.AddInputParameter("@Name", DbType.String, country.Name);
         db.AddInputParameter("@FullName", DbType.String, country.FullName);
         db.AddInputParameter("@Latitude", DbType.Double, country.Latitude);
         db.AddInputParameter("@Longitude", DbType.Double, country.Longitude);
         db.AddOutputParameter("@CountryId", DbType.Int32);
         try
         {
             db.ExecuteNonQuery();
             country.CountryId = db.GetParameterValue<int>("@CountryId");
         }
         catch (Exception ex)
         {
             Logger.Error("Error while creating country.", ex);
             throw;
         }
     }
     return country;
 }
开发者ID:August2008,项目名称:August2008.org,代码行数:23,代码来源:MetadataRepository.cs


注:本文中的DataAccess.GetParameterValue方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。