Beispiel #1
0
        public void Insert(UserModel user)
        {
            using (SqlConnection con = DbUtil.GetConnection())
            {
                con.Open();
                con.Execute("UserInsert",
                            new
                {
                    UserId = user.UserId
                    ,
                    UserName = user.UserName
                    ,
                    Email = user.Email
                    ,
                    Password = user.Password
                    ,
                    IsConfirmed = user.IsConfirmed
                    ,
                    PasswordFailuresSinceLastSuccess = user.PasswordFailuresSinceLastSuccess
                    ,
                    LastPasswordFailureDate = user.LastPasswordFailureDate
                                              //,  ConfirmationToken = user.ConfirmationToken
                    ,
                    CreateDate = user.CreateDate
                    ,
                    PasswordChangedDate = user.PasswordChangedDate
                                          //                     , PasswordVerificationToken = user.PasswordVerificationToken
                                          //                     ,PasswordVerificationTokenExpirationDate = user.PasswordVerificationTokenExpirationDate
                                          // ,
                                          // FacilitiesID = user.FacilitiesID
                                          //,
                                          // DistrictID = user.DistrictID
                                          // ,EmailResult = user.EmailResult
                    ,
                    IsActive = user.IsActive
                               //                     ,  FileLocation = user.FileLocation
                    ,
                    FirstName = user.FirstName
                    ,
                    LastName = user.LastName
                    ,
                    TimeZone = user.TimeZone
                               //                     ,  Culture = user.Culture
                               // ,
                               //  ServerAdmin = user.ServerAdmin

                               //  Comment = user.Comment
                               //  //    ,CreationDate =user.CreationDate
                               //  , IsApproved=user.IsApproved
                               //  , IsLockedOut=user.IsLockedOut
                               //  , IsOnline=user.IsOnline
                               //  , LastActivityDate=user.LastActivityDate
                               ////  , LastLockoutDate=user.LastLockoutDate
                               //  , LastLoginDate=DateTime.Now //user.LastLoginDate
                               //  //,LastPasswordChangedDate =user.LastPasswordChangedDate
                               //  , PasswordQuestion=user.PasswordQuestion
                               //  , ProviderName=user.ProviderName
                               //  , ProviderUserKey=user.ProviderUserKey
                               //  , UserId=user.UserId
                               // ,
                               ///EmployeeNumber = user.EmployeeNumber
                               // ,
                               // MI = user.MI
                },
                            null, null, CommandType.StoredProcedure);
            }
        }