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