using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //DateTime d1 = DateTime.Now;
        //DateTime d2 =DateTime.Parse("03/05/2015");

        //TimeSpan t = d1 - d2;
        //double NrOfDays = t.TotalDays;
        //Response.Write(NrOfDays.ToString());

    }
    protected void BLogin_Click(object sender, EventArgs e)
    {
        //OleDbConnection Con1 = new OleDbConnection();
        //Con1.ConnectionString = @"provider=Microsoft.Jet.OleDB.4.0; Data source="
        //    + Server.MapPath("") + "\\MyUsers.mdb";
        //Con1.Open();
        //string sqlstring = "select * from MyUserList where Myuser='" + Tusername.Text + "' ";
        //OleDbCommand Cmd = new OleDbCommand(sqlstring, Con1);
        //OleDbDataReader Dr = Cmd.ExecuteReader();
        //Dr.Read();

        //if (!Dr.HasRows)
        //{
        //    Con1.Close();
        //  //  Response.Redirect("RegisterForm.aspx");
        //    Response.Write("Not Found");
        //}

        //else
        //{
        //    Session["user"] = Dr["Myuser"];
        //        Con1.Close();

        //    Response.Redirect("Welcome.aspx");
        //  //      Response.Write("Found!");

        //}
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      // Response.Write(Server.MapPath("").ToString());
        OleDbConnection Con1 = new OleDbConnection();
        Con1.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + Server.MapPath("") + "\\‏‏MyUsers2016.accdb";
        Con1.Open();
        string sqlstring = "select * from MyUserList2007 where MyUser='" + GetName.Text + "' and MyPassword='"+GetPassword.Text+"'";
        OleDbCommand Cmd = new OleDbCommand(sqlstring, Con1);
        OleDbDataReader Dr = Cmd.ExecuteReader();
        Dr.Read();

        if (!Dr.HasRows)
        {

            Con1.Close();
            //  Response.Redirect("RegisterForm.aspx");
            Response.Write("Not Found");
        }

        else
        {
            Response.Write(Dr["MyUser"].ToString());
		int salary=0;
		salary=int.Parse(Dr["salary"].ToString());
            Con1.Close();
            //   Response.Redirect("Welcome.aspx");
            Response.Write("Found!");

        }
    }
    protected void InsertButton_Click(object sender, EventArgs e)
    {
        OleDbConnection Con1 = new OleDbConnection();
        Con1.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + Server.MapPath("") + "\\‏‏MyUsers2016.accdb";
        Con1.Open();
        string sqlstring = "INSERT INTO MyUserList2007(MyUser, MYPassword) VaLueS ('"+InsertText.Text+"','1234')";
        string sqlstring = "Update MyUserList set Myusername='ABC', myPassword=' "+Pass.Text.ToString()+" '  where myID='12345678900'";
	   OleDbCommand cmd = new OleDbCommand (sqlstring,Con1);
	   int y = 0;
 	  y=cmd.ExecuteNonQuery();
	   Response.Write(y);


    }
}