private void rentalButton_Click(object sender, EventArgs e) { List <string> values = new List <string>(); foreach (DataGridViewRow row in itemGridView.Rows) { values.Add(row.Cells["Number"].Value.ToString()); } string[] insert = values.ToArray(); string[] finalInsert = insert.Take(insert.Length - 1).ToArray(); List <int> equipID = new List <int>(); int counter = 0; this.tblEquipTableAdapter.Fill(this.lUEquipmentDataSet.tblEquip); foreach (string i in finalInsert) { DataRow Equip; Equip = lUEquipmentDataSet.tblEquip.Select("Equip_Number = '" + i + "'")[0]; equipID.Add(int.Parse(Equip[0].ToString())); counter++; } int[] equipIDarray = equipID.ToArray(); int newCounter = 0; this.tblRentalTableAdapter1.Fill(this.lUEquipmentDataSet.tblRental); DataRow invoice; invoice = lUEquipmentDataSet.tblRental.Rows[lUEquipmentDataSet.tblRental.Count - 1]; int inNum = Convert.ToInt32(invoice[5]); int studentNum = Convert.ToInt32(studentNumberTextBox.Text); DateTime rent = Convert.ToDateTime(dateRentedPicker.Text); DateTime due = Convert.ToDateTime(dateDuePicker.Text); foreach (int i in equipIDarray) { short array = Convert.ToInt16(equipIDarray[newCounter]); tblRentalTableAdapter1.Insert(array, studentNum, rent, due, " ", inNum + 1); LUEquipmentDataSet.tblEquipRow equipRow = luEquipmentDataSet1.tblEquip.FindByEquip_ID(array); equipRow.Status_ID = 9; tblEquipTableAdapter.Update(equipRow); this.tblRentalTableAdapter1.Fill(this.lUEquipmentDataSet.tblRental); } MessageBox.Show("Item rented"); }
private void returnBttn_Click(object sender, EventArgs e) { try { DataRow equipmentByItemNum = luEquipmentDataSet1.tblEquip.Select("Equip_Number = '" + itemNumberTextBox.Text + "'")[0]; int itemID = int.Parse(equipmentByItemNum[0].ToString()); LUEquipmentDataSet.tblEquipRow equipRow = luEquipmentDataSet1.tblEquip.FindByEquip_ID(itemID); equipRow.Status_ID = 1; tblEquipTableAdapter1.Update(equipRow); MessageBox.Show("Item returned"); } catch { MessageBox.Show("Error"); } }