public Boolean updateParkingSpace(ParkingSlot passedData) { bool reqStatus = false; passedData.slotIsAvailable = passedData.slotIsAvailable; passedData.slotID = passedData.slotID; try { openConnection(); sql = @"UPDATE tblparkingslot SET slotIsAvailable='" + passedData.slotIsAvailable + "' WHERE slotID='" + passedData.slotID + "'"; cmd = new MySqlCommand(sql, con); cmd.ExecuteNonQuery(); reqStatus = true; } catch { reqStatus = false; } finally { con.Close(); } return(reqStatus); }//END OF UPDATE PARKING SLOT
private void btnSave_Click(object sender, EventArgs e) { if (txtAmountPaid.Text.All(char.IsDigit) && txtChange.Text != "" && Double.Parse(txtChange.Text) >= 0) { //Save ReceiptReference receipt = new ReceiptReference(); receipt.refID = selectedID; receipt.refStatus = "PAID"; receipt.refPersonnelOut = currentUserID; receipt.refTimeCount = lblTimeCount.Text; receipt.refPrice = lblAmount.Text; receipt.refAmountPaid = txtAmountPaid.Text; receipt.refAmountChange = txtChange.Text; receipt.refTimeOut = txtTimeOut.Text; if (connect.updateReceiptReference(receipt)) { ParkingSlot dataToPass = new ParkingSlot(); dataToPass.slotIsAvailable = "1"; dataToPass.slotID = (Convert.ToInt32(txtParkingNo.Text) - 100).ToString(); connect.updateParkingSpace(dataToPass); MessageBox.Show("Saved Successfully!"); this.Close(); } else { MessageBox.Show("Ooops Something went wrong!"); } } else { MessageBox.Show("Invalid Amount! Please check your inputs."); } }
public void receiptRefCreate() { VehicleInfo info = new VehicleInfo(); info.vehicleOwner = txtCustomer.Text; info.vehiclePlateNo = txtVehiclePlateNo.Text; foreach (var brandRef in currentDataBrand) { if (brandRef.brandName == cboVehicleBrand.Text) { info.vehicleBrand = brandRef.brandID; break; } } info.vehicleColor = txtVehicleColor.Text; if (connect.createVehicleInfo(info)) { string lastInsertedID = connect.lastInsertedVehicleInfo(); GenerateCode(); ReceiptReference receiptRef = new ReceiptReference(); receiptRef.refBarcode = generatedCode; receiptRef.refPersonnelIn = this.currentUserID; receiptRef.refVehicleID = lastInsertedID; receiptRef.refParkingID = (Convert.ToInt32(selectedParkingID) - 100).ToString(); ParkingSlot dataToPass = new ParkingSlot(); dataToPass.slotIsAvailable = "0"; dataToPass.slotID = (Convert.ToInt32(selectedParkingID) - 100).ToString(); connect.updateParkingSpace(dataToPass); if (connect.createReceiptReference(receiptRef)) { clearTransactionData(); //MessageBox.Show("Successfully Generated!"); } } }
private void btnViewParkingSpace_Click(object sender, EventArgs e) { frmParkingSpace parking = new frmParkingSpace(); ParkingSlot dataToPass = new ParkingSlot(); parking.ShowDialog(); var id = parking.parkingID; if (id != "") { selectedParkingID = id; txtParkingNo.Text = id; txtParkingBlock.Text = (Convert.ToInt32(id) <= 120 ? "SECTION A" : "SECTION B"); } else { txtParkingNo.Clear(); txtParkingBlock.Clear(); } }
}//END OF UPDATE PARKING SLOT public List <ParkingSlot> readParkingSlot_all() { try { openConnection(); sql = "SELECT * FROM tblparkingslot"; cmd = new MySqlCommand(sql, con); rd = cmd.ExecuteReader(); if (rd.HasRows) { var listOfParkingSlots = new List <ParkingSlot>(); while (rd.Read()) { var slot = new ParkingSlot(); slot.slotID = rd["slotID"].ToString(); slot.slotNumber = rd["slotNumber"].ToString(); slot.slotIsAvailable = rd["slotIsAvailable"].ToString(); listOfParkingSlots.Add(slot); } return(listOfParkingSlots); } else { Console.WriteLine("No data"); } } catch (Exception ex) { Console.WriteLine(ex); } finally { con.Close(); } return(null); }//END OF READ ALL PARKING SLOT