private void pictureBoxClearButton_Click(object sender, EventArgs e)
{
string itemCode = textBox_ItemCode_ClearStock.Text;
string repeatitemCode = textBox_RepeatItemCode_ClearStock.Text;
string description = textBoxDescription_ClearStock.Text;
string date = dateTimePicker_ClearItem.Value.ToString();
if (itemCode == repeatitemCode && (itemCode != "" || repeatitemCode != ""))
{
DatabaseConnections db = new DatabaseConnections();
long QuantityHand = db.CheckQuantity(itemCode);
DialogResult confirm = MessageBox.Show("ItemCode : " + itemCode + "\nQuantity on Hand : " + QuantityHand, "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (confirm == DialogResult.Yes && QuantityHand > 0)
{
DatabaseConnections db1 = new DatabaseConnections();
db1.Clearstock(itemCode);
db1.Delete_Clear_Details(itemCode, description, date, "Clear");
textBox_RepeatItemCode_ClearStock.Text = null;
textBox_ItemCode_ClearStock.Text = null;
textBoxDescription_ClearStock.Text = null;
}
else if (confirm == DialogResult.Yes && QuantityHand == 0)
{
textBox_ItemCode_ClearStock.Text = null;
textBox_RepeatItemCode_ClearStock.Text = null;
textBoxDescription_ClearStock.Text = null;
MessageBox.Show("Item is Not In the Database\n or \nItem Quantity is 0.\n\n\nCheck Item Code Again.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
textBox_ItemCode_ClearStock.Text = null;
textBox_RepeatItemCode_ClearStock.Text = null;
textBoxDescription_ClearStock.Text = null;
}
}
else
{
MessageBox.Show("Check Item Code", "", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
}
private void pictureBoxDeleteButton_Click(object sender, EventArgs e)
{
String itemCode = textBox_ItemCode_DeleteStock.Text;
String repeatitemCode = textBox_RepeatItemCode_DeleteStock.Text;
string description = textBoxDescription_DeleteItem.Text;
string date = dateTimePicker_DeleteItem.Value.ToString();
if (itemCode == repeatitemCode && (itemCode != "" || repeatitemCode != ""))
{
DatabaseConnections db = new DatabaseConnections();
long QuantityHand = db.CheckQuantity(itemCode);
DialogResult result1 = MessageBox.Show("ItemCode : " + itemCode + "\n Item Name : " + db.getItemDetails_String(itemCode), "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result1 == DialogResult.Yes && QuantityHand == 0)
{
DatabaseConnections db1 = new DatabaseConnections();
textBox_ItemCode_DeleteStock.Text = null;
textBox_RepeatItemCode_DeleteStock.Text = null;
textBoxDescription_DeleteItem.Text = null;
db1.DeleteItem(itemCode);
db1.Delete_Clear_Details(itemCode, description, date, "Delete");
}
else if (result1 == DialogResult.Yes && QuantityHand > 0)
{
DialogResult result = MessageBox.Show("Item Quantity is " + QuantityHand + " Please clear the stock before delete the Item.", "Warnning", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
Stock_Control stock = new Stock_Control(4);
stock.Show();
}
else
{
this.Hide();
textBox_ItemCode_DeleteStock.Text = null;
textBox_RepeatItemCode_DeleteStock.Text = null;
textBoxDescription_DeleteItem.Text = null;
}
}
else if (result1 == DialogResult.Yes && QuantityHand == -1)
{
MessageBox.Show("Invalid ItemCode", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox_ItemCode_DeleteStock.Text = null;
textBox_RepeatItemCode_DeleteStock.Text = null;
textBoxDescription_DeleteItem.Text = null;
}
else
{
textBox_ItemCode_DeleteStock.Text = null;
textBox_RepeatItemCode_DeleteStock.Text = null;
textBoxDescription_DeleteItem.Text = null;
}
}
else
{
MessageBox.Show("Check Item Code", "", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
}
