private void btnRelease_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(cbHolderName.Text))
{
cbHolderName.Focus();
}
else if (cbBags.SelectedIndex == -1)
{
cbBags.Focus();
}
else if (String.IsNullOrEmpty(txtLocation.Text))
{
txtLocation.Focus();
}
else
{
if (dgvItems.RowCount < 1)
{
MessageBox.Show(null, cbBags.Text + " is empty.", "Release bag", MessageBoxButtons.OK, MessageBoxIcon.Warning);
clearRelease();
return;
}
if (dgvItems.RowCount > 0)
{
if (dgvItems.Rows[0].Cells[8].Value.ToString().Equals("OUT"))
{
MessageBox.Show(null, "Sorry, but the bag is currently OUT.", "Release bag", MessageBoxButtons.OK, MessageBoxIcon.Warning);
clearRelease();
return;
}
}
DialogResult result = MessageBox.Show(null, "Make sure to double check the items, because you cannot alter the records for security purposes.", "Release bag", MessageBoxButtons.OKCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2);
if (result == DialogResult.Cancel)
{
return;
}
String holderId = null;
String bagId = ((ComboBoxItem)cbBags.SelectedItem).HiddenValue;
//Holders
if (cbHolderName.SelectedIndex < 0)
{
if (inventory.addHolders(cbHolderName.Text, "1"))
{
holderId = inventory.getLastHolderId();
cbHolderName.Items.Add(new ComboBoxItem(cbHolderName.Text, holderId));
}
}
else
{
holderId = ((ComboBoxItem)cbHolderName.SelectedItem).HiddenValue;
}
if (techbag.insertTechBagInfo(holderId, bagId, txtLocation.Text, dtpFrom.Value.ToString("yyyy-MM-dd"), dtpTo.Value.ToString("yyyy-MM-dd")))
{
String infoId = techbag.getLastInfoId();
Boolean ok = false;
foreach (DataGridViewRow row in dgvItems.Rows)
{
String itemId = row.Cells[1].Value.ToString();
String propertyNo = row.Cells[2].Value.ToString();
String status = row.Cells[8].Value.ToString();
String condition = row.Cells[9].Value.ToString();
String qty = row.Cells[3].Value.ToString();
String bagItemId = row.Cells[0].Value.ToString();
if (techbag.insertTechBagLogs(bagItemId, "Release", infoId, itemId, propertyNo, condition, qty, ""))
{
ok = true;
}
}
if (ok)
{
MessageBox.Show(null, "Bag was successfully released.", "Release bag", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadTechbags();
clearRelease();
}
}
}
}
private void btnAssign_Click(object sender, EventArgs e)
{
String dateReceived = null;
String holderId = null;
String itemId = null;
if (dgvItems.RowCount < 0)
{
MessageBox.Show(null, "Please select an item.", "Select item", MessageBoxButtons.OK, MessageBoxIcon.Warning);
dgvItems.Focus();
return;
}
else
{
int index = dgvItems.CurrentCell.RowIndex;
itemId = dgvItems.Rows[index].Cells[0].Value.ToString();
}
if (cbStatus.SelectedIndex < 0)
{
cbStatus.Focus();
cbStatus.SelectAll();
}
else if (String.IsNullOrEmpty(cbHolderName.Text))
{
cbHolderName.Focus();
}
else
{
DialogResult result = MessageBox.Show(null, "Are you sure you want to assign the item to " + cbHolderName.Text + "?", "Assign to person", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == DialogResult.No)
{
return;
}
if (switchRecieved.Value == false)
{
dateReceived = "0000-00-00";
}
else
{
dateReceived = dtpDateReceived.Value.ToString("yyyy-MM-dd");
}
//Holders
if (cbHolderName.SelectedIndex < 0)
{
String isEmployee = null;
if (rbEmployee.Checked == true)
{
isEmployee = "1";
}
else
{
isEmployee = "0";
}
if (inventory.addHolders(cbHolderName.Text, isEmployee))
{
holderId = inventory.getLastHolderId();
cbHolderName.Items.Add(new ComboBoxItem(cbHolderName.Text, holderId));
cbHolderName.SelectedIndex = cbHolderName.Items.Count - 1;
}
}
else
{
holderId = ((ComboBoxItem)cbHolderName.SelectedItem).HiddenValue;
}
//Inventory
String statusId = ((ComboBoxItem)cbStatus.SelectedItem).HiddenValue;
if (inventory.insertInventory(propertyNo, statusId, holderId, dateReceived, txtRemarks.Text, itemId, "0"))
{
MessageBox.Show(null, "Item was successfully assigned to " + cbHolderName.Text + ".", "Assign to person", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadInventory();
loadItems();
txtRemarks.Text = String.Empty;
cbHolderName.SelectedIndex = -1;
cbHolderName.Text = string.Empty;
pnlAssign.Visible = false;
}
}
}