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);
}
