public static bool InsertBill(BillGeneral aBillGeneral) { if (Helper.Instance.con.State == System.Data.ConnectionState.Closed) { try { Helper.Instance.con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO BillGeneral (Number,Date,BillTime,TotalItems,TotalTax,TotalPrice,TotalCost,TellerID,CustomerID,PriceLevelID,PaymentMethodID,Comments,SalesDiscount,DiscountPerc,CashIn,TotalDiscount,CreditCardInfo,CurrencyID,AccountID,NetAmount,CheckNumber,Currency,IsChecked,IsRevised,SubTotal,IsCashCredit,CustomerAccountAmountOld) VALUES (@Number,@Date,@BillTime,@TotalItems,@TotalTax,@TotalPrice,@TotalCost,@TellerID,@CustomerID,@PriceLevelID,@PaymentMethodID,@Comments,@SalesDiscount,@DiscountPerc,@CashIn,@TotalDiscount,@CreditCardInfo,@CurrencyID,@AccountID,@NetAmount,@CheckNumber,@Currency,0,0,@SubTotal,@IsCashCredit,@CustomerAccountAmountOld)", Helper.Instance.con); //,PaymentMethodID,Comments,SalesDiscount,DiscountPerc,CashIn, //TotalDiscount,CreditCardInfo,CurrencyID,AccountID,NetAmount, //CheckNumber,Currency cmd.Parameters.Add("@Number", SqlDbType.Int).Value = aBillGeneral.Bill_General_Number; cmd.Parameters.Add("@Date", SqlDbType.Date).Value = aBillGeneral.Bill_General_Date; cmd.Parameters.Add("@BillTime", SqlDbType.NVarChar).Value = aBillGeneral.Bill_General_Time; cmd.Parameters.Add("@TotalItems", SqlDbType.Float).Value = aBillGeneral.Bill_General_TotalItems; cmd.Parameters.Add("@TotalTax", SqlDbType.Float).Value = aBillGeneral.Bill_General_TotalTax; cmd.Parameters.Add("@TotalPrice", SqlDbType.Float).Value = aBillGeneral.Bill_General_TotalPrice; cmd.Parameters.Add("@TotalCost", SqlDbType.Float).Value = aBillGeneral.Bill_General_TotalCost; cmd.Parameters.Add("@TellerID", SqlDbType.Int).Value = aBillGeneral.Bill_General_TellerID; cmd.Parameters.Add("@CustomerID", SqlDbType.Int).Value = aBillGeneral.Bill_General_CustomerID; cmd.Parameters.Add("@PriceLevelID", SqlDbType.Int).Value = aBillGeneral.Bill_General_PriceLevel; cmd.Parameters.Add("@PaymentMethodID", SqlDbType.Int).Value = aBillGeneral.Bill_General_PaymentMethodID; cmd.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = aBillGeneral.Bill_General_Comments; cmd.Parameters.Add("@SalesDiscount", SqlDbType.Float).Value = aBillGeneral.Bill_General_SalesDiscount; cmd.Parameters.Add("@DiscountPerc", SqlDbType.Float).Value = aBillGeneral.Bill_General_DiscountPerc; cmd.Parameters.Add("@CashIn", SqlDbType.Float).Value = aBillGeneral.Bill_General_CashIn; cmd.Parameters.Add("@TotalDiscount", SqlDbType.Float).Value = aBillGeneral.Bill_General_TotalDiscount; cmd.Parameters.Add("@CreditCardInfo", SqlDbType.NVarChar).Value = aBillGeneral.Bill_General_CreditCardInfo; cmd.Parameters.Add("@CurrencyID", SqlDbType.Int).Value = aBillGeneral.Bill_General_CurrencyID; cmd.Parameters.Add("@AccountID", SqlDbType.Int).Value = aBillGeneral.Bill_General_AccountID; cmd.Parameters.Add("@NetAmount", SqlDbType.Float).Value = aBillGeneral.Bill_General_NetAmount; cmd.Parameters.Add("@CheckNumber", SqlDbType.Int).Value = aBillGeneral.Bill_General_CheckNumber; cmd.Parameters.Add("@Currency", SqlDbType.NVarChar).Value = aBillGeneral.Bill_General_Currency; //ischecked isrevised is added in the sql query to 0,0 cmd.Parameters.Add("@SubTotal", SqlDbType.Float).Value = aBillGeneral.Bill_General_SubTotal; cmd.Parameters.Add("@IsCashCredit", SqlDbType.Int).Value = aBillGeneral.Bill_General_IsCashCredit; cmd.Parameters.Add("@CustomerAccountAmountOld", SqlDbType.Float).Value = aBillGeneral.CustomerAccountAmountOld; cmd.ExecuteNonQuery(); Helper.Instance.con.Close(); return(true); } catch (Exception ex) { Helper.Instance.con.Close(); MessageBox.Show("ERROR IN BILL GENERAL MGMT (INSERT FUNCTION) EX=" + ex.Message.ToString()); return(false); } } return(false); }
private void Add1000Sale_Click(object sender, EventArgs e) { int cnt = 1; DateTime date = DateTime.Now; var randAmount = new Random(); int userId = int.Parse(UsersMgmt.SelectAllUsers().Rows[0]["ID"].ToString()); while (cnt++ < NumberOfBills) { try { int numofDetailed = randAmount.Next(1, 20); var aBillGeneral = new BillGeneral(); aBillGeneral.Bill_General_AccountID = 1; aBillGeneral.Bill_General_CashIn = 100; aBillGeneral.Bill_General_Currency = "JOD"; aBillGeneral.Bill_General_CurrencyID = 1; aBillGeneral.Bill_General_CustomerID = 1; aBillGeneral.Bill_General_Date = date.Subtract(TimeSpan.FromDays(randAmount.Next(1, 2000))).ToShortDateString(); aBillGeneral.Bill_General_DiscountPerc = 0; aBillGeneral.Bill_General_IsCashCredit = 0; aBillGeneral.Bill_General_NetAmount = 100; aBillGeneral.Bill_General_Number = BillGeneralMgmt.NextBillNumber(); aBillGeneral.Bill_General_PaymentMethodID = 1; aBillGeneral.Bill_General_PriceLevel = 1; aBillGeneral.Bill_General_SalesDiscount = 0; aBillGeneral.Bill_General_SubTotal = 100; aBillGeneral.Bill_General_TellerID = userId; aBillGeneral.Bill_General_Time = DateTime.Now.ToShortTimeString(); aBillGeneral.Bill_General_TotalCost = randAmount.Next(50, 99); aBillGeneral.Bill_General_TotalDiscount = 0; aBillGeneral.Bill_General_TotalItems = numofDetailed; aBillGeneral.Bill_General_TotalPrice = 100; aBillGeneral.Bill_General_TotalTax = 16; aBillGeneral.CustomerAccountAmountOld = 0; aBillGeneral.Bill_General_Comments = "Test Sale"; aBillGeneral.Bill_General_CreditCardInfo = "NotCredit"; Random aRandom = new Random(); if (BillGeneralMgmt.InsertBill(aBillGeneral)) { while (numofDetailed > 0) { BillDetailed aBillDetailed = new BillDetailed(); string aBarcode = "Test Item " + aRandom.Next(1, (int)NumberOfItems); DataTable aItemRow = ItemsMgmt.SelectItemByBarCode(aBarcode); if (aItemRow.Rows.Count != 0) { aBillDetailed.Bill_Detailed_ItemDescription = aItemRow.Rows[0]["Description"].ToString(); aBillDetailed.Bill_Detailed_ItemID = int.Parse(aItemRow.Rows[0]["ID"].ToString()); aBillDetailed.Bill_Detailed_Number = aBillGeneral.Bill_General_Number; aBillDetailed.Bill_Detailed_OldAvaQty = double.Parse(aItemRow.Rows[0]["Qty"].ToString()); aBillDetailed.Bill_Detailed_OldAvgUnitCost = double.Parse(aItemRow.Rows[0]["AvgUnitCost"].ToString()); aBillDetailed.Bill_Detailed_Qty = numofDetailed; aBillDetailed.Bill_Detailed_SellPrice = double.Parse(aItemRow.Rows[0]["SellPrice"].ToString()); aBillDetailed.Bill_Detailed_TotalPerUnit = aBillDetailed.Bill_Detailed_Qty * aBillDetailed.Bill_Detailed_SellPrice; BillDetailedMgmt.InsertItem(aBillDetailed); } numofDetailed--; } } if (cnt % 100 == 0) { label1.Text = $"Adding Bill {cnt}/{NumberOfBills} ... ({(cnt / NumberOfBills) * 100 })%"; Application.DoEvents(); } } catch (Exception ex) { MessageBox.Show($"Error in {cnt} \n {ex}"); } } }