private void findInmateBtn_Click(object sender, EventArgs e)
{
InmatesModel foundInmate = InmateQueries.InmateDisplayOne(Convert.ToInt32(editIDTxt.Text));
if (foundInmate != null)
{
editSSNTxt.Text = foundInmate.ISSN;
editFnameTxt.Text = foundInmate.Fname;
editLnameTxt.Text = foundInmate.Lname;
editBirthdayCalendar.SetDate(foundInmate.Birthday);
editHealthTxt.Text = foundInmate.HealthStatus;
editArrivalCalendar.SetDate(foundInmate.ArrivalDate);
editYrsLeftNumbers.Value = foundInmate.YearsLeft; //FIXME: DOUBLE?
editBlockIDDropDwn.SelectedItem = foundInmate.BlockID; //FIXME: DOUBLE?
}
else
{
editSSNTxt.Text = "";
editFnameTxt.Text = "";
editLnameTxt.Text = "";
editBirthdayCalendar.SetDate(DateTime.Now);
editHealthTxt.Text = "";
editArrivalCalendar.SetDate(DateTime.Now);
editYrsLeftNumbers.Value = 0; //FIXME: DOUBLE?
editBlockIDDropDwn.SelectedItem = 0; //FIXME: DOUBLE?
}
this.ResetGrid();
}
public static InmatesModel InmateDisplayOne(int inmateID)
{
InmatesModel singleInmate = null;
using (SqlConnection sqlCon = new SqlConnection(connectionStr))
{
sqlCon.Open();
if (sqlCon.State == System.Data.ConnectionState.Open)
{
SqlCommand cmd = new SqlCommand("SELECT * FROM INMATE WHERE InmateID = @inmateID", sqlCon);
cmd.Parameters.AddWithValue("@inmateID", inmateID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
singleInmate = new InmatesModel
{
InmateID = reader.GetInt32(reader.GetOrdinal("InmateID")),
ISSN = reader.GetString(reader.GetOrdinal("ISSN")).Trim(),
Fname = reader.GetString(reader.GetOrdinal("Fname")).Trim(),
Lname = reader.GetString(reader.GetOrdinal("Lname")).Trim(),
Birthday = reader.GetDateTime(reader.GetOrdinal("Birthday")),
HealthStatus = reader.GetString(reader.GetOrdinal("HealthStatus")).Trim(),
ArrivalDate = reader.GetDateTime(reader.GetOrdinal("ArrivalDate")),
YearsLeft = reader.GetInt32(reader.GetOrdinal("YearsLeft")),
BlockID = reader.GetInt32(reader.GetOrdinal("BlockID"))
};
}
}
}
return(singleInmate);
}
