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