public void SaveEduData(EducationItem myItem)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.spInsertEducation";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", myItem._EMP_ID));
cmd.Parameters.Add(new SqlParameter("@EDU_LEVEL", myItem._EDU_LEVEL));
cmd.Parameters.Add(new SqlParameter("@EDU_SCHOOL_NAME", myItem._EDU_SCHOOL_NAME));
cmd.Parameters.Add(new SqlParameter("@EDU_SCHOOL_ADDRESS", myItem._EDU_SCHOOL_ADDRESS));
cmd.Parameters.Add(new SqlParameter("@EDU_DATE_GRADUATED", myItem._EDU_DATE_GRADUATED));
cmd.Parameters.Add(new SqlParameter("@EDU_DEGREE_EARNED", (string.IsNullOrEmpty(myItem._EDU_DEGREE_EARNED) ? DBNull.Value.ToString() : myItem._EDU_DEGREE_EARNED)));
cmd.ExecuteNonQuery();
db.Close();
}
}
public List <EducationItem> RetreiveEmpEducation(string employeeID)
{
var itemList = new List <EducationItem>();
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GetSpecificEducation";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", employeeID));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return(null);
}
while (reader.Read())
{
var item = new EducationItem();
item._EDU_LEVEL = (string)reader["EDU_LEVEL"];
item._EMP_ID = (string)reader["EMP_ID"];
item._EDU_SCHOOL_NAME = (string)reader["EDU_SCHOOL_NAME"];
item._EDU_SCHOOL_ADDRESS = (string)reader["EDU_SCHOOL_ADDRESS"];
item._EDU_DATE_GRADUATED = (string)reader["EDU_DATE_GRADUATED"];
item._EDU_DEGREE_EARNED = (string)reader["EDU_DEGREE_EARNED"];
itemList.Add(item);
}
db.Close();
return(itemList);
}
}