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