private void get_all_users(HttpContext context)
{
try
{
MySqlCommand cmd;
cmd = new MySqlCommand("SELECT users.* FROM users");
DataTable sessiondata = dbm.SelectQuery(cmd).Tables[0];
List <save_userss> geleavetypelist = new List <save_userss>();
foreach (DataRow dr in sessiondata.Rows)
{
save_userss ss = new save_userss();
ss.sno = dr["idusers"].ToString();
ss.email = dr["email"].ToString();
geleavetypelist.Add(ss);
}
string response = GetJson(geleavetypelist);
context.Response.Write(response);
}
catch (Exception ex)
{
string response = GetJson(ex.ToString());
context.Response.Write(response);
}
}
private void get_users(HttpContext context)
{
try
{
MySqlCommand cmd;
string userid = context.Session["user_id"].ToString();
cmd = new MySqlCommand("SELECT users.* FROM users where(idusers=@userid)");
cmd.Parameters.Add("@userid", userid);
DataTable sessiondata = dbm.SelectQuery(cmd).Tables[0];
List <save_userss> geleavetypelist = new List <save_userss>();
foreach (DataRow dr in sessiondata.Rows)
{
save_userss ss = new save_userss();
ss.sno = dr["idusers"].ToString();
ss.first_name = dr["first_name"].ToString();
ss.last_name = dr["last_name"].ToString();
ss.email = dr["email"].ToString();
ss.mobile_num = dr["mobile_num"].ToString();
ss.dob_month = dr["dob_month"].ToString();
ss.dob_day = dr["dob_day"].ToString();
ss.address1 = dr["address1"].ToString();
ss.address2 = dr["address2"].ToString();
ss.city = dr["city"].ToString();
ss.state = dr["state"].ToString();
ss.zipcode = dr["zipcode"].ToString();
geleavetypelist.Add(ss);
}
string response = GetJson(geleavetypelist);
context.Response.Write(response);
}
catch (Exception ex)
{
string response = GetJson(ex.ToString());
context.Response.Write(response);
}
}
