private void UpdateStockFullRefund()
{
List <int> SkuList = new List <int>();
List <int> QtyList = new List <int>();
List <string> Gift = new List <string>();
foreach (Label Labels in pnlItems.Controls.OfType <Label>())
{
if (Labels.Name.Contains("Sku"))
{
SkuList.Add(Convert.ToInt32(Labels.Text));
}
if (Labels.Name.Contains("Gift"))
{
Gift.Add(Labels.Text);
}
}
foreach (ComboBox qty in pnlItems.Controls.OfType <ComboBox>())
{
if (qty.Name.Contains("Quantity"))
{
QtyList.Add(Convert.ToInt32(qty.SelectedItem));
}
}
for (int i = 0; i < SkuList.Count; i++)
{
DatabaseAssist.UpdateMaterialQty(SkuList[i], QtyList[i], "Add");
DatabaseAssist.UpdateProductQtySold(SkuList[i], QtyList[i], "Remove");
if (Gift[i] != "No ")
{
DatabaseAssist.UpdateGiftBoxes(Gift[i], QtyList[i], "Add");
}
}
}
private void BtnAdjust_Click(object sender, EventArgs e)
{
if (Helper.CheckTextBoxForString(txtQuant.Text) == "notnumber")
{
MessageBox.Show("Please Enter a valid Quantity to add/remove", "Error");
txtQuant.Focus();
txtQuant.Text = "";
return;
}
else if (cmbSKU.SelectedIndex == -1)
{
MessageBox.Show("Please Select a valid SKU", "Error");
cmbSKU.Focus();
cmbSKU.SelectedText = "";
return;
}
DialogResult result = MessageBox.Show("Are you sure you want to adjust material " + cmbSKU.SelectedItem.ToString(), "Are you sure?", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
if (radAdd.Checked)
{
DatabaseAssist.UpdateMaterialQty(Convert.ToInt32(cmbSKU.SelectedItem), Convert.ToInt32(txtQuant.Text), "Add");
User.AddToUserLog("Materials Adjusted", User.Username + "Added Materials for SKU " + cmbSKU.SelectedItem.ToString());
}
else if (radRemove.Checked)
{
DatabaseAssist.UpdateMaterialQty(Convert.ToInt32(cmbSKU.SelectedItem), Convert.ToInt32(txtQuant.Text), "Remove");
User.AddToUserLog("Materials Adjusted", User.Username + "Removed Materials for SKU " + cmbSKU.SelectedItem.ToString());
}
}
else
{
return;
}
MessageBox.Show("Materials have been Adjusted", "Success");
}
private void UpdateStockPartRefund()
{
List <int> SkuList = new List <int>();
List <int> QtyList = new List <int>();
List <string> Gift = new List <string>();
for (int i = 0; i < dgvRefunds.Rows.Count - 1; i++)
{
SkuList.Add((Convert.ToInt16(dgvRefunds.Rows[i].Cells[2].Value)));
QtyList.Add((Convert.ToInt16(dgvRefunds.Rows[i].Cells[6].Value)));
Gift.Add(dgvRefunds.Rows[i].Cells[8].Value.ToString());
}
for (int i = 0; i < SkuList.Count; i++)
{
DatabaseAssist.UpdateMaterialQty(SkuList[i], QtyList[i], "Add");
DatabaseAssist.UpdateProductQtySold(SkuList[i], QtyList[i], "Remove");
if (Gift[i] != "No " && chkGift.Checked == true)
{
DatabaseAssist.UpdateGiftBoxes(Gift[i], QtyList[i], "Add");
}
}
}