Friday, 16 May 2014

LINQ INSERT UPDATE DELETE IN GRIDVIEW


public class Empp
{
    public int ID{get;set;}
    public string UserName{get;set;}
    public string Pass { get; set; }
    public string Gender { get; set; }
    public string Email { get; set; }
}

public List<Empp> Filldata()
    {
        DataClassesDataContext obj = new DataClassesDataContext();

        var s = from a in obj.Employees
                select new Empp
                { 
                      UserName=a.UserName,
                       Gender=a.Gender,
                        Pass=a.Pass,
                         ID=a.ID,
                         Email=a.Email
                                             
                };
        return s.ToList();
  
    }
public void k()
    {
        GridView1.DataSource = Filldata();
        GridView1.DataBind(); 
    }

protected void Btn_Save_Click(object sender, EventArgs e)
    {
        DataClassesDataContext obj = new DataClassesDataContext();
        if (Btn_Save.Text == "Save")
        {
            Employee tblem = new Employee();
            int Id = 0;
            if (tblem.ID == 0)
            {
                tblem.UserName = txt_User.Text;
                tblem.Pass = txt_Pwd.Text;
                tblem.Email = txt_Email.Text;
                tblem.Gender = DDL_Gender.SelectedItem.Text;
                obj.Employees.InsertOnSubmit(tblem);
                obj.SubmitChanges();
                k();
            }
        }
        else
        {

            DataClassesDataContext obj1 = new DataClassesDataContext();
            int Empid=Convert.ToInt32(Session["ID"]);
            Employee tblemp = new Employee();
            tblemp= obj1.Employees.Where(s => s.ID == Empid).FirstOrDefault();

             if (tblemp != null)
            {
                tblemp.UserName = txt_User.Text;
                tblemp.Pass = txt_Pwd.Text;
                tblemp.Email = txt_Email.Text;
                tblemp.Gender = DDL_Gender.SelectedItem.Text;
                obj1.SubmitChanges();
                k();

            }

        }
      
    }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Edit")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            Session["ID"] = GridView1.DataKeys[index].Value.ToString();
            txt_User.Text = GridView1.Rows[index].Cells[0].Text.Trim();
            txt_Pwd.Text = GridView1.Rows[index].Cells[1].Text.Trim();
            txt_Email.Text = GridView1.Rows[index].Cells[2].Text.Trim();
            DDL_Gender.SelectedItem.Text = GridView1.Rows[index].Cells[3].Text.Trim();
            Btn_Save.Text = "Update";
        }
        else if (e.CommandName == "Delete")
        {
            DataClassesDataContext obj = new DataClassesDataContext();
            int index = Convert.ToInt32(e.CommandArgument);
            Session["ID"] = GridView1.DataKeys[index].Value.ToString();
            int id = Convert.ToInt32(Session["ID"].ToString());
            Employee th = new Employee();

            var ss=(from a in obj.Employees.Where(s=>s.ID== id) select a).FirstOrDefault();

            obj.Employees.DeleteOnSubmit(ss);

            obj.SubmitChanges();

            k();

           
        }

    }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

    }





No comments:

Post a Comment