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