public List <Employee> GetEmployeeList() { List <Employee> listEmployee = null; using (DataTable dt = DataAccessSQL.ExecuteSelectCommand("GetEmployeeList", CommandType.StoredProcedure)) { if (dt.Rows.Count != 0) { listEmployee = new List <Employee>(); foreach (DataRow drow in dt.Rows) { Employee employee = new Employee(); employee.EmployeeID = Convert.ToInt32(drow["EmployeeID"]); employee.FirstName = drow["FirstName"].ToString(); employee.LastName = drow["LastName"].ToString(); employee.Title = drow["Title"].ToString(); employee.Address = drow["Address"].ToString(); employee.City = drow["City"].ToString(); employee.Region = drow["Region"].ToString(); employee.PostalCode = drow["PostalCode"].ToString(); employee.Country = drow["Country"].ToString(); employee.Extension = drow["Extension"].ToString(); listEmployee.Add(employee); } } } return(listEmployee); }
public Employee GetEmployeeDetails(int empID) { Employee employee = null; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@empId", empID) }; using (DataTable dt = DataAccessSQL.ExecuteParamSelectCommand("GetEmployeeDetails", CommandType.StoredProcedure, parameter)) { if (dt.Rows.Count > 0) { DataRow drow = dt.Rows[0]; employee = new Employee(); employee.EmployeeID = Convert.ToInt32(drow["EmployeeID"]); employee.FirstName = drow["FirstName"].ToString(); employee.LastName = drow["LastName"].ToString(); employee.Title = drow["Title"].ToString(); employee.Address = drow["Address"].ToString();; employee.City = drow["City"].ToString(); employee.Region = drow["Region"].ToString(); employee.PostalCode = drow["PostalCode"].ToString(); employee.Country = drow["Country"].ToString(); employee.Extension = drow["Extension"].ToString(); } } return(employee); }
public bool DeleteEmployee(int empID) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@empId", empID) }; return(DataAccessSQL.ExecuteNonQuery("DeleteEmployee", CommandType.StoredProcedure, parameter)); }
public bool AddNewEmployee(Employee employee) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@LastName", employee.LastName), new SqlParameter("@FirstName", employee.FirstName), new SqlParameter("Title", employee.Title), new SqlParameter("@Address", employee.Address), new SqlParameter("@City", employee.City), new SqlParameter("@Region", employee.Region), new SqlParameter("@PostalCode", employee.PostalCode), new SqlParameter("@Country", employee.Country), new SqlParameter("@Extension", employee.Extension) }; return(DataAccessSQL.ExecuteNonQuery("AddNewEmployee", CommandType.StoredProcedure, parameters)); }