public userModel login(string email, string password)
{
userModel user = new userModel();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string sql = "select * from tbluser where email='" + email + "' and password='******'";
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, con);
ds.Reset();
da.Fill(ds);
dt = ds.Tables[0];
foreach (DataRow row in dt.Rows)
{
user.userid = Convert.ToInt32(row["userid"].ToString());
user.email = row["email"].ToString();
user.mobile = row["mobile"].ToString();
user.password = row["password"].ToString();
}
return(user);
}
public List <userModel> getusers(int id)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
List <userModel> userlist = new List <userModel>();
string sql = "select * from tbluser where userid<>" + id;
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, con);
ds.Reset();
da.Fill(ds);
dt = ds.Tables[0];
foreach (DataRow row in dt.Rows)
{
userModel user = new userModel();
user.userid = Convert.ToInt32(row["userid"].ToString());
user.email = row["email"].ToString();
user.mobile = row["mobile"].ToString();
user.password = row["password"].ToString();
user.dob = row["dob"].ToString();
userlist.Add(user);
}
return(userlist);
}