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