public static bool AddVoucher(PurchaseVoucherGeneral aPurchaseVoucherGeneral) { if (Helper.Instance.con.State == ConnectionState.Closed) { try { Helper.Instance.con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO PurchaseVoucherGeneral " + "(VoucherNumber,Date,Time,VendorID" + ",TotalFreeItemsQty,TotalTax,Subtotal,DiscountPerc,TotalDiscount" + ",TotalCost,PaymentMethodID,TellerID,Comments,CreditCardInfo" + ",CurrencyID,AccountID,CheckNumber,IsCashCredit,VendorAccountAmountOld" + ",IsChecked,CheckedBy,CheckTime,IsRevised" + ",RevisedBy,ReviseTime,ReviseLoss,Fees,TotalItemsDiscount)" + " VALUES " + "(@VoucherNumber,@Date,@Time,@VendorID" + ",@TotalFreeItemsQty,@TotalTax,@Subtotal,@DiscountPerc,@TotalDiscount" + ",@TotalCost,@PaymentMethodID,@TellerID,@Comments,@CreditCardInfo" + ",@CurrencyID,@AccountID,@CheckNumber,@IsCashCredit,@VendorAccountAmountOld" + ",@IsChecked,@CheckedBy,@CheckTime,@IsRevised" + ",@RevisedBy,@ReviseTime,@ReviseLoss,@Fees,@TotalItemsDiscount)", Helper.Instance.con); cmd.Parameters.Add("@VoucherNumber", SqlDbType.Int).Value = aPurchaseVoucherGeneral.VoucherNumber; cmd.Parameters.Add("@Date", SqlDbType.Date).Value = aPurchaseVoucherGeneral.Date; cmd.Parameters.Add("@Time", SqlDbType.VarChar).Value = aPurchaseVoucherGeneral.Time; cmd.Parameters.Add("@VendorID", SqlDbType.Int).Value = aPurchaseVoucherGeneral.VendorID; //cmd.Parameters.Add("@TotalItems", SqlDbType.Float).Value = aPurchaseVoucherGeneral.TotalItems; cmd.Parameters.Add("@TotalFreeItemsQty", SqlDbType.Float).Value = aPurchaseVoucherGeneral.TotalFreeItemsQty; cmd.Parameters.Add("@TotalTax", SqlDbType.Float).Value = aPurchaseVoucherGeneral.TotalTax; cmd.Parameters.Add("@Subtotal", SqlDbType.Float).Value = aPurchaseVoucherGeneral.Subtotal; cmd.Parameters.Add("@DiscountPerc", SqlDbType.Float).Value = aPurchaseVoucherGeneral.DiscountPerc; cmd.Parameters.Add("@TotalDiscount", SqlDbType.Float).Value = aPurchaseVoucherGeneral.TotalDiscount; cmd.Parameters.Add("@TotalCost", SqlDbType.Float).Value = aPurchaseVoucherGeneral.TotalCost; cmd.Parameters.Add("@PaymentMethodID", SqlDbType.Int).Value = aPurchaseVoucherGeneral.PaymentMethodID; cmd.Parameters.Add("@TellerID", SqlDbType.Int).Value = aPurchaseVoucherGeneral.TellerID; cmd.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = aPurchaseVoucherGeneral.Comments; cmd.Parameters.Add("@CreditCardInfo", SqlDbType.NVarChar).Value = aPurchaseVoucherGeneral.CreditCardInfo; cmd.Parameters.Add("@CurrencyID", SqlDbType.Int).Value = aPurchaseVoucherGeneral.CurrencyID; cmd.Parameters.Add("@AccountID", SqlDbType.Int).Value = aPurchaseVoucherGeneral.AccountID; cmd.Parameters.Add("@CheckNumber", SqlDbType.Int).Value = aPurchaseVoucherGeneral.CheckNumber; cmd.Parameters.Add("@IsCashCredit", SqlDbType.Int).Value = aPurchaseVoucherGeneral.IsCashCredit; cmd.Parameters.Add("@VendorAccountAmountOld", SqlDbType.Float).Value = aPurchaseVoucherGeneral.VendorAccountAmountOld; cmd.Parameters.Add("@IsChecked", SqlDbType.Int).Value = aPurchaseVoucherGeneral.IsChecked; cmd.Parameters.Add("@CheckedBy", SqlDbType.NVarChar).Value = ""; // aPurchaseVoucherGeneral.CheckedBy; //cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = "";//aPurchaseVoucherGeneral.CheckDate; cmd.Parameters.Add("@CheckTime", SqlDbType.VarChar).Value = ""; //aPurchaseVoucherGeneral.CheckTime; cmd.Parameters.Add("@IsRevised", SqlDbType.Int).Value = aPurchaseVoucherGeneral.IsRevised; cmd.Parameters.Add("@RevisedBy", SqlDbType.NVarChar).Value = ""; //aPurchaseVoucherGeneral.RevisedBy; //cmd.Parameters.Add("@ReviseDate", SqlDbType.Date).Value = "";//aPurchaseVoucherGeneral.ReviseDate; cmd.Parameters.Add("@ReviseTime", SqlDbType.VarChar).Value = ""; //aPurchaseVoucherGeneral.ReviseTime; cmd.Parameters.Add("@ReviseLoss", SqlDbType.Float).Value = 0; //aPurchaseVoucherGeneral.ReviseLoss; cmd.Parameters.Add("@Fees", SqlDbType.Float).Value = aPurchaseVoucherGeneral.Fees; cmd.Parameters.Add("@TotalItemsDiscount", SqlDbType.Float).Value = aPurchaseVoucherGeneral.TotalItemsDiscount; cmd.ExecuteNonQuery(); Helper.Instance.con.Close(); return(true); } catch (Exception ex) { Helper.Instance.con.Close(); MessageBox.Show("ERROR IN *PurchaseVoucherGeneral* MGMT (AddVoucher1 FUNCTION) EX=" + ex.Message.ToString()); return(false); } } return(false); }
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}"); } } }