public static AssessmentDM ReadAssessmentByID(string assessmentId) { try { AssessmentDM _assessment = new AssessmentDM(); using (SqlCommand cmd = new SqlCommand("READ_ASSESSMENT_BY_ID", SqlConnect.Connection)) { cmd.CommandType = CommandType.StoredProcedure; SqlConnect.Connection.Open(); cmd.Parameters.AddWithValue("@Assessment_ID", assessmentId); using (var reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { _assessment.AssessmentId = (Int64)reader["Assessment_ID"]; _assessment.TDProblemSolving = (int)reader["TD_Problem_Solving"]; _assessment.TDQualityOfWork = (int)reader["TD_Quality_Of_Work"]; _assessment.TDProductivity = (int)reader["TD_Productivity"]; _assessment.TDProductKnowledge = (int)reader["TD_Product_Knowledge"]; _assessment.TDComments = (string)reader["TD_Comments"]; _assessment.CSRProffesionalismTeamwork = (int)reader["CSR_Proffesionalism_Teamwork"]; _assessment.CSRVerbalSkills = (int)reader["CSR_Verbal_Skills"]; _assessment.CSRWrittenSkills = (int)reader["CSR_Written_Skills"]; _assessment.CSRListeningSkills = (int)reader["CSR_Listening_Skills"]; _assessment.CSRComments = (string)reader["CSR_Comments"]; _assessment.ADAttendence = (int)reader["AD_Attendence"]; _assessment.ADEthicalBehavior = (int)reader["AD_Ethical_Behavior"]; _assessment.ADMeetDeadlines = (int)reader["AD_Meet_Deadlines"]; _assessment.ADOrganizeDetailedWork = (int)reader["AD_Organize_Detailed_Work"]; _assessment.ADComments = (string)reader["AD_Comments"]; _assessment.TMResourceUse = (int)reader["TM_ResourceUse"]; _assessment.TMFeedback = (int)reader["TM_Feedback"]; _assessment.TMTechnicalMonitoring = (int)reader["TM_Technical_Monitoring"]; _assessment.TMAskingQuestions = (int)reader["TM_Asking_Questions"]; _assessment.TMComments = (string)reader["TM_Comments"]; _assessment.MIAttitudeWork = (int)reader["MI_Attitude_Work"]; _assessment.MIGroomingAppearance = (int)reader["MI_Grooming_Appearance"]; _assessment.MIPersonalGrowth = (int)reader["MI_Personal_Growth"]; _assessment.MIPotentialAdvancement = (int)reader["MI_Potential_Advancement"]; _assessment.MIComments = (string)reader["MI_Comments"]; _assessment.EmployeeID = (Int64)reader["Employee_ID"]; _assessment.Created = (DateTime)reader["Created"]; _assessment.CreatedBy = (string)reader["Created_By"]; _assessment.Modified = (DateTime)reader["Modified"]; _assessment.ModifiedBy = (string)reader["Modified_By"]; } } } SqlConnect.Connection.Close(); } return(_assessment); } catch (Exception ex) { SqlConnect.Connection.Close(); throw ex; } }
/// <summary> /// Basic CRUD methods for Assessment information. AssessmentDM is the model being used here. /// </summary> /// #region Assessment DAL Methods public static void CreateAssessment(AssessmentDM _assessment) { try { //Creating a way of adding new user information to my database using (SqlCommand cmd = new SqlCommand("CREATE_ASSESSMENT", SqlConnect.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TD_Problem_Solving", _assessment.TDProblemSolving); cmd.Parameters.AddWithValue("@TD_Quality_of_Work", _assessment.TDQualityOfWork); cmd.Parameters.AddWithValue("@TD_Productivity", _assessment.TDProductivity); cmd.Parameters.AddWithValue("@TD_Product_Knowledge", _assessment.TDProductKnowledge); cmd.Parameters.AddWithValue("@TD_Comments", _assessment.TDComments); cmd.Parameters.AddWithValue("@CSR_Professionalism_Teamwork", _assessment.CSRProffesionalismTeamwork); cmd.Parameters.AddWithValue("@CSR_Verbal_Skills", _assessment.CSRVerbalSkills); cmd.Parameters.AddWithValue("@CSR_Written_Skills", _assessment.CSRWrittenSkills); cmd.Parameters.AddWithValue("@CSR_Listening_Skills", _assessment.CSRListeningSkills); cmd.Parameters.AddWithValue("@CSR_Comments", _assessment.CSRComments); cmd.Parameters.AddWithValue("@AD_Attendence", _assessment.ADAttendence); cmd.Parameters.AddWithValue("@AD_Ethical_Behavior", _assessment.ADEthicalBehavior); cmd.Parameters.AddWithValue("@AD_Meet_Deadlines", _assessment.ADMeetDeadlines); cmd.Parameters.AddWithValue("@AD_Organize_Detailed_Work", _assessment.ADOrganizeDetailedWork); cmd.Parameters.AddWithValue("@AD_Comments", _assessment.ADComments); cmd.Parameters.AddWithValue("@TM_Resource_Use", _assessment.TMResourceUse); cmd.Parameters.AddWithValue("@TM_Feedback", _assessment.TMFeedback); cmd.Parameters.AddWithValue("@TM_TechnicalMonitoring", _assessment.TMTechnicalMonitoring); cmd.Parameters.AddWithValue("@TM_Asking_Questions", _assessment.TMAskingQuestions); cmd.Parameters.AddWithValue("@TM_Comments", _assessment.TMComments); cmd.Parameters.AddWithValue("@MI_Attitude_Work", _assessment.MIAttitudeWork); cmd.Parameters.AddWithValue("@MI_Grooming_Appearance", _assessment.MIGroomingAppearance); cmd.Parameters.AddWithValue("@MI_Personal_Growth", _assessment.MIPersonalGrowth); cmd.Parameters.AddWithValue("@MI_Potential_Advancement", _assessment.MIPotentialAdvancement); cmd.Parameters.AddWithValue("@MI_Comments", _assessment.MIComments); cmd.Parameters.AddWithValue("@Employee_ID", _assessment.EmployeeID); cmd.Parameters.AddWithValue("@Created", _assessment.Created.ToShortDateString()); cmd.Parameters.AddWithValue("@Created_By", _assessment.CreatedBy); cmd.Parameters.AddWithValue("@Modified", _assessment.Modified.ToShortDateString()); cmd.Parameters.AddWithValue("@Modified_By", _assessment.ModifiedBy); SqlConnect.Connection.Open(); cmd.ExecuteNonQuery(); SqlConnect.Connection.Close(); } } catch (Exception e) { throw (e); } finally { SqlConnect.Connection.Close(); } }
public static void DeleteAssessment(AssessmentDM _assessment) { try { using (SqlCommand cmd = new SqlCommand("DELETE_ASSESSMENT", SqlConnect.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Assessment_ID", _assessment.AssessmentId); SqlConnect.Connection.Open(); cmd.ExecuteNonQuery(); SqlConnect.Connection.Close(); } } catch (Exception e) { SqlConnect.Connection.Close(); throw (e); } }
public ActionResult ReadAssessmentByID(AssessmentDM assessment) { return(View(Mapper.Map <AssessmentVM>(AssessmentDAL.ReadAssessmentByID(assessment.AssessmentId.ToString())))); }