public Int64 Insert(DepositDetails Details)
{
try
{
Save(Details);
Int64 iID = Int64.Parse(base.getLAST_INSERT_ID(this));
TerminalReport clsTerminalReport = new TerminalReport(base.Connection, base.Transaction);
clsTerminalReport.UpdateDeposit(Details);
CashierReports clsCashierReport = new CashierReports(base.Connection, base.Transaction);
clsCashierReport.UpdateDeposit(Details);
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Insert(CashCountDetails[] Details)
{
try
{
if (Details.Length > 0)
{
decimal Amount = 0;
foreach (CashCountDetails details in Details)
{
Insert(details);
Amount += details.DenominationAmount;
}
CashierReports clsCashierReport = new CashierReports(base.Connection, base.Transaction);
clsCashierReport.UpdateCashCount(Details[0].BranchDetails.BranchID, Details[0].CashierID, Details[0].TerminalNo, Amount);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public CashierReportDetails Details(Int64 CashierID, int BranchID, string TerminalNo)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"BranchID, " +
"TerminalNo, " +
"CashierID, " +
"NetSales, " +
"GrossSales, " +
"TotalDiscount, " +
"SNRDiscount, " +
"PWDDiscount, " +
"OtherDiscount, " +
"TotalCharge, " +
"DailySales, " +
"QuantitySold, " +
"GroupSales, " +
"VATExempt, " +
"NonVATableAmount, " +
"VAT, " +
"VATableAmount, " +
"ZeroRatedSales, " +
"EVAT, " +
"LocalTax, " +
"CashSales, " +
"ChequeSales, " +
"CreditCardSales, " +
"CreditSales, " +
"RefundCash, " +
"RefundCheque, " +
"RefundCreditCard, " +
"RefundCredit, " +
"RefundDebit, " +
"CreditPayment, " +
"CreditPaymentCash, " +
"CreditPaymentCheque, " +
"CreditPaymentCreditCard, " +
"CreditPaymentDebit, " +
"DebitPayment, " +
"RewardPointsPayment, " +
"RewardConvertedPayment, " +
"CashInDrawer, " +
"TotalDisburse, " +
"CashDisburse, " +
"ChequeDisburse, " +
"CreditCardDisburse, " +
"TotalWithHold, " +
"CashWithHold, " +
"ChequeWithHold, " +
"CreditCardWithHold, " +
"TotalPaidOut, " +
"TotalDeposit, " +
"CashDeposit, " +
"ChequeDeposit, " +
"CreditCardDeposit, " +
"BeginningBalance, " +
"VoidSales, " +
"RefundSales, " +
"ItemsDiscount, " +
"SubTotalDiscount, " +
"NoOfCashTransactions, " +
"NoOfChequeTransactions, " +
"NoOfCreditCardTransactions, " +
"NoOfCreditTransactions, " +
"NoOfCombinationPaymentTransactions, " +
"NoOfCreditPaymentTransactions, " +
"NoOfDebitPaymentTransactions, " +
"NoOfClosedTransactions, " +
"NoOfRefundTransactions, " +
"NoOfVoidTransactions, " +
"NoOfRewardPointsPayment, " +
"NoOfTotalTransactions, " +
"NoOfConsignmentTransactions, " +
"NoOfConsignmentRefundTransactions, " +
"NoOfWalkInTransactions, " +
"NoOfWalkInRefundTransactions, " +
"NoOfOutOfStockTransactions, " +
"NoOfOutOfStockRefundTransactions, " +
"ConsignmentSales, " +
"ConsignmentRefundSales, " +
"WalkInSales, " +
"WalkInRefundSales, " +
"OutOfStockSales, " +
"OutOfStockRefundSales, " +
"CashCount, " +
"LastLoginDate " +
"FROM tblCashierReportHistory " +
"WHERE BranchID = @BranchID AND TerminalNo = @TerminalNo AND CashierID = @CashierID;";
cmd.Parameters.AddWithValue("@BranchID", BranchID);
cmd.Parameters.AddWithValue("@TerminalNo", TerminalNo);
cmd.Parameters.AddWithValue("@CashierID", CashierID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
CashierReportDetails Details = CashierReports.SetDetails(dt);
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
