using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using sdirect_AshishShuklaModel;
public partial class Entity : System.Web.UI.Page
{
    sdirect_AshishShuklaEntities sd = new sdirect_AshishShuklaEntities();
    Emplo emp = new Emplo();




    protected void Page_Load(object sender, EventArgs e)
    {


    }

    //save
    protected void Button1_Click(object sender, EventArgs e)
    {

        emp.EmployeeID = Convert.ToInt32(TextBox1.Text);
        emp.FirstName = TextBox2.Text;
        emp.LastName = TextBox3.Text;
        emp.Salary = Convert.ToDecimal(TextBox4.Text);


        sd.Emploes.AddObject(emp);
        sd.SaveChanges();
        sd.AcceptAllChanges();

        var r = sd.Emploes;
        //GridView1.DataSource = r;
        GridView1.DataBind();


    }
    //update
    protected void Button1_Click1(object sender, EventArgs e)
    {
        int code = Convert.ToInt32(TextBox1.Text);

        Emplo x = sd.Emploes.Where(u => u.EmployeeID == code).SingleOrDefault();
  
        //Emplo x = (from ee in sd.Emploes
        //           where ee.EmployeeID == code
        //           select ee).FirstOrDefault();
        x.FirstName = TextBox2.Text;
        x.LastName = TextBox3.Text;
        x.Salary = Convert.ToDecimal(TextBox4.Text);
        sd.SaveChanges();
        GridView1.DataBind();


       // GridView2.DataSource = x;
        //GridView2.DataBind();
    }
    //search
    protected void Button3_Click(object sender, EventArgs e)
    {
        int code = Convert.ToInt32(TextBox1.Text);
        Emplo x= (from ee in sd.Emploes
                  where ee.EmployeeID == code
                select ee).First();

        TextBox1.Text =Convert.ToString( x.EmployeeID);
        TextBox2.Text = x.FirstName;
        TextBox3.Text = x.LastName;
        TextBox4.Text =Convert.ToString( x.Salary);

    }
    //delete
    protected void Button2_Click(object sender, EventArgs e)
    {
        int code = Convert.ToInt32(TextBox1.Text);
        Emplo x = (from ee in sd.Emploes
                   where ee.EmployeeID == code
                   select ee).First();

        sd.Emploes.DeleteObject(x);
        sd.SaveChanges();
        GridView1.DataBind();
    }
}