public IActionResult AddCandidate(HiredRegistrationRequest registration) { try { bool success = false; string message; var data = _hiredBusiness.AddHired(registration); if (data != null) { success = true; message = "Candidate(Hired) Data Added Successfully"; return(Ok(new { success, message, data })); } else { message = "Email Already Exists!"; return(NotFound(new { success, message })); } } catch (Exception ex) { return(BadRequest(new { ex.Message })); } }
/// <summary> /// It Stores Data in the Database /// </summary> /// <param name="hiredRegistration">Hired Registration Data</param> /// <returns>If Storing Data Successfull it return ResponseData else null or Exception</returns> public HiredResponseModel AddHired(HiredRegistrationRequest hiredRegistration) { try { HiredResponseModel responseData = null; using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { SqlCommand cmd = new SqlCommand("spAddHired", conn) { CommandType = System.Data.CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@FirstName", hiredRegistration.FirstName); cmd.Parameters.AddWithValue("@MiddleName", hiredRegistration.MiddleName); cmd.Parameters.AddWithValue("@LastName", hiredRegistration.LastName); cmd.Parameters.AddWithValue("@Email", hiredRegistration.Email); cmd.Parameters.AddWithValue("@Degree", hiredRegistration.Degree); cmd.Parameters.AddWithValue("@MobileNumber", hiredRegistration.MobileNumber); cmd.Parameters.AddWithValue("@PermanentPincode", hiredRegistration.PermanentPincode); cmd.Parameters.AddWithValue("@CreatorStamp", hiredRegistration.CreatorStamp); cmd.Parameters.AddWithValue("@CreatorUser", hiredRegistration.CreatorUser); cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now); conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { responseData = new HiredResponseModel() { CandidateID = Convert.ToInt32(dataReader["ID"].ToString()), FirstName = dataReader["FirstName"].ToString(), MiddleName = dataReader["MiddleName"].ToString(), LastName = dataReader["LastName"].ToString(), Email = dataReader["Email"].ToString(), Degree = dataReader["Degree"].ToString(), MobileNumber = dataReader["MobileNumber"].ToString(), PermanentPincode = dataReader["PermanentPincode"].ToString(), HiredCity = dataReader["HiredCity"].ToString(), HiredDate = dataReader["HiredDate"].ToString(), HiredLab = dataReader["HiredLab"].ToString(), Attitude = dataReader["Attitude"].ToString(), CommunicationRemark = dataReader["CommunicationRemark"].ToString(), KnowledgeRemark = dataReader["KnowledgeRemark"].ToString(), AggregateRemark = dataReader["AggregateRemark"].ToString(), Status = dataReader["Status"].ToString(), CreatorStamp = dataReader["CreatorStamp"].ToString(), CreatorUser = dataReader["CreatorUser"].ToString(), CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]), ModifiedDate = Convert.ToDateTime(dataReader["ModifiedDate"]) }; } conn.Close(); } return(responseData); } catch (Exception ex) { throw new Exception(ex.Message); } }
public HiredResponseModel AddHired(HiredRegistrationRequest hiredRegistration) { var responseData = _hiredRepository.AddHired(hiredRegistration); return(responseData); }