public int Update(SiteUsersInfo model) { StringBuilder sb = new StringBuilder(500); sb.Append(@"update SiteUsers set ApplicationId = @ApplicationId,Coded = @Coded,Named = @Named,LowerName = @LowerName,MobileAlias = @MobileAlias,IsAnonymous = @IsAnonymous,LastActivityDate = @LastActivityDate,LastUpdatedDate = @LastUpdatedDate where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@ApplicationId", SqlDbType.UniqueIdentifier), new SqlParameter("@Coded", SqlDbType.VarChar, 20), new SqlParameter("@Named", SqlDbType.NVarChar, 50), new SqlParameter("@LowerName", SqlDbType.NVarChar, 256), new SqlParameter("@MobileAlias", SqlDbType.NVarChar, 16), new SqlParameter("@IsAnonymous", SqlDbType.Bit), new SqlParameter("@LastActivityDate", SqlDbType.DateTime), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.ApplicationId; parms[2].Value = model.Coded; parms[3].Value = model.Named; parms[4].Value = model.LowerName; parms[5].Value = model.MobileAlias; parms[6].Value = model.IsAnonymous; parms[7].Value = model.LastActivityDate; parms[8].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int InsertByOutput(SiteUsersInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into SiteUsers (Id,ApplicationId,Coded,Named,LowerName,MobileAlias,IsAnonymous,LastActivityDate,LastUpdatedDate) values (@Id,@ApplicationId,@Coded,@Named,@LowerName,@MobileAlias,@IsAnonymous,@LastActivityDate,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@ApplicationId", SqlDbType.UniqueIdentifier), new SqlParameter("@Coded", SqlDbType.VarChar, 20), new SqlParameter("@Named", SqlDbType.NVarChar, 50), new SqlParameter("@LowerName", SqlDbType.NVarChar, 256), new SqlParameter("@MobileAlias", SqlDbType.NVarChar, 16), new SqlParameter("@IsAnonymous", SqlDbType.Bit), new SqlParameter("@LastActivityDate", SqlDbType.DateTime), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.ApplicationId; parms[2].Value = model.Coded; parms[3].Value = model.Named; parms[4].Value = model.LowerName; parms[5].Value = model.MobileAlias; parms[6].Value = model.IsAnonymous; parms[7].Value = model.LastActivityDate; parms[8].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.QdhtyyDbConnString, CommandType.Text, sb.ToString(), parms)); }
public IList <SiteUsersInfo> GetList() { StringBuilder sb = new StringBuilder(300); sb.Append(@"select ApplicationId,Id,Coded,Named,LowerName,MobileAlias,IsAnonymous,LastActivityDate,LastUpdatedDate from SiteUsers order by LastUpdatedDate desc " ); IList <SiteUsersInfo> list = new List <SiteUsersInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { SiteUsersInfo model = new SiteUsersInfo(); model.ApplicationId = reader.GetGuid(0); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.LowerName = reader.GetString(4); model.MobileAlias = reader.GetString(5); model.IsAnonymous = reader.GetBoolean(6); model.LastActivityDate = reader.GetDateTime(7); model.LastUpdatedDate = reader.GetDateTime(8); list.Add(model); } } } return(list); }
public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status) { if (passwordQuestion == null) { passwordQuestion = ""; } if (passwordAnswer == null) { passwordAnswer = ""; } var bll = new SiteUsers(); var oldInfo = bll.GetModelByJoin(username, providerUserKey); if (oldInfo != null) { status = MembershipCreateStatus.Success; return(new MembershipUser(this.Name, oldInfo.Named, oldInfo.Id, oldInfo.Email, oldInfo.PasswordQuestion, oldInfo.Comment, oldInfo.IsApproved, oldInfo.IsLockedOut, oldInfo.CreateDate, oldInfo.LastLoginDate, oldInfo.LastActivityDate, oldInfo.LastPasswordChangedDate, oldInfo.LastLockoutDate)); } var appId = Guid.Parse(new Applications().GetAspnetAppId(ApplicationName).ToString()); var currTime = DateTime.Now; var mBll = new SiteMembers(); var userId = Guid.NewGuid(); var uInfo = new SiteUsersInfo(appId, userId, "", username, username.ToLower(), "", false, currTime, currTime); var salt = GenerateSalt(); var mInfo = new SiteMembersInfo(appId, userId, EncodePassword(password, (int)PasswordFormat, salt), (int)PasswordFormat, salt, "", email, email.ToLower(), passwordQuestion, passwordAnswer, isApproved, false, currTime, currTime, currTime, currTime, 0, currTime, 0, currTime, ""); bll.InsertByOutput(uInfo); mBll.Insert(mInfo); oldInfo = bll.GetModelByJoin(username, providerUserKey); status = MembershipCreateStatus.Success; return(new MembershipUser(this.Name, oldInfo.Named, oldInfo.Id, oldInfo.Email, oldInfo.PasswordQuestion, oldInfo.Comment, oldInfo.IsApproved, oldInfo.IsLockedOut, oldInfo.CreateDate, oldInfo.LastLoginDate, oldInfo.LastActivityDate, oldInfo.LastPasswordChangedDate, oldInfo.LastLockoutDate)); }
public SiteUsersInfo GetModel(string username) { SiteUsersInfo model = null; var cmdText = @"select top 1 u.ApplicationId,u.Id,u.Coded,u.Named,u.LowerName,u.MobileAlias,u.IsAnonymous,u.LastActivityDate,u.LastUpdatedDate from SiteUsers u where Named = @Named " ; var parm = new SqlParameter("@Named", SqlDbType.NVarChar, 50); parm.Value = username; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, cmdText, parm)) { if (reader != null) { if (reader.Read()) { model = new SiteUsersInfo(); model.ApplicationId = reader.GetGuid(0); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.LowerName = reader.GetString(4); model.MobileAlias = reader.GetString(5); model.IsAnonymous = reader.GetBoolean(6); model.LastActivityDate = reader.GetDateTime(7); model.LastUpdatedDate = reader.GetDateTime(8); } } } return(model); }
public IList <SiteUsersInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from SiteUsers "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <SiteUsersInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber, ApplicationId,Id,Coded,Named,LowerName,MobileAlias,IsAnonymous,LastActivityDate,LastUpdatedDate from SiteUsers " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <SiteUsersInfo> list = new List <SiteUsersInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { SiteUsersInfo model = new SiteUsersInfo(); model.ApplicationId = reader.GetGuid(1); model.Id = reader.GetGuid(2); model.Coded = reader.GetString(3); model.Named = reader.GetString(4); model.LowerName = reader.GetString(5); model.MobileAlias = reader.GetString(6); model.IsAnonymous = reader.GetBoolean(7); model.LastActivityDate = reader.GetDateTime(8); model.LastUpdatedDate = reader.GetDateTime(9); list.Add(model); } } } return(list); }
public IList <SiteUsersInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select ApplicationId,Id,Coded,Named,LowerName,MobileAlias,IsAnonymous,LastActivityDate,LastUpdatedDate from SiteUsers "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by LastUpdatedDate desc "); IList <SiteUsersInfo> list = new List <SiteUsersInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { SiteUsersInfo model = new SiteUsersInfo(); model.ApplicationId = reader.GetGuid(0); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.LowerName = reader.GetString(4); model.MobileAlias = reader.GetString(5); model.IsAnonymous = reader.GetBoolean(6); model.LastActivityDate = reader.GetDateTime(7); model.LastUpdatedDate = reader.GetDateTime(8); list.Add(model); } } } return(list); }
public SiteUsersInfo GetModel(Guid id) { SiteUsersInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 ApplicationId,Id,Coded,Named,LowerName,MobileAlias,IsAnonymous,LastActivityDate,LastUpdatedDate from SiteUsers where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier) }; parms[0].Value = id; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AssetDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new SiteUsersInfo(); model.ApplicationId = reader.GetGuid(0); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.LowerName = reader.GetString(4); model.MobileAlias = reader.GetString(5); model.IsAnonymous = reader.GetBoolean(6); model.LastActivityDate = reader.GetDateTime(7); model.LastUpdatedDate = reader.GetDateTime(8); } } } return(model); }
public SiteUsersInfo GetModelByJoin(string username, object Id) { SiteUsersInfo model = null; var sb = new StringBuilder(500); sb.Append(@"select top 1 u.ApplicationId,u.Id,u.Coded,u.Named,u.LowerName,u.MobileAlias,u.IsAnonymous,u.LastActivityDate,u.LastUpdatedDate ,m.Password,m.PasswordFormat,m.PasswordSalt,m.MobilePIN,m.Email,m.LoweredEmail,m.PasswordQuestion,m.PasswordAnswer,m.IsApproved,m.IsLockedOut,m.CreateDate,m.LastLoginDate,m.LastPasswordChangedDate,m.LastLockoutDate,m.FailedPasswordAttemptCount,m.FailedPasswordAttemptWindowStart,m.FailedPasswordAnswerAttemptCount,m.FailedPasswordAnswerAttemptWindowStart,m.Comment from SiteUsers u join SiteMembers m on m.UserId = u.Id " ); SqlParameter parm = null; if (!string.IsNullOrEmpty(username)) { sb.Append("where Named = @Named"); parm = new SqlParameter("@Named", SqlDbType.NVarChar, 50); parm.Value = username; } else if (Id is Guid) { sb.Append("where Id = @Id"); parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); parm.Value = Guid.Parse(Id.ToString()); } using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), parm)) { if (reader != null) { if (reader.Read()) { model = new SiteUsersInfo(); model.ApplicationId = reader.GetGuid(0); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.LowerName = reader.GetString(4); model.MobileAlias = reader.GetString(5); model.IsAnonymous = reader.GetBoolean(6); model.LastActivityDate = reader.GetDateTime(7); model.LastUpdatedDate = reader.GetDateTime(8); model.Password = reader.GetString(9); model.PasswordFormat = reader.GetInt32(10); model.PasswordSalt = reader.GetString(11); model.MobilePIN = reader.GetString(12); model.Email = reader.GetString(13); model.LoweredEmail = reader.GetString(14); model.PasswordQuestion = reader.GetString(15); model.PasswordAnswer = reader.GetString(16); model.IsApproved = reader.GetBoolean(17); model.IsLockedOut = reader.GetBoolean(18); model.CreateDate = reader.GetDateTime(19); model.LastLoginDate = reader.GetDateTime(20); model.LastPasswordChangedDate = reader.GetDateTime(21); model.LastLockoutDate = reader.GetDateTime(22); model.FailedPasswordAttemptCount = reader.GetInt32(23); model.FailedPasswordAttemptWindowStart = reader.GetDateTime(24); model.FailedPasswordAnswerAttemptCount = reader.GetInt32(25); model.FailedPasswordAnswerAttemptWindowStart = reader.GetDateTime(26); model.Comment = reader.GetString(27); } } } return(model); }
public IList <SiteUsersInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from SiteUsers u join SiteMembers m on m.UserId = u.Id "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <SiteUsersInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by u.LastUpdatedDate desc) as RowNumber, u.ApplicationId,u.Id,u.Coded,u.Named,u.LowerName,u.MobileAlias,u.IsAnonymous,u.LastActivityDate,u.LastUpdatedDate ,m.Password,m.PasswordFormat,m.PasswordSalt,m.MobilePIN,m.Email,m.LoweredEmail,m.PasswordQuestion,m.PasswordAnswer,m.IsApproved,m.IsLockedOut,m.CreateDate,m.LastLoginDate,m.LastPasswordChangedDate,m.LastLockoutDate,m.FailedPasswordAttemptCount,m.FailedPasswordAttemptWindowStart,m.FailedPasswordAnswerAttemptCount,m.FailedPasswordAnswerAttemptWindowStart,m.Comment from SiteUsers u join SiteMembers m on m.UserId = u.Id "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <SiteUsersInfo> list = new List <SiteUsersInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { SiteUsersInfo model = new SiteUsersInfo(); model.ApplicationId = reader.GetGuid(1); model.Id = reader.GetGuid(2); model.Coded = reader.GetString(3); model.Named = reader.GetString(4); model.LowerName = reader.GetString(5); model.MobileAlias = reader.GetString(6); model.IsAnonymous = reader.GetBoolean(7); model.LastActivityDate = reader.GetDateTime(8); model.LastUpdatedDate = reader.GetDateTime(9); model.Password = reader.GetString(10); model.PasswordFormat = reader.GetInt32(11); model.PasswordSalt = reader.GetString(12); model.MobilePIN = reader.GetString(13); model.Email = reader.GetString(14); model.LoweredEmail = reader.GetString(15); model.PasswordQuestion = reader.GetString(16); model.PasswordAnswer = reader.GetString(17); model.IsApproved = reader.GetBoolean(18); model.IsLockedOut = reader.GetBoolean(19); model.CreateDate = reader.GetDateTime(20); model.LastLoginDate = reader.GetDateTime(21); model.LastPasswordChangedDate = reader.GetDateTime(22); model.LastLockoutDate = reader.GetDateTime(23); model.FailedPasswordAttemptCount = reader.GetInt32(24); model.FailedPasswordAttemptWindowStart = reader.GetDateTime(25); model.FailedPasswordAnswerAttemptCount = reader.GetInt32(26); model.FailedPasswordAnswerAttemptWindowStart = reader.GetDateTime(27); model.Comment = reader.GetString(28); list.Add(model); } } } return(list); }
public int Update(SiteUsersInfo model) { throw new NotImplementedException(); }
public int InsertByOutput(SiteUsersInfo model) { throw new NotImplementedException(); }
public int Update(SiteUsersInfo model) { return(dal.Update(model)); }
public int InsertByOutput(SiteUsersInfo model) { return(dal.InsertByOutput(model)); }