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