protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString.AllKeys.Length > 0) { DataBaseConfig dt = new DataBaseConfig(); if (Request.QueryString["op"] == "getcustomer") { dt.oCommand = new SqlCommand("select * from Customer where Id=" + Request.QueryString["Id"]); dt.oDataReader = dt.ExecuteReader(dt.oCommand); if (dt.oDataReader.Read()) { //{"id_customer":7,"tax_office":"elazığ vergi bürosu","tax_number":1231231} Response.Write(dt.oDataReader["Id"] + ":" + dt.oDataReader["Tax_Office"] + ":" + dt.oDataReader["Tax_Number"]); } } else if (Request.QueryString["op"] == "getproductprice") { dt.oCommand = new SqlCommand("select * from Product where Id=" + Request.QueryString["Id"]); dt.oDataReader = dt.ExecuteReader(dt.oCommand); if (dt.oDataReader.Read()) { //{ "id_product":6,"name":"Product1","price":"120.0000","tax_rate":"0.0500"} Response.Write(dt.oDataReader["Id"] + ":" + dt.oDataReader["Name"] + ":" + dt.oDataReader["Price"] + ":" + dt.oDataReader["Tax_Rate"]); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString.AllKeys.Length > 0) { if (Request.QueryString["Id"] != null) { DataBaseConfig db = new DataBaseConfig(); db.oCommand = new SqlCommand("Select * from Customer Where Id = " + Request.QueryString["Id"]); db.oDataReader = db.ExecuteReader(db.oCommand); if (db.oDataReader.Read()) { Firstname.Text = db.oDataReader["Firstname"].ToString(); Lastname.Text = db.oDataReader["Lastname"].ToString(); Companyname.Text = db.oDataReader["Companyname"].ToString(); Addres.Text = db.oDataReader["Addres"].ToString(); Email.Text = db.oDataReader["Email"].ToString(); Phone.Text = db.oDataReader["Phone"].ToString(); Tax_Number.Text = db.oDataReader["Tax_Number"].ToString(); Tax_Office.Text = db.oDataReader["Tax_Office"].ToString(); } } } } }
protected void btnLogin_Click(object sender, EventArgs e) { DataBaseConfig db = new DataBaseConfig(); db.oCommand = new SqlCommand("Select * From Users Where Email= @Email and Password = @Password"); db.oCommand.Parameters.AddWithValue("@Email", Email.Text); db.oCommand.Parameters.AddWithValue("@Password", Password.Text); db.oDataReader = db.ExecuteReader(db.oCommand); if (db.oDataReader.Read() && Convert.ToInt32(db.oDataReader["Id"]) > 0) { Session["Id"] = db.oDataReader["Id"].ToString(); //Session["Fullname"] = db.oDataReader["Fullname"].ToString(); Response.Redirect("Default.aspx"); } else { lblResult.Text = "Lütfen Bilgilerinizi Konrol Ediniz !!"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString.AllKeys.Length > 0) { if (Request.QueryString["Id"] != null) { DataBaseConfig db = new DataBaseConfig(); db.oCommand = new SqlCommand("Select * from Users Where Id = " + Request.QueryString["Id"]); db.oDataReader = db.ExecuteReader(db.oCommand); if (db.oDataReader.Read() != false) { Email.Text = db.oDataReader["Email"].ToString(); Password.Text = db.oDataReader["Password"].ToString(); Fullname.Text = db.oDataReader["Fullname"].ToString(); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString.AllKeys.Length > 0) { if (Request.QueryString["Id"] != null) { DataBaseConfig db = new DataBaseConfig(); db.oCommand = new SqlCommand("Select * from Product Where Id = " + Request.QueryString["Id"]); db.oDataReader = db.ExecuteReader(db.oCommand); if (db.oDataReader.Read()) { Name.Text = db.oDataReader["Name"].ToString(); Price.Text = db.oDataReader["Price"].ToString(); Tax_Rate.Text = db.oDataReader["Tax_Rate"].ToString(); Decription.Text = db.oDataReader["Decription"].ToString(); Quantity.Text = db.oDataReader["Quantity"].ToString(); } } } } }
// GET api/HelloWorld public IEnumerable <Profile> Get(string id) { return(DataBaseConfig.ExecuteReader(ProfileQuerys.GetProfileByName(id), QueryHelper.ReaderToObject)); }
public IEnumerable <Profile> GetEmployersByProfile(string id) { return(DataBaseConfig.ExecuteReader(ProfileQuerys.GetEmployeersByProfile(id), QueryHelper.ReaderToObject)); }