Esempio n. 1
0
        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();
        }
Esempio n. 2
0
        private void editInmateBtn_Click(object sender, EventArgs e)
        {
            bool check = CheckEntries(editIDTxt.Text, editSSNTxt.Text, editFnameTxt.Text, editLnameTxt.Text, editHealthTxt.Text);

            if (check == true)
            {
                InmateQueries.InmateEdit(Convert.ToInt32(editIDTxt.Text), editFnameTxt.Text, editLnameTxt.Text, editBirthdayCalendar.SelectionRange.Start,
                                         editHealthTxt.Text, editArrivalCalendar.SelectionRange.Start, Convert.ToInt32(editYrsLeftNumbers.Value), Convert.ToInt32(editBlockIDDropDwn.SelectedItem.ToString()));
                this.ResetGrid();
            }
            else
            {
                tryAgainLbl.Text = "Please make sure all fields are valid";
            }
        }
Esempio n. 3
0
        private void addInmateBtn_Click(object sender, EventArgs e)
        {
            bool check = CheckEntries(addIDTxt.Text, addSSNTxt.Text, addFnameTxt.Text, addLnameTxt.Text, addHealthTxt.Text);

            if (check == true)
            {
                InmateQueries.InmateAddition(Convert.ToInt32(addIDTxt.Text), addSSNTxt.Text, addFnameTxt.Text, addLnameTxt.Text,
                                             birthdayCalendar.SelectionRange.Start, addHealthTxt.Text, arrivalCalendar.SelectionRange.Start, Convert.ToInt32(yrsLeftDropDwn.Value),
                                             Convert.ToInt32(blockIDDropDown.SelectedItem.ToString()));
                this.ResetGrid();
            }
            else
            {
                tryAgainLbl.Text = "Please make sure all fields are valid";
            }
        }
Esempio n. 4
0
        private void ResetGrid()
        {
            this.inmateGrid.Rows.Clear();
            var inmates = InmateQueries.GetInmates();

            foreach (var x in inmates)
            {
                this.inmateGrid.Rows.Add(
                    x.InmateID,
                    x.ISSN,
                    x.Fname,
                    x.Lname,
                    x.Birthday,
                    x.HealthStatus,
                    x.ArrivalDate,
                    x.YearsLeft,
                    x.BlockID
                    );
            }
        }
Esempio n. 5
0
        public Inmate()
        {
            InitializeComponent();
            this.inmateGrid.Columns.Add("Inmate ID", "Inmate ID");
            this.inmateGrid.Columns.Add("ISSN", "ISSN");
            this.inmateGrid.Columns.Add("Fname", "Fname");
            this.inmateGrid.Columns.Add("Lname", "Lname");
            this.inmateGrid.Columns.Add("Birthday", "ESSN");
            this.inmateGrid.Columns.Add("Health Status", "Health Status");
            this.inmateGrid.Columns.Add("Arrival Date", "Arrival Date");
            this.inmateGrid.Columns.Add("Years Left", "Years Left");
            this.inmateGrid.Columns.Add("Block ID", "Block ID");
            this.ResetGrid();
            List <int> fillingB = InmateQueries.FillBlockIDDropDown();

            foreach (var x in fillingB)
            {
                blockIDDropDown.Items.Add(x);
                editBlockIDDropDwn.Items.Add(x);
            }
        }
Esempio n. 6
0
 private void deleteInmateBtn_Click(object sender, EventArgs e)
 {
     InmateQueries.InmateDeletion(Convert.ToInt32(deleteIDTxt.Text));
     this.ResetGrid();
 }