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