/// <summary> /// It Fetch All the Fellowship Candidates from the Database /// </summary> /// <returns>If Data Fetech Successfully return ResponseData else null or BadRequest</returns> public List <FellowshipResponseModel> GetAllFellowshipCandidates() { try { List <FellowshipResponseModel> fellowshipCandidates = null; using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { fellowshipCandidates = new List <FellowshipResponseModel>(); SqlCommand cmd = new SqlCommand("spGetAllFellowshipCandidates", conn) { CommandType = System.Data.CommandType.StoredProcedure }; conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { FellowshipResponseModel responseData = new FellowshipResponseModel() { CandidateID = Convert.ToInt32(dataReader["CandidateID"]), 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 = Convert.ToDateTime(dataReader["HiredDate"]), 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(), BirthDate = dataReader["BirthDate"].ToString(), IsBirthDateVerified = Convert.ToBoolean(dataReader["IsBirthDateVerified"]), ParentName = dataReader["ParentName"].ToString(), ParentOccupation = dataReader["ParentOccupation"].ToString(), ParentsMobileNumber = dataReader["ParentsMobileNumber"].ToString(), ParentsAnnualSalary = dataReader["ParentsAnnualSalary"].ToString(), LocalAddress = dataReader["LocalAddress"].ToString(), PermanentAddress = dataReader["PermanentAddress"].ToString(), PhotoPath = dataReader["PhotoPath"].ToString(), JoiningDate = dataReader["JoiningDate"].ToString(), CandidateStatus = dataReader["CandidateStatus"].ToString(), PersonalInformation = dataReader["PersonalInformation"].ToString(), BankInformation = dataReader["BankInformation"].ToString(), EducationalInformation = dataReader["EducationalInformation"].ToString(), DocumentStatus = dataReader["DocumentStatus"].ToString(), Remark = dataReader["Remark"].ToString(), CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]), ModifiedDate = Convert.ToDateTime(dataReader["ModifiedDate"]) }; fellowshipCandidates.Add(responseData); } conn.Close(); } return(fellowshipCandidates); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// It Update Fellowship Candidate Details /// </summary> /// <param name="candidateID">Candidate ID</param> /// <param name="fellowshipUpdate">Update Fellowship Candidate</param> /// <returns>If Data Updated Successfully, It return ResponseData else null or Exception</returns> public FellowshipResponseModel UpdateSelectedFellowshipCandidate(int candidateID, FellowshipUpdateRequest fellowshipUpdate) { try { FellowshipResponseModel responseData = null; try { using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { SqlCommand cmd = new SqlCommand("spUpdateFellowshipCandidate", conn) { CommandType = System.Data.CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@CandidateID", candidateID); cmd.Parameters.AddWithValue("@BirthDate", fellowshipUpdate.BirthDate); cmd.Parameters.AddWithValue("@IsBirthDateVerified", fellowshipUpdate.IsBirthDateVerified); cmd.Parameters.AddWithValue("@ParentName", fellowshipUpdate.ParentName); cmd.Parameters.AddWithValue("@ParentOccupation", fellowshipUpdate.ParentOccupation); cmd.Parameters.AddWithValue("@ParentsMobileNumber", fellowshipUpdate.ParentsMobileNumber); cmd.Parameters.AddWithValue("@ParentsAnnualSalary", fellowshipUpdate.ParentsAnnualSalary); cmd.Parameters.AddWithValue("@LocalAddress", fellowshipUpdate.LocalAddress); cmd.Parameters.AddWithValue("@PermanentAddress", fellowshipUpdate.PermanentAddress); cmd.Parameters.AddWithValue("@PhotoPath", fellowshipUpdate.PhotoPath); cmd.Parameters.AddWithValue("@JoiningDate", fellowshipUpdate.JoiningDate); cmd.Parameters.AddWithValue("@CandidateStatus", fellowshipUpdate.CandidateStatus); cmd.Parameters.AddWithValue("@PersonalInformation", fellowshipUpdate.PersonalInformation); cmd.Parameters.AddWithValue("@BankInformation", fellowshipUpdate.BankInformation); cmd.Parameters.AddWithValue("@EducationalInformation", fellowshipUpdate.EducationalInformation); cmd.Parameters.AddWithValue("@DocumentStatus", fellowshipUpdate.DocumentStatus); cmd.Parameters.AddWithValue("@Remark", fellowshipUpdate.Remark); cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now); conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { responseData = new FellowshipResponseModel() { CandidateID = Convert.ToInt32(dataReader["CandidateID"].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 = Convert.ToDateTime(dataReader["HiredDate"]), HiredLab = dataReader["HiredLab"].ToString(), Attitude = dataReader["Attitude"].ToString(), CommunicationRemark = dataReader["CommunicationRemark"].ToString(), KnowledgeRemark = dataReader["KnowledgeRemark"].ToString(), AggregateRemark = dataReader["AggregateRemark"].ToString(), Status = dataReader["Status"].ToString(), BirthDate = dataReader["BirthDate"].ToString(), IsBirthDateVerified = Convert.ToBoolean(dataReader["IsBirthDateVerified"]), ParentName = dataReader["ParentName"].ToString(), ParentOccupation = dataReader["ParentOccupation"].ToString(), ParentsMobileNumber = dataReader["ParentsMobileNumber"].ToString(), ParentsAnnualSalary = dataReader["ParentsAnnualSalary"].ToString(), LocalAddress = dataReader["LocalAddress"].ToString(), PermanentAddress = dataReader["PermanentAddress"].ToString(), PhotoPath = dataReader["PhotoPath"].ToString(), JoiningDate = dataReader["JoiningDate"].ToString(), CandidateStatus = dataReader["CandidateStatus"].ToString(), PersonalInformation = dataReader["PersonalInformation"].ToString(), BankInformation = dataReader["BankInformation"].ToString(), EducationalInformation = dataReader["EducationalInformation"].ToString(), DocumentStatus = dataReader["DocumentStatus"].ToString(), Remark = dataReader["Remark"].ToString(), 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); } }