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