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