public static DataTable ReadEmployee() { if (connDB.State == ConnectionState.Closed) { connDB = UtilityDB.ConnectDB(); cmd = new SqlCommand(); } cmd.Connection = connDB; cmd.CommandText = "select * from Employees"; SqlDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); reader.Close(); cmd.Dispose(); connDB.Close(); return(dt); }
public static bool SaveRecord(Employee emp) { bool result = true; try { if (connDB.State == ConnectionState.Closed) { connDB = UtilityDB.ConnectDB(); cmd = new SqlCommand(); } cmd.Connection = connDB; cmd.CommandText = string.Format("insert into Employees values( {0},'{1}','{2}','{3}')", emp.EmployeeId, emp.FirstName, emp.LastName, emp.JobTitle); cmd.ExecuteNonQuery(); connDB.Close(); } catch (Exception) { result = false; //throw; } return(result); }