public List <SmartDetainee> Detainees(string term)
{
const string storedProcedureName = Constants.DetaineeSearch;
using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString))
{
SqlCommand command = new SqlCommand(storedProcedureName, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(Constants.term, SqlDbType.VarChar);
command.Parameters[Constants.term].Value = term;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
SmartDetainee detainee = null;
List <SmartDetainee> detainees_list = new List <SmartDetainee>();
while (reader.Read())
{
detainee = new SmartDetainee
{
DetaineeID = Convert.ToInt32(reader.GetValue(0)),
Fullname = reader.GetValue(1).ToString()
};
detainees_list.Add(detainee);
}
connection.Close();
return(detainees_list);
}
}
public List <SmartDetainee> GetDetaineesByDetentionID(int id)
{
const string storedProcedureName = Constants.GetDetaineesByDetentionID;
using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString))
{
SqlCommand command = new SqlCommand(storedProcedureName, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(Constants.DetentionID, SqlDbType.Int);
command.Parameters[Constants.DetentionID].Value = id;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
SmartDetainee detainee = null;
List <SmartDetainee> detainees_list = new List <SmartDetainee>();
while (reader.Read())
{
detainee = new SmartDetainee();
detainee.DetaineeID = Convert.ToInt32(reader.GetValue(0));
detainee.Fullname = reader.GetValue(1).ToString();
detainee.BirthDate = Convert.ToDateTime(reader.GetValue(2));
detainee.MaritalStatus = reader.GetValue(3).ToString();
detainee.Job = reader.GetValue(4).ToString();
detainee.MobilePhoneNumber = reader.GetValue(5).ToString();
detainee.HomePhoneNumber = reader.GetValue(6).ToString();
detainee.ResidencePlace = reader.GetValue(7).ToString();
detainees_list.Add(detainee);
}
connection.Close();
return(detainees_list);
}
}
