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