/// <summary> /// It Fetch All Candidates Data from the Database /// </summary> /// <returns>If Retrieving Data Successfull return Candidates Data else return null or Exception</returns> public List <HiredResponseModel> GetAllCandidates() { try { List <HiredResponseModel> userList = null; using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { userList = new List <HiredResponseModel>(); SqlCommand cmd = new SqlCommand("spGetAllHired", conn) { CommandType = System.Data.CommandType.StoredProcedure }; conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { HiredResponseModel 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"]) }; userList.Add(responseData); } conn.Close(); } return(userList); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// It is used to Add Selected Candidate into the Database /// </summary> /// <param name="acceptedCandidate"></param> /// <returns>If Data Adding Successfull it return ResponseData else null or Exception</returns> public bool AddSelectedFellowshipCandidate(HiredResponseModel acceptedCandidate) { try { int count; using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { SqlCommand cmd = new SqlCommand("spAddFellowshipCandidate", conn) { CommandType = System.Data.CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@FirstName", acceptedCandidate.FirstName); cmd.Parameters.AddWithValue("@MiddleName", acceptedCandidate.MiddleName); cmd.Parameters.AddWithValue("@LastName", acceptedCandidate.LastName); cmd.Parameters.AddWithValue("@Email", acceptedCandidate.Email); cmd.Parameters.AddWithValue("@Degree", acceptedCandidate.Degree); cmd.Parameters.AddWithValue("@MobileNumber", acceptedCandidate.MobileNumber); cmd.Parameters.AddWithValue("@PermanentPincode", acceptedCandidate.PermanentPincode); cmd.Parameters.AddWithValue("@HiredCity", acceptedCandidate.HiredCity); cmd.Parameters.AddWithValue("@HiredDate", acceptedCandidate.HiredDate); cmd.Parameters.AddWithValue("@HiredLab", acceptedCandidate.HiredLab); cmd.Parameters.AddWithValue("@Attitude", acceptedCandidate.Attitude); cmd.Parameters.AddWithValue("@CommunicationRemark", acceptedCandidate.CommunicationRemark); cmd.Parameters.AddWithValue("@KnowledgeRemark", acceptedCandidate.KnowledgeRemark); cmd.Parameters.AddWithValue("@AggregateRemark", acceptedCandidate.AggregateRemark); cmd.Parameters.AddWithValue("@Status", acceptedCandidate.Status); cmd.Parameters.AddWithValue("@CreatorStamp", acceptedCandidate.CreatorStamp); cmd.Parameters.AddWithValue("@CreatorUser", acceptedCandidate.CreatorUser); cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now); conn.Open(); count = cmd.ExecuteNonQuery(); conn.Close(); } if (count > 0) { return(true); } return(false); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// It Updates Data in the Database /// </summary> /// <param name="candidateID">CandidateID</param> /// <param name="hiredRegistrationUpdate">Hired Update Data</param> /// <returns>If Updating Data Successfull return ResponseData else return null or Exception</returns> public HiredResponseModel UpdateHired(int candidateID, HiredUpdateRequest hiredRegistrationUpdate) { try { HiredResponseModel responseData = null; using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { SqlCommand cmd = new SqlCommand("spUpdateHired", conn) { CommandType = System.Data.CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@ID", candidateID); cmd.Parameters.AddWithValue("@HiredCity", hiredRegistrationUpdate.HiredCity); cmd.Parameters.AddWithValue("@HiredDate", DateTime.Now); cmd.Parameters.AddWithValue("@HiredLab", hiredRegistrationUpdate.HiredLab); cmd.Parameters.AddWithValue("@Attitude", hiredRegistrationUpdate.Attitude); cmd.Parameters.AddWithValue("@CommunicationRemark", hiredRegistrationUpdate.CommunicationRemark); cmd.Parameters.AddWithValue("@KnowledgeRemark", hiredRegistrationUpdate.KnowledgeRemark); cmd.Parameters.AddWithValue("@AggregateRemark", hiredRegistrationUpdate.AggregateRemark); cmd.Parameters.AddWithValue("@Status", hiredRegistrationUpdate.Status); cmd.Parameters.AddWithValue("@CreatorStamp", hiredRegistrationUpdate.CreatorStamp); cmd.Parameters.AddWithValue("@CreatorUser", hiredRegistrationUpdate.CreatorUser); 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(); } if (responseData.Status.ToLower() == "accepted") { var isAddedToFellowship = AddSelectedFellowshipCandidate(responseData); if (isAddedToFellowship) { return(responseData); } return(null); } return(responseData); } catch (Exception ex) { throw new Exception(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); } }