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