/// <summary> /// Retreive Clearance Levels from Database based on Department /// </summary> /// <param name="departmentId">Department ID</param> /// <param name="retrieveAll">Signal to Retrieve all irresepective of Department ID</param> /// <returns>Returns a List of Clearance Levels</returns> public static List <ClearanceLevel> RetrieveClearanceByDeptID(string departmentId, bool retrieveAll) { var clearanceLevelInDB = new List <ClearanceLevel>(); //Getting connection var conn = DBConnection.GetConnection(); //Using stored procedure var cmdText = @"sp_retrieve_clearance_levels_by_deptId"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DepartmentId", SqlDbType.VarChar); string departmentIdParameter = retrieveAll ? "dbsall" : departmentId; cmd.Parameters["@DepartmentId"].Value = departmentIdParameter; try { // you have to open a connection before using it conn.Open(); // create a data reader with our command var reader = cmd.ExecuteReader(); // check to make sure the reader has data if (reader.HasRows) { // process the data reader while (reader.Read()) { // create an clearancelevel object var cll = new ClearanceLevel() { ClearanceLevelId = reader.GetInt32(0), Name = reader.GetString(1), Description = reader.GetString(2), DepartmentId = reader.GetString(3), }; // Save Employees into List clearanceLevelInDB.Add(cll); } // close the reader reader.Close(); } } catch (Exception ex) { throw new ApplicationException("There was a problem retrieving clearance level data.", ex); } finally { // final housekeeping conn.Close(); } return(clearanceLevelInDB); }
/// <summary> /// Update Clearance levels /// </summary> /// <param name="clearanceLevel"></param> /// <returns></returns> public bool UpdateClearanceLevel(ClearanceLevel clearanceLevel) { bool result = false; result = EmployeeAccessor.UpdateClearanceLevel(clearanceLevel); return(result); }
/// <summary> /// Updates Clearance Level By Clearancelevel ID /// </summary> /// <param name="clearanceLevelID">Clearance Level ID</param> /// <returns></returns> public static bool UpdateClearanceLevel(ClearanceLevel clearanceLevel) //potentially dangerous method { return(false); }
// Clearance Level CRUD /// <summary> /// Creates new clearance level /// </summary> /// <param name="clearanceLevel">Clerance Level DTO</param> /// <returns></returns> public static bool CreateClearanceLevel(ClearanceLevel clearanceLevel) { return(false); }