public bool NewQualification(Qualification _qualification)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@QualificationName", _qualification.QualificationName)
};
return DataAccess.ExecuteNonQuery("sp_InsertQualification", CommandType.StoredProcedure,
Params);
}
public Qualification GetQualification(int _qualificationCode)
{
Qualification _qualification = null;
SqlParameter[] Params = { new SqlParameter("@QualificationCode", _qualificationCode) };
using (DataTable table = DataAccess.ExecuteParamatizedSelectCommand("sp_GetQualification",
CommandType.StoredProcedure, Params))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
_qualification = new Qualification();
_qualification.QualificationName = row["QualificationName"].ToString();
_qualification.QualificationCode = Convert.ToInt32(row["QualificationCode"]);
}
}
return _qualification;
}
public List<Qualification> GetAllQualifications()
{
List<Qualification> _qualificationList = null;
using (DataTable table = DataAccess.ExecuteSelectCommand("sp_GetAllQualifications",
CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
_qualificationList = new List<Qualification>();
foreach (DataRow row in table.Rows)
{
Qualification _qualification = new Qualification();
_qualification.QualificationName = row["QualificationName"].ToString();
_qualification.QualificationCode = Convert.ToInt32(row["QualificationCode"]);
_qualificationList.Add(_qualification);
}
}
}
return _qualificationList;
}
public bool InsertQualification(Qualification _qualification)
{
QualificationHandler myHandler = new QualificationHandler(); return myHandler.NewQualification(_qualification);
}
