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