public List <Applicant_History> SelectHistoryWithId(int id) { List <Applicant_History> ApplicantList = new List <Applicant_History>(); using (SqlConnection connection = new SqlConnection("Data Source=A00101996\\SQLEXPRESS;Initial Catalog=Applicant;Integrated Security=True")) { connection.Open(); string sql = "EXEC SelectApplicantHistoryWithId @Applicant_Id = " + id; SqlCommand command = new SqlCommand(sql, connection); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { Applicant_History app = new Applicant_History(); app.H_Applicant_Id = MyConvertInt(dataReader["H_Applicant_Id"]); app.Applicant_Id = MyConvertInt(dataReader["Applicant_Id"]); app.H_FName = MyConvertString(dataReader["H_FName"]); app.H_LName = MyConvertString(dataReader["H_LName"]); app.H_Username = MyConvertString(dataReader["H_Username"]); app.H_Password = MyConvertString(dataReader["H_Password"]); app.H_Age = MyConvertInt(dataReader["H_Age"]); app.H_Phone = MyConvertString(dataReader["H_Phone"]); app.H_Extra = MyConvertString(dataReader["H_Extra"]); app.H_ModificationDate = Convert.ToDateTime(dataReader["H_ModificationDate"]); ApplicantList.Add(app); } } connection.Close(); } return(ApplicantList); }
public IEnumerable <Applicant_History> GetHistory(int id) { List <Applicant_History> ApplicantList = new List <Applicant_History>(); string connectionString = Configuration["ConnectionStrings:DefaultConnection"]; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); //string sql = $"Select * From Applicant_History Where Applicant_Id = '{id}'"; string sql = $"EXEC SelectApplicantHistoryWithId @Applicant_Id = '{id}'"; SqlCommand command = new SqlCommand(sql, connection); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { Applicant_History app = new Applicant_History(); app.H_Applicant_Id = MyConvertInt(dataReader["H_Applicant_Id"]); app.Applicant_Id = MyConvertInt(dataReader["Applicant_Id"]); app.H_FName = MyConvertString(dataReader["H_FName"]); app.H_LName = MyConvertString(dataReader["H_LName"]); app.H_Username = MyConvertString(dataReader["H_Username"]); app.H_Password = MyConvertString(dataReader["H_Password"]); app.H_Age = MyConvertInt(dataReader["H_Age"]); app.H_Phone = MyConvertString(dataReader["H_Phone"]); app.H_Extra = MyConvertString(dataReader["H_Extra"]); app.H_ModificationDate = Convert.ToDateTime(dataReader["H_ModificationDate"]); ApplicantList.Add(app); } } connection.Close(); } return(ApplicantList); }