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