void SendResultInfoAsJson(TechLoginResponse res) { string strJson = JsonConvert.SerializeObject(res); Response.ContentType = "application/json; charset=utf-8"; Response.Write(strJson); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { TechLoginResponse res = new TechLoginResponse(); TechLoginRequest req; res.error = String.Empty; // Need passed in store id and number of requested results. // 1. Deserialize the incoming Json. try { req = GetRequestInfo(); } catch (Exception ex) { res.error = ex.Message.ToString(); // Return the results as Json. SendResultInfoAsJson(res); return; } SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); try { connection.Open(); // seaches for a specific username and password string sql = String.Format("select * from TechInfo where Username='******' and Password='******'", req.username, req.password); SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(); List <TechInfo> list = new List <TechInfo>(); // while (reader.Read()) { TechInfo ti = new TechInfo(); ti.username = Convert.ToString(reader["Username"]); ti.password = Convert.ToString(reader["Password"]); list.Add(ti); } reader.Close(); // make sure there's exactly one instance of the username and password given if (list.ToArray().Length == 1) { res.login = true; } else { res.login = false; } } catch (Exception ex) { res.error = ex.Message.ToString(); } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } // Return the results as Json. SendResultInfoAsJson(res); }