public List <User> GetAll() { string sql = "SELECT * FROM Categories"; SqlDataReader reader = dataAccess.ReadSqlData(sql); List <User> users = new List <User>(); while (reader.Read()) { User user = new User(); user.Id = (int)reader["Id"]; user.FirstName = reader["First_name"].ToString(); users.Add(user); } return(users); }
public int Register(string fname, string lname, string email, string dob, string phone, string region, string state, string religion, string username, string password) { string sql = "INSERT INTO Users(First_Name,Last_Name,Email,DOB,Phone,Region,State,Religion) VALUES('" + fname + "','" + lname + "','" + email + "','" + dob + "','" + phone + "','" + region + "','" + state + "','" + religion + "')"; int? result = dataAccess.ExecuteSqlQuery(sql); if (result > 0) { dataAccess = new DataAccess(); sql = "SELECT * FROM Users WHERE Email='" + email + "'"; SqlDataReader reader = dataAccess.ReadSqlData(sql); reader.Read(); int id = (int)reader["Id"]; dataAccess = new DataAccess(); sql = "INSERT INTO Login_Credentials(User_Name,Password,User_Id) VALUES('" + username + "','" + password + "'," + id + ")"; result = dataAccess.ExecuteSqlQuery(sql); if (result > 0) { return(1); } else { return(0); } } else { return(0); } }
public List <Chats> getAll(int chatId) { string sql = "SELECT * FROM Categories"; List <Chats> chats = new List <Chats>(); SqlDataReader reader = data.ReadSqlData(sql); while (reader.Read()) { Chats chat = new Chats(); chat.ChatId = (int)reader["Id"]; chat.ChatLine = reader["Chat_Line"].ToString(); chat.User2 = (int)reader["User2"]; chat.User1 = (int)reader["User1"]; chats.Add(chat); } return(chats); }
public int Validation(string username, string password) { string sql = "SELECT * FROM Login_Credentials WHERE User_Name='" + username + "' AND Password='******'"; SqlDataReader reader = dataAccess.ReadSqlData(sql); if (reader.Read()) { string userName = reader["User_Name"].ToString(); string pass = reader["Password"].ToString(); if (userName == username && password == pass) { return(1); } else { return(0); } } else { return(0); } }