public IActionResult AddQualification(int candidateID, CandidateQualificationRequest qualification) { try { bool success = false; string message; var data = _fellowshipBusiness.AddCandidateQualification(candidateID, qualification); if (data != null) { success = true; message = "Fellowship Candidate Qualification Details Added Successfully"; return(Ok(new { success, message, data })); } else { message = "Try Again!"; return(NotFound(new { success, message })); } } catch (Exception ex) { return(BadRequest(new { ex.Message })); } }
public CandidateQualificationResponse AddCandidateQualification(int candidateID, CandidateQualificationRequest qualification) { var responseData = _hiredRepository.AddCandidateQualification(candidateID, qualification); return(responseData); }
/// <summary> /// It Stores Candidate Qualification Details in the Database /// </summary> /// <param name="candidateID">CandidateID</param> /// <param name="qualification">Candidate Qualification Data</param> /// <returns>If Data Added Successfully return ResponseData else null or Exception</returns> public CandidateQualificationResponse AddCandidateQualification(int candidateID, CandidateQualificationRequest qualification) { try { CandidateQualificationResponse responseData = null; try { using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { SqlCommand cmd = new SqlCommand("spAddCandidateQualification", conn) { CommandType = System.Data.CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@CandidateID", candidateID); cmd.Parameters.AddWithValue("@Diploma", qualification.Diploma); cmd.Parameters.AddWithValue("@DegreeName", qualification.DegreeName); cmd.Parameters.AddWithValue("@IsDegreeNameVerified", qualification.IsDegreeNameVerified); cmd.Parameters.AddWithValue("@EmployeeDiscipline", qualification.EmployeeDiscipline); cmd.Parameters.AddWithValue("@IsEmployeeDisciplined", qualification.IsEmployeeDisciplined); cmd.Parameters.AddWithValue("@PassingYear", qualification.PassingYear); cmd.Parameters.AddWithValue("@IsPassingYearVerified", qualification.IsPassingYearVerified); cmd.Parameters.AddWithValue("@AggregatePer", qualification.AggregatePer); cmd.Parameters.AddWithValue("@IsAggregatePerVerified", qualification.IsAggregatePerVerified); cmd.Parameters.AddWithValue("@FinalYearPer", qualification.FinalYearPer); cmd.Parameters.AddWithValue("@IsFinalYearPerVerified", qualification.IsFinalYearPerVerified); cmd.Parameters.AddWithValue("@TrainingInstitute", qualification.TrainingInstitute); cmd.Parameters.AddWithValue("@IsTrainingInstituteVerified", qualification.IsTrainingInstituteVerified); cmd.Parameters.AddWithValue("@TrainingDurationMon", qualification.TrainingDurationMon); cmd.Parameters.AddWithValue("@IsTrainingDurationMonVerified", qualification.IsTrainingDurationMonVerified); cmd.Parameters.AddWithValue("@OtherTraining", qualification.OtherTraining); cmd.Parameters.AddWithValue("@IsOtherTrainingVerified", qualification.IsOtherTrainingVerified); cmd.Parameters.AddWithValue("@CreatorStamp", qualification.CreatorStamp); cmd.Parameters.AddWithValue("@CreatorUser", qualification.CreatorUser); cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now); conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { responseData = new CandidateQualificationResponse { ID = Convert.ToInt32(dataReader["ID"].ToString()), CandidateID = Convert.ToInt32(dataReader["CandidateID"].ToString()), Diploma = dataReader["Diploma"].ToString(), DegreeName = dataReader["DegreeName"].ToString(), IsDegreeNameVerified = Convert.ToBoolean(dataReader["IsDegreeNameVerified"]), EmployeeDiscipline = dataReader["EmployeeDiscipline"].ToString(), IsEmployeeDisciplined = Convert.ToBoolean(dataReader["IsEmployeeDisciplined"]), PassingYear = dataReader["PassingYear"].ToString(), IsPassingYearVerified = Convert.ToBoolean(dataReader["IsPassingYearVerified"]), AggregatePer = dataReader["AggregatePer"].ToString(), IsAggregatePerVerified = Convert.ToBoolean(dataReader["IsAggregatePerVerified"]), FinalYearPer = dataReader["FinalYearPer"].ToString(), IsFinalYearPerVerified = Convert.ToBoolean(dataReader["IsFinalYearPerVerified"]), TrainingInstitute = dataReader["TrainingInstitute"].ToString(), IsTrainingInstituteVerified = Convert.ToBoolean(dataReader["IsTrainingInstituteVerified"]), TrainingDurationMon = dataReader["TrainingDurationMon"].ToString(), IsTrainingDurationMonVerified = Convert.ToBoolean(dataReader["IsTrainingDurationMonVerified"]), CreatorStamp = dataReader["CreatorStamp"].ToString(), CreatorUser = dataReader["CreatorUser"].ToString(), CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]), ModifiedDate = Convert.ToDateTime(dataReader["ModifiedDate"]) }; } conn.Close(); } return(responseData); } catch { return(null); } } catch (Exception ex) { throw new Exception(ex.Message); } }