public int AddEmployee(Employee empObj) { int returnValue; try { SqlCommand cmdAddEmployee = new SqlCommand(@"usp_AddEmployee", conEmployeeMgmt); cmdAddEmployee.CommandType = CommandType.StoredProcedure; cmdAddEmployee.Parameters.AddWithValue("@EmployeeName", empObj.EmployeeName); cmdAddEmployee.Parameters.AddWithValue("@Department", empObj.Department); cmdAddEmployee.Parameters.AddWithValue("@Skills", empObj.Skills); cmdAddEmployee.Parameters.AddWithValue("@Gender", empObj.Gender); cmdAddEmployee.Parameters.AddWithValue("@Stream", empObj.Stream); SqlParameter prmReturn = new SqlParameter(); prmReturn.Direction = ParameterDirection.ReturnValue; cmdAddEmployee.Parameters.Add(prmReturn); conEmployeeMgmt.Open(); cmdAddEmployee.ExecuteNonQuery(); returnValue = Convert.ToInt32(prmReturn.Value); } catch { returnValue = -99; } finally { conEmployeeMgmt.Close(); } return returnValue; }
protected void btnSave_Click(object sender, EventArgs e) { foreach (ListItem li in chkSkills.Items) { string val; if (li.Selected == true) { val = li.Value; if (string.IsNullOrEmpty(chSkills) == true) { chSkills = chSkills + val; } else { chSkills = chSkills +","+ val; } } } emDAL = new EMDataAccessLayer(); try { Employee empObj = new Employee(); empObj.EmployeeName = txtEmployeeName.Text; empObj.Department = txtDepartment.Text; empObj.Skills = chSkills; empObj.Gender = Convert.ToChar(rbGender.SelectedValue); empObj.Stream = ddlStream.SelectedValue; int retVal = emDAL.AddEmployee(empObj); if (retVal == 1) { lblStatus.Text = "Employee Added Successfully"; //lblStatus.Text = chSkills; lblStatus.Visible = true; } else // lblStatus.Text = "Employee addition failed!"; lblStatus.Text = "error is "+retVal; lblStatus.Visible = true; } catch { lblStatus.Text = "Operation failed!"; lblStatus.Visible = true; } finally { } }
public Employee FetchEmployee(int employeeID) { Employee empObj = new Employee(); try { SqlCommand cmdAddEmployee = new SqlCommand(@"usp_FetchEmployeeDetailsByEmployeeID", conEmployeeMgmt); cmdAddEmployee.CommandType = CommandType.StoredProcedure; cmdAddEmployee.Parameters.AddWithValue("@EmployeeID", employeeID); conEmployeeMgmt.Open(); using (SqlDataReader oReader = cmdAddEmployee.ExecuteReader()) { while (oReader.Read()) { empObj.EmployeeName = oReader["EmployeeName"].ToString(); empObj.Department = oReader["DepartMent"].ToString(); empObj.Skills = oReader["Skills"].ToString(); empObj.Gender = Convert.ToChar(oReader["Gender"].ToString()); empObj.Stream = oReader["Stream"].ToString(); } conEmployeeMgmt.Close(); } } catch { } finally { conEmployeeMgmt.Close(); } return empObj; }