private void btnAddNew_Click(object sender, EventArgs e) { if (txtLockerName.TextLength > 0) { string querytString = "INSERT INTO locker (LOCKER_NAME,LOCKER_STATUS) VALUES " + "('" + txtLockerName.Text + "',1)"; logHandle myLogHandle = new logHandle(); if (myLogHandle.doQuery(querytString)) { myLogHandle.insertChange(AdminID, "Added new locker " + txtLockerName.Text); lockerTableAdapter2.Fill(bblabsDataSet1.locker); } } }
public bool update(int AdminID, string sLockName) { sLockerName = sLockName; logHandle myLog = new logHandle(); if (myLog.doQuery("UPDATE locker SET LOCKER_NAME = '" + sLockerName + "' WHERE LOCKER_ID = " + recordID)) { myLog.insertChange(AdminID, "Changed locker name to: " + sLockName); return(true); } else { return(false); } }
private void btnCheckOut_Click(object sender, EventArgs e) { if (validate()) { thisLocker.setValues(Admin, new User((int)cmbLabUsers.SelectedValue), 2, dateFrom.Value, dateTo.Value); if (thisLocker.checkout()) { logHandle myLog = new logHandle(); myLog.insertChange(Admin.recordID, "Checked out devices for lab user: "******"Could not perform checkout", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { } }
public bool checkout() { String sQuery = "BEGIN TRANSACTION "; for (int i = 0; i < dStoredDevice.Count; i++) { sQuery += "INSERT INTO lockerItem(LOCKER_ID,DEVICE_ID,LOCK_ITEM_STATUS) VALUES(" + recordID + "," + dStoredDevice[i].recordID + "," + 1 + ") "; sQuery += "UPDATE device SET DEVICE_STATUS = 2 WHERE DEVICE_ID = " + dStoredDevice[i].recordID + " "; } sQuery += "UPDATE locker SET KEY_ONE_USER="******", KEY_TWO_USER="******", LOCKER_STATUS = 2, DATE_FROM = '" + dFrom.ToString() + "', DATE_TO='" + dTo.ToString() + "' " + "WHERE LOCKER_ID=" + recordID; sQuery += " COMMIT"; logHandle myLog = new logHandle(); if (myLog.doQuery(sQuery)) { return(true); } else { return(false); } }