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