public static void AddItem(PurchaseVoucherDetailed aPurchaseVoucherDetailed) { if (Helper.Instance.con.State == ConnectionState.Closed) { try { Helper.Instance.con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO PurchaseVoucherDetailed (ItemID,Qty,ItemCost,Discount,FreeItemsQty,VoucherNumber,OldAvgUnitCost,OldAvaQty,IsRevised) VALUES (@ItemID,@Qty,@ItemCost,@Discount,@FreeItemsQty,@VoucherNumber,@OldAvgUnitCost,@OldAvaQty,0)", Helper.Instance.con); cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_ItemID; //cmd.Parameters.Add("@Barcode", SqlDbType.NVarChar).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_Barcode; cmd.Parameters.Add("@Qty", SqlDbType.Float).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_Qty; cmd.Parameters.Add("@ItemCost", SqlDbType.Float).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_ItemCost; cmd.Parameters.Add("@Discount", SqlDbType.Float).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_Discount; cmd.Parameters.Add("@FreeItemsQty", SqlDbType.Float).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_FreeItemsQty; cmd.Parameters.Add("@VoucherNumber", SqlDbType.Int).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_VoucherNumber; cmd.Parameters.Add("@OldAvgUnitCost", SqlDbType.Float).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_OldAvgUnitCost; cmd.Parameters.Add("@OldAvaQty", SqlDbType.Float).Value = aPurchaseVoucherDetailed.Purchase_Voucher_Detailed_OldAvaQty; //ISERVISED SET TO ZERO IN THE QUERY cmd.ExecuteNonQuery(); Helper.Instance.con.Close(); } catch (Exception ex) { Helper.Instance.con.Close(); MessageBox.Show("ERROR IN *PurchaseVoucherDetailed* MGMT (AddItem FUNCTION) EX=" + ex.Message.ToString()); } } }
private void Add1000PurchaseVoucherBtn_Click(object sender, EventArgs e) { Random randAmount = new Random(); int cnt = 1; var Vendors = VendorsMgmt.SelectAllVendors(); int userId = int.Parse(UsersMgmt.SelectAllUsers().Rows[0]["ID"].ToString()); while (cnt++ < NumberOfPurchases) { try { PurchaseVoucherGeneral aPurchaseGeneral = new PurchaseVoucherGeneral(); aPurchaseGeneral.AccountID = 1; aPurchaseGeneral.Comments = ""; aPurchaseGeneral.CurrencyID = 1; aPurchaseGeneral.Date = DateTime.Now.Subtract(TimeSpan.FromDays(randAmount.Next(1, 2000))).ToShortDateString(); aPurchaseGeneral.DiscountPerc = 0; aPurchaseGeneral.Fees = 10; aPurchaseGeneral.IsCashCredit = 0; aPurchaseGeneral.IsChecked = 0; aPurchaseGeneral.IsRevised = 0; aPurchaseGeneral.PaymentMethodID = 1; aPurchaseGeneral.Subtotal = 100; aPurchaseGeneral.TellerID = userId; aPurchaseGeneral.Time = DateTime.Now.ToShortTimeString(); aPurchaseGeneral.TotalCost = 90; aPurchaseGeneral.TotalDiscount = 0; aPurchaseGeneral.TotalFreeItemsQty = 0; aPurchaseGeneral.TotalItemsDiscount = 0; aPurchaseGeneral.TotalTax = 10; aPurchaseGeneral.VendorAccountAmountOld = 0; aPurchaseGeneral.VendorID = int.Parse(Vendors.Rows[(int)NumberOfPurchases % Vendors.Rows.Count]["ID"].ToString()); aPurchaseGeneral.VoucherNumber = PurchaseVoucherGeneralMgmt.NextVoucherNumber(); aPurchaseGeneral.CreditCardInfo = ""; int NumofDetailed = randAmount.Next(1, 20); if (PurchaseVoucherGeneralMgmt.AddVoucher(aPurchaseGeneral)) { while (NumofDetailed > 0) { PurchaseVoucherDetailed aPurchaseDetailed = new PurchaseVoucherDetailed(); string aBarcode = "Test Item " + randAmount.Next(1, (int)NumberOfItems).ToString(); DataTable aItemRow = ItemsMgmt.SelectItemByBarCode(aBarcode); if (aItemRow.Rows.Count != 0) { aPurchaseDetailed.Purchase_Voucher_Detailed_ItemID = int.Parse(aItemRow.Rows[0]["ID"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_VoucherNumber = aPurchaseGeneral.VoucherNumber; aPurchaseDetailed.Purchase_Voucher_Detailed_IsRevised = 0; aPurchaseDetailed.Purchase_Voucher_Detailed_ItemCost = double.Parse(aItemRow.Rows[0]["AvgUnitCost"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_OldAvaQty = double.Parse(aItemRow.Rows[0]["Qty"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_Qty = NumofDetailed; aPurchaseDetailed.Purchase_Voucher_Detailed_Discount = 0; // = double.Parse(aItemRow.Rows[0]["SellPrice"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_FreeItemsQty = 0; // aBillDetailed.Bill_Detailed_TotalPerUnit = aBillDetailed.Bill_Detailed_Qty * aBillDetailed.Bill_Detailed_SellPrice; PurchaseVoucherDetailedMgmt.AddItem(aPurchaseDetailed); } NumofDetailed--; } } if (cnt % 100 == 0) { label1.Text = $"Adding Purchase Order {cnt}/{NumberOfPurchases} ... ({(cnt / NumberOfPurchases) * 100 })%"; Application.DoEvents(); } } catch (Exception ex) { MessageBox.Show($"Error in {cnt} \n {ex}"); } } }