/// <summary> /// This method is to update or delete data in grid. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdEmployees_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditEmployee") { lblErrorMessage.Text = ""; int index = Convert.ToInt32(e.CommandArgument.ToString()); int empID = Convert.ToInt32(grdEmployees.DataKeys[index]["EmpID"]); MySampleDataContext msdc = new MySampleDataContext(); Employee employee = (from row in msdc.Employees where row.EmpId == empID select row).FirstOrDefault <Employee>(); txtEmployeeName.Text = employee.EmpName; txtEmployeeId.Text = employee.EmpId.ToString(); txtDesignation.Text = employee.Designation; btnSubmit.Text = "Edit Employee"; } else if (e.CommandName == "DeleteEmployee") { int index = Convert.ToInt32(e.CommandArgument.ToString()); int empID = Convert.ToInt32(grdEmployees.DataKeys[index]["EmpID"]); MySampleDataContext msdc = new MySampleDataContext(); Employee employee = (from row in msdc.Employees where row.EmpId == empID select row).FirstOrDefault <Employee>(); msdc.Employees.DeleteOnSubmit(employee); msdc.SubmitChanges(); lblErrorMessage.Text = "Employee Deleted Succesfully"; loadEmployeees(); } }
/// <summary> /// This method is to load employee in grid. /// </summary> private void loadEmployeees() { MySampleDataContext msdc = new MySampleDataContext(); List <Employee> employees = (from row in msdc.Employees select row).ToList <Employee>(); grdEmployees.DataSource = employees; grdEmployees.DataBind(); }
/// <summary> /// This event is to add or update the employee /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { try { if (btnSubmit.Text == "Add Employee") { MySampleDataContext mySampleDataContext = new MySampleDataContext(); Employee emp = new Employee(); emp.EmpName = txtEmployeeName.Text; emp.Designation = txtDesignation.Text; mySampleDataContext.Employees.InsertOnSubmit(emp); mySampleDataContext.SubmitChanges(); lblErrorMessage.Text = "Employee Added Succesfully"; lblErrorMessage.ForeColor = System.Drawing.Color.Green; txtEmployeeName.Text = ""; txtDesignation.Text = ""; loadEmployeees(); } else if (btnSubmit.Text == "Edit Employee") { MySampleDataContext msdc = new MySampleDataContext(); int empID = Convert.ToInt32(txtEmployeeId.Text); Employee emp = (from row in msdc.Employees where row.EmpId == empID select row).FirstOrDefault <Employee>(); emp.EmpName = txtEmployeeName.Text; emp.Designation = txtDesignation.Text; msdc.SubmitChanges(); lblErrorMessage.Text = "Employee Updated Succesfully"; lblErrorMessage.ForeColor = System.Drawing.Color.Green; txtEmployeeName.Text = ""; txtEmployeeId.Text = ""; txtDesignation.Text = ""; btnSubmit.Text = "Add Employee"; loadEmployeees(); } } catch (Exception ex) { lblErrorMessage.Text = ex.Message; lblErrorMessage.ForeColor = System.Drawing.Color.Red; } }