public static void InsertItem(BillDetailed aBillDetailed)
{
if (Helper.Instance.con.State == System.Data.ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO BillDetailed (ItemID,ItemDescription,Qty,SellPrice,TotalPerUnit,Number,OldAvaQty,OldAvgUnitCost,IsRevised) VALUES (@ItemID,@ItemDescription,@Qty,@SellPrice,@TotalPerUnit,@BillNumber,@OldAvaQty,@OldAvgUnitCost,0)", Helper.Instance.con);
cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = aBillDetailed.Bill_Detailed_ItemID;
cmd.Parameters.Add("@ItemDescription", SqlDbType.NVarChar).Value = aBillDetailed.Bill_Detailed_ItemDescription;
cmd.Parameters.Add("@Qty", SqlDbType.Float).Value = aBillDetailed.Bill_Detailed_Qty;
cmd.Parameters.Add("@SellPrice", SqlDbType.Float).Value = aBillDetailed.Bill_Detailed_SellPrice;
cmd.Parameters.Add("@TotalPerUnit", SqlDbType.Float).Value = aBillDetailed.Bill_Detailed_TotalPerUnit;
cmd.Parameters.Add("@BillNumber", SqlDbType.Int).Value = aBillDetailed.Bill_Detailed_Number;
cmd.Parameters.Add("@OldAvaQty", SqlDbType.Float).Value = aBillDetailed.Bill_Detailed_OldAvaQty;
cmd.Parameters.Add("@OldAvgUnitCost", SqlDbType.Float).Value = aBillDetailed.Bill_Detailed_OldAvgUnitCost;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
}
catch (Exception ex)
{
Helper.Instance.con.Close();
MessageBox.Show("ERROR IN BILL DETAILED MGMG (INSERT FUNCTION) EX=" + ex.Message.ToString());
}
}
}
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}");
}
}
}
