public static List<UserDetail> getUsers()
{
string strSQL = "select * from USER";
DataTable dt=sql.RunSQL(strSQL);
List<UserDetail> users = new List<UserDetail>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
UserDetail user = new UserDetail();
user.user_id = int.Parse(dr["USER_ID"].ToString());
user.user_name=dr["USER_NAME"].ToString();
users.Add(user);
}
return users;
}
public static UserDetail signIN(string email, string password)
{
UserDetail user = null;
try
{
user = new UserDetail();
string strSQL = "select * from USER where EMAIL='" + email + "' and PASSWORD='******'";
DataTable dt = sql.RunSQL(strSQL);
if (dt.Rows.Count <= 0)
return null;
DataRow tr = dt.Rows[0];
user.user_id = int.Parse(tr["USER_ID"].ToString());
user.user_name = tr["USER_NAME"].ToString();
}
catch (Exception e)
{
return null;
}
return user;
}
public static UserDetail getUser(int user_id)
{
UserDetail user = new UserDetail();
string strSQL = "select * from USER where USER_ID=" + user_id;
DataTable dt = sql.RunSQL(strSQL);
DataRow tr = dt.Rows[0];
user.user_id = int.Parse(tr["USER_ID"].ToString());
user.user_name = tr["USER_NAME"].ToString();
return user;
}