public static List<Users> GetAllUsers()
{
ScrumQueue.IOLogic.DBAccess dba = ScrumQueue.IOLogic.DBAccess.CreateConnection();
//"@Username"
System.Data.SqlClient.SqlDataReader reader = dba.execSP("GetAllUsers",
new string[] { },
new string[] { });
List<Users> userlist = new List<Users>(20);
while (reader.Read())
{
int id = int.Parse(reader["UserID"].ToString());
string username = reader["Username"].ToString();
string password = reader["Password"].ToString();
string firstname = reader["FirstName"].ToString();
string lastname = reader["LastName"].ToString();
bool isAdmin = bool.Parse(reader["IsAdmin"].ToString());
//bool isAdmin = false;
//if (isAdminString.Trim().Equals("1"))
// isAdmin = true;
Users u = new Users(id, username, password, firstname, lastname, isAdmin);
userlist.Add(u);
}
return userlist;
}
public static void SaveUsers(Users u)
{
ScrumQueue.IOLogic.DBAccess dba = ScrumQueue.IOLogic.DBAccess.CreateConnection();
if (u.UserID == -1)
{
//"@Username", "@Password", "@FirstName", "@LastName", "@DateCreated"
System.Data.SqlClient.SqlDataReader reader = dba.execSP("InsertUser",
new string[] { "@Username", "@Password", "@FirstName", "@LastName", "@isAdmin" },
new string[] { u.Username, u.Password, u.FirstName, u.LastName, u.IsAdmin.ToString()});
reader.Read();
}
else
{
//"@Username", "@Password", "@FirstName", "@LastName", "@DateCreated"
System.Data.SqlClient.SqlDataReader reader = dba.execSP("UpdateUser",
new string[] { "@Username", "@Password", "@FirstName", "@LastName", "@IsAdmin" },
new string[] { u.Username, u.Password, u.FirstName, u.LastName, u.IsAdmin.ToString() });
reader.Read();
}
}
public void LoadRememberMe()
{
if (!new System.IO.FileInfo(this.SerializationFullPathFile).Exists)
return;
System.IO.FileStream fs = null;
try
{
// Create the stream
fs = new System.IO.FileStream(SerializationFullPathFile, System.IO.FileMode.Open);
// Create the formatter
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter bf =
new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
// Create the temp user
Users u = new Users();
//deserialize
u = (Users)bf.Deserialize(fs);
// Close the stream
fs.Close();
this.UserID = u.UserID;
this.Username = u.Username;
this.Password = u.Password;
this.FirstName = u.FirstName;
this.LastName = u.LastName;
this.IsAdmin = u.IsAdmin;
}
catch (Exception ex)
{
if (fs != null)
fs.Close();
return;
}
}
/// <summary>
/// return -1 if user does not exist
/// return -2 if user does exist and is the same as the user passed in the parameter.
/// return the ID if the user does.
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static int isUsernameAvailable(Users u)
{
ScrumQueue.IOLogic.DBAccess dba = ScrumQueue.IOLogic.DBAccess.CreateConnection();
//"@Username"
System.Data.SqlClient.SqlDataReader reader = dba.execSP("CheckUserNameExist",
new string[] { "@Username" },
new string[] { u.Username });
int ret = -1;
if (reader.Read())
{
ret = int.Parse(reader[0].ToString().Trim());
}
// if the returned user is positive and is the same as the passed in user, return -2
if (ret == u.UserID)
return -2;
// if the returned user is positive then return the actual user
// if the returned user is negative(i.e. not in the database) then return -1
return ret;
}