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