public BorrowedEquipment GetAITEM(int ID)
{
// String eventnr = Convert.ToString(ID);
MySqlCommand command = new MySqlCommand("SELECT * FROM BORROWEDEQUIPMENTS WHERE EVENTID=" + ID, connection);
BorrowedEquipment Borrowedmaterial = null;
try
{
connection.Open();
MySqlDataReader r = command.ExecuteReader();
r.Read();
int ITEMSID = Convert.ToInt32(r["ITEMID"]);
int eventid = Convert.ToInt32(r["EVENTID"]);
// DateTime borroweddate =Convert.ToDateTime(r["BORROWED_DATE"]);
// DateTime ReturnDate = Convert.ToDateTime(r["RETURN_DATE"]);
// if(DBNull.Value)
//if (r["RETURN_DATE"] == DBNull.Value)
//{
// ReturnDate = DateTime.Now; // the visitor doesn't have a reservation.
//}
//else
//{
// SpotID = Convert.ToInt32(r["CAMPINGSPOTID"]);
//}
// String b = borroweddate.ToShortDateString();
//string c = ReturnDate.ToShortDateString();
return(Borrowedmaterial = new BorrowedEquipment(ITEMSID, eventid));
}
catch
{
MessageBox.Show("Error occurred.");
}
finally
{
connection.Close();
}
return(Borrowedmaterial); // no visitor found.
}
private void buttonReturn_Click(object sender, EventArgs e)
{
//foreach (var item in returned)
//{
// Equipmentdata.ReturnProduct(item.ItemID,item.)
//}
if (textBox1.Text != "")
{
Visitor visitor = CheckForid();
BorrowedEquipment borrowedequip = CheckForItemID();
DateTime updateReturnDate;
updateReturnDate = Convert.ToDateTime(dateTimePicker1.Value);
Equipmentdata.ReturnItem(borrowedequip.EventID);
MessageBox.Show("Return Date added to DB");
}
}
