private void okbtn_Click(object sender, EventArgs e)
{
if (donebytxt.Text.Trim() == "" || reasontxt.Text.Trim() == "")
{
MessageBox.Show("Cannot process this transaction. Please write fill up the given field.", "Transaction Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
SyspassTxt.Text = "";
}
else if (SyspassTxt.Text != password)
{
MessageBox.Show("Cannot process this transaction. Make sure that your password is correct!.", "Transaction Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
SyspassTxt.Text = "";
SyspassTxt.Focus();
}
else
{
BalloonKingdomDataSetTableAdapters.Inventory_TransactionsTableAdapter addDupItem = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Inventory_TransactionsTableAdapter();
addDupItem.AddnewInventoryTrans(Convert.ToInt32(IDtxt.Text), ItemNmetxt.Text, "Adding", Convert.ToInt32(qtytxt.Text), DateTime.Now, donebytxt.Text.Trim(), reasontxt.Text.Trim());
BalloonKingdomDataSetTableAdapters.InventoryTableAdapter addnewitem = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.InventoryTableAdapter();
addnewitem.AddNewInventoryRec(iid, icat, isub, ispec, iname, itype, isize, iqty, iunit, Convert.ToDecimal(iunitprice), Convert.ToDecimal(isellingprice), Convert.ToDecimal(istock), istatus, icolor, Convert.ToDecimal(iwidth), Convert.ToDecimal(iheight), isup);
MessageBox.Show("New Item has been added!", "Inventory Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
private void okbtn_Click(object sender, EventArgs e)
{
if (donebytxt.Text.Trim() == "")
{
MessageBox.Show("Cannot process this transaction. Please write your name in the given field.", "Transaction Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (SyspassTxt.Text != syspass)
{
MessageBox.Show("Cannot process this transaction. Make sure that your password is correct!.", "Transaction Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
SyspassTxt.Text = "";
}
else
{
int InvQty = 0;
double stockQty = 0, total = 0, totalstock = 0;
double UP = 0;
string status;
SqlCommand cmd25 = new SqlCommand("Select * from Inventory where [Item ID]=" + "'" + Convert.ToString(IDtxt.Text) + "'", conn);
SqlDataReader dr25 = cmd25.ExecuteReader();
while (dr25.Read())
{
InvQty = Convert.ToInt32(dr25["Quantity"].ToString());
stockQty = Convert.ToDouble(dr25["Quantity in Stock"].ToString());
UP = Convert.ToDouble(dr25["Unit Price"].ToString());
}
dr25.Close();
total = Convert.ToDouble(InvQty) + Convert.ToDouble(qtytxt.Text.Trim());
totalstock = stockQty + Convert.ToDouble(qtytxt.Text.Trim());
if (total != 0)
{
status = "available";
}
else
{
status = "unavailable";
}
BalloonKingdomDataSetTableAdapters.InventoryTableAdapter updateDuplicateItem = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.InventoryTableAdapter();
updateDuplicateItem.UpdateDuplicateItem(Convert.ToInt32(total), Convert.ToInt32(totalstock), status, Convert.ToInt32(IDtxt.Text), Convert.ToInt32(IDtxt.Text));
MessageBox.Show("Duplicate Item has been updated!", "Inventory Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
BalloonKingdomDataSetTableAdapters.Inventory_TransactionsTableAdapter addDupItem = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Inventory_TransactionsTableAdapter();
addDupItem.AddnewInventoryTrans(Convert.ToInt32(IDtxt.Text), ItemNmetxt.Text, "Adding", Convert.ToInt32(qtytxt.Text), DateTime.UtcNow, donebytxt.Text.Trim(), "Add Quantity to Duplicate Item");
updateDuplicateItem.UpdateDuplicateItem(Convert.ToInt32(total), Convert.ToInt32(totalstock), status, Convert.ToInt32(IDtxt.Text), Convert.ToInt32(IDtxt.Text));
this.Close();
}
}
private void okbtn_Click(object sender, EventArgs e)
{
if (donebytxt.Text.Trim() == "" || reasontxt.Text.Trim() == "" || qtytxt.Text.Trim() == "")
{
MessageBox.Show("Cannot process this transaction. Please write fill up the given field.", "Transaction Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
Syspasstxt.Text = "";
}
else if (Syspasstxt.Text != password)
{
MessageBox.Show("Cannot process this transaction. Make sure that your password is correct!.", "Transaction Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
Syspasstxt.Text = "";
Syspasstxt.Focus();
}
else
{
string trans;
if (addbtn.Checked == true)
{
trans = "Adding";
}
else
{
trans = "Subtracting";
}
int quantity = Convert.ToInt32(qtytxt.Text.Trim());
double qty = 0, stock = 0, bo = 0;
SqlCommand getinv = new SqlCommand("Select * from Inventory where [Item ID]=" + "'" + idlbl.Text.Trim() + "'", conn);
SqlDataReader drget = getinv.ExecuteReader();
while (drget.Read())
{
qty = Convert.ToDouble(drget["Quantity"].ToString());
stock = Convert.ToDouble(drget["Quantity in Stock"].ToString());
bo = Convert.ToDouble(drget["Back Order"].ToString());
}
drget.Close();
if (addbtn.Checked == true)
{
qty += quantity;
stock += Convert.ToDouble(quantity);
bo -= Convert.ToDouble(quantity);
if (bo < 0)
{
bo = 0;
}
}
else
{
qty -= quantity;
stock -= Convert.ToDouble(quantity);
if (stock == 0)
{
stock = 0;
bo += Convert.ToDouble(quantity);
}
}
BalloonKingdomDataSetTableAdapters.Inventory_TransactionsTableAdapter addInvItem = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Inventory_TransactionsTableAdapter();
addInvItem.AddnewInventoryTrans(Convert.ToInt32(idlbl.Text), txtname.Text, trans, Convert.ToInt32(qtytxt.Text), DateTime.Now, donebytxt.Text.Trim(), reasontxt.Text.Trim());
BalloonKingdomDataSetTableAdapters.InventoryTableAdapter update = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.InventoryTableAdapter();
update.UpdateInvQuantity(Convert.ToInt32(qty), Convert.ToDecimal(stock), Convert.ToInt32(bo), Convert.ToInt32(idlbl.Text.Trim()), Convert.ToInt32(idlbl.Text.Trim()));
MessageBox.Show("Successfully updated Inventory Item Quantity", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}