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);
}
}