public void GetAllEmployee(string query) { try { EmployeePayroll employeePayroll = new EmployeePayroll(); using (connection) { SqlCommand cnd = new SqlCommand(query, connection); connection.Open(); SqlDataReader dr = cnd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { employeePayroll.id = dr.GetInt32(0); employeePayroll.name = dr.GetString(1); employeePayroll.startDate = dr.GetDateTime(2); employeePayroll.gender = Convert.ToChar(dr.GetString(3)); employeePayroll.Address = dr.GetString(4); employeePayroll.phoneNumber = dr.GetString(5); Console.WriteLine(employeePayroll.id + " " + employeePayroll.name + " " + employeePayroll.startDate + " " + employeePayroll.gender + " " + employeePayroll.Address + " " + employeePayroll.phoneNumber); Console.WriteLine(""); } } else { Console.WriteLine("No DAta found"); } dr.Close(); connection.Close(); } } catch (Exception e) { throw new Exception(e.Message); } finally { connection.Close(); } }
public bool addEmpoyee(EmployeePayroll employee) { try { using (connection) { SqlCommand cnd = new SqlCommand("SpAddEmployeeDetails", connection); cnd.CommandType = CommandType.StoredProcedure; cnd.Parameters.AddWithValue("@EmpName", employee.name); cnd.Parameters.AddWithValue("@StartDate", employee.startDate); cnd.Parameters.AddWithValue("@Gender", employee.gender); cnd.Parameters.AddWithValue("@Address", employee.Address); cnd.Parameters.AddWithValue("@phoneNumber", employee.phoneNumber); connection.Open(); var result = cnd.ExecuteNonQuery(); connection.Close(); if (result != 0) { return(true); } else { return(false); } } } catch (Exception e) { throw new Exception(e.Message); } finally { connection.Close(); } }