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