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