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