public List <classUser> GetUsersForList(string UserName, string EmailAddress) { DbManager db = new DbManager(); try { DataTable dt = new DataTable(); DataRow[] dr; List <classUser> li = new List <classUser>(); dt = db.ExecuteDataTable("Sp_UserList"); string whereC = ""; if (UserName != null && UserName != "") { whereC = "UserName like '%" + UserName.ToString() + "%'"; } if (EmailAddress != null && EmailAddress != "") { if (whereC == "") { whereC = "EmailAddress like '%" + EmailAddress.ToString() + "%'"; } else { whereC = whereC + " and EmailAddress like '%" + EmailAddress.ToString() + "%'"; } } dr = dt.Select(whereC); foreach (var item in dr) { classUser lobj = new classUser(); lobj.UserID = (int)item["UserID"]; lobj.Username = item["Username"].ToString(); lobj.EmailAddress = item["EmailAddress"].ToString(); lobj.Password = item["Password"].ToString(); li.Add(lobj); } return(li.ToList()); } catch (Exception ex) { ErrorLog.LogError(ex.Message, ex.StackTrace, ex.Source, "Users GetUsersForList", ""); return(null); } }
public classUser LoadEditData(string UserID) { classUser lobj = new classUser(); DataTable dt = new DataTable(); try { DbManager dbm = new DbManager(); dt = dbm.ExecuteDataTable("Sp_UserList"); DataRow[] dr = dt.Select("UserId=" + UserID + ""); lobj.UserID = (int)dr[0]["UserID"]; lobj.Username = dr[0]["Username"].ToString(); lobj.EmailAddress = dr[0]["EmailAddress"].ToString(); lobj.Password = dr[0]["Password"].ToString(); return(lobj); } catch (Exception ex) { ErrorLog.LogError(ex.Message, ex.StackTrace, ex.Source, "Users SaveNewUser", ""); return(null); } }
public string SaveNewUser(classUser objUsr, bool isInsert) { try { DbManager objDBManager = new DbManager(); DataTable dt = new DataTable(); objDBManager.AddParameter("@Username", objUsr.Username); objDBManager.AddParameter("@Deleted", objUsr.Deleted); objDBManager.AddParameter("@EmailAddress", objUsr.EmailAddress); objDBManager.AddParameter("@RoleID", 0); if (isInsert == true) { objDBManager.AddParameter("@Password", objUsr.Password); objDBManager.ExecuteDataTable("Sp_UserInfoInsert"); } else { if (objUsr.NewPassword == null) { objDBManager.AddParameter("@Password", objUsr.Password); } else { objDBManager.AddParameter("@Password", objUsr.NewPassword); } objDBManager.AddParameter("@UserID", objUsr.UserID); objDBManager.ExecuteDataTable("Sp_UserInfoUpdate"); } return("Saved"); } catch (Exception ex) { ErrorLog.LogError(ex.Message, ex.StackTrace, ex.Source, "Users SaveNewUser", ""); return(ex.Message.ToString()); } }