public void addEdu(worker.education eduExp)
{
SqlCommand cmd = new SqlCommand();
try
{
cmd.CommandText = "saveEdu";
cmd.Connection = utility.getConn();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", eduExp.ID);
cmd.Parameters.AddWithValue("@edLevel", eduExp.edLevel);
cmd.Parameters.AddWithValue("@empid", recid);
cmd.Parameters.AddWithValue("@institution", eduExp.institution);
cmd.Parameters.AddWithValue("@frDate", eduExp.frDate);
cmd.Parameters.AddWithValue("@toDate", eduExp.toDate);
cmd.Parameters.AddWithValue("@edMajor", eduExp.edMajor);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception("Error occurred:" + ex.Message);
}
finally
{
cmd.Connection.Close();
}
}
public List <worker.education> eduHistory()
{
List <worker.education> eHistory = new List <worker.education>();
SqlCommand cmd = new SqlCommand();
try
{
cmd.Connection = utility.getConn();
cmd.Connection.Open();
cmd.CommandText = "select * from tblEmpEdu where empid=" + recid + " order by frDate DESC";
SqlDataReader dbread = cmd.ExecuteReader();
while (dbread.Read())
{
worker.education tmp = new worker.education();
tmp.ID = Convert.ToInt32(dbread["ID"]);
tmp.edLevel = Convert.ToString(dbread["edLevel"]);
tmp.institution = Convert.ToString(dbread["institution"]);
tmp.frDate = Convert.ToDateTime(dbread["frDate"]);
tmp.toDate = Convert.ToDateTime(dbread["toDate"]);
tmp.edMajor = Convert.ToString(dbread["edMajor"]);
eHistory.Add(tmp);
}
dbread.Close();
}
finally
{
cmd.Connection.Close();
}
return(eHistory);
}
