public static List<Users> GetUserList()
{
DataTable table = new DataTable();
table = Connect.FillCommand("SELECT * FROM Urs");
if (table.Rows.Count == 0) return null;
List<Users> Urs = new List<Users>();
for (int i = 0; i < table.Rows.Count; i++)
{
Users user = new Users();
user.ID = (int)table.Rows[i]["ID"];
user.IMIE = table.Rows[i]["IMIE"].ToString();
user.NAZWISKO = table.Rows[i]["NAZWISKO"].ToString();
user.LOGIN = table.Rows[i]["USR"].ToString();
user.PRIV = (int)table.Rows[i]["PRIV"];
Urs.Add(user);
}
return Urs;
}
public static List<Users> GetUsers()
{
DataTable table = new DataTable();
table = Connect.FillCommand("SELECT ID, (IMIE + ' ' + NAZWISKO) AS UNAME, PRIV FROM Urs");
if (table.Rows.Count == 0) return null;
List<Users> Urs = new List<Users>();
for (int i = 0; i < table.Rows.Count; i++)
{
Users user = new Users();
user.ID = (int)table.Rows[i][0];
user.IMIE = table.Rows[i][1].ToString();
user.PRIV = (int)table.Rows[i]["PRIV"];
Urs.Add(user);
}
return Urs;
}
public static Users Login(string user, string password)
{
DataTable table = new DataTable();
table = Connect.FillCommand("SELECT * FROM Urs WHERE USR='******' AND PASS='******'");
if (table == null || table.Rows.Count == 0) return null;
Users User = new Users();
User.ID = int.Parse(table.Rows[0][0].ToString());
User.IMIE = table.Rows[0][3].ToString();
User.NAZWISKO = table.Rows[0][4].ToString();
User.PRIV = (int)table.Rows[0]["PRIV"];
return User;
}
