public void PrintApprovalVoucher(string sOrderNo, DataTable dtItemdetails, IPosTransaction posTransaction, string Title, DataTable dtIngr = null)
{
//PageSettings ps = new PageSettings { Landscape = false, PaperSize = new PaperSize { RawKind = (int)PaperKind.A4 }, Margins = new Margins { Top = 0, Right = 0, Bottom = 0, Left = 0 } };
sCurrencySymbol = oBlank.GetCurrencySymbol();
//datasources
List <ReportDataSource> rds = new List <ReportDataSource>();
rds.Add(new ReportDataSource("HEADERINFO", (DataTable)GetHeaderInfo(sOrderNo)));
//dtItemDetails = dtItemdetails;
//rds.Add(new ReportDataSource("DETAILSINFO", (DataTable)GetDetailInfo(sOrderNo, dtItemdetails)));
rds.Add(new ReportDataSource("DETAILSINFO", (DataTable)GetDetailInfo(sOrderNo, dtItemdetails, dtIngr)));
rds.Add(new ReportDataSource("DETAILSFOOTERINFO", (DataTable)GetDetailFooterInfo(dtItemDetails_Main)));
//parameters
List <ReportParameter> rps = new List <ReportParameter>();
decimal dTotalAmt = 0;
decimal dRoweTotal = 0;
foreach (DataRow dr in dtItemDetails_Main.Rows)
{
decimal dVatAmt = 0;
if (!string.IsNullOrEmpty(Convert.ToString(dr["VATAMOUNT"])))
{
dVatAmt = Convert.ToDecimal(dr["VATAMOUNT"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dr["ROWTOTALAMOUNT"])))
{
dTotalAmt += Convert.ToDecimal(dr["ROWTOTALAMOUNT"]) + dVatAmt;
}
//dTotalAmt += Convert.ToDecimal(dr["ROWTOTALAMOUNT"]);
}
Currency = GetCurrencyText(GetHeaderInfo(sOrderNo).Rows[0]["Currency"].ToString());
string sAmtInWords = Currency + " " + Amtinwds(Math.Abs(Convert.ToDouble(dTotalAmt)));
RetailTransaction retailTrans = posTransaction as RetailTransaction;
if (retailTrans != null)
{
sCPinCode = Convert.ToString(retailTrans.Customer.PostalCode);
}
else
{
var SelectedCust = customerDataManager.GetTransactionalCustomer(GetHeaderInfo(sOrderNo).Rows[0]["CUSTACCOUNT"].ToString());
sCPinCode = SelectedCust.PostalCode;
}
string sCompanyName = GetCompanyName();
rps.Add(new ReportParameter("prmTransactionId", string.IsNullOrEmpty(posTransaction.TransactionId) ? " " : posTransaction.TransactionId, true));
rps.Add(new ReportParameter("prmTotalInWrd", string.IsNullOrEmpty(sAmtInWords) ? " " : sAmtInWords, true));
string sDate = string.Empty;
rps.Add(new ReportParameter("prmPinCode", string.IsNullOrEmpty(sCPinCode) ? " " : sCPinCode, true));
rps.Add(new ReportParameter("prmCompany", string.IsNullOrEmpty(sCompanyName) ? " " : sCompanyName, true));
rps.Add(new ReportParameter("prmTitle", Title, true));
rps.Add(new ReportParameter("Remarks", sRemarks, true));
if (Title == "INWARD")
{
rps.Add(new ReportParameter("prmSubTiltle", "", true));
sDate = System.DateTime.Now.ToShortDateString();
rps.Add(new ReportParameter("prmApprDt", string.IsNullOrEmpty(sDate) ? " " : sDate, true));
// rds.Add(new ReportDataSource("BARCODEIMGTABLE", (DataTable)GetBarcodeInfo(Title, "")));
rps.Add(new ReportParameter("prmBarcode", string.IsNullOrEmpty("") ? " " : "", true));
rps.Add(new ReportParameter("pIsVisibleTentative", "0", true));
}
else
{
sDate = Convert.ToString(GetHeaderInfo(sOrderNo).Rows[0]["ApprovalDate"]);
rps.Add(new ReportParameter("prmApprDt", string.IsNullOrEmpty(sDate) ? " " : sDate, true));
rps.Add(new ReportParameter("prmSubTiltle", "SUSPENSE ITEM ON APPROVAL", true));
//rds.Add(new ReportDataSource("BARCODEIMGTABLE", (DataTable)GetBarcodeInfo(Title, sOrderNo)));
rps.Add(new ReportParameter("prmBarcode", string.IsNullOrEmpty(sOrderNo) ? " " : sOrderNo, true));
rps.Add(new ReportParameter("pIsVisibleTentative", "1", true));
}
rps.Add(new ReportParameter("cs", string.IsNullOrEmpty(sCurrencySymbol) ? " " : sCurrencySymbol, true));
string reportName = @"rptApprvDeliveryNote";
//string reportName = @"Copy of rptCustOrdVoucher";
string reportPath = @"Microsoft.Dynamics.Retail.Pos.BlankOperations.Report." + reportName + ".rdlc";
//RdlcViewer rptView = new RdlcViewer("Approval Sale Voucher", reportPath, rds, rps, null,2);
//rptView.ShowDialog();
//rptView.Close();
}
public frmR_ProductAdvanceReceipt(IPosTransaction posTransaction, SqlConnection conn, string _sTransId, string _sAmt, string sTerminalId, string sGiftCardItemName = "", string sGiftCardNo = "", int iIsAdvRefund = 0, int iLanguage = 0)
{
InitializeComponent();
sTerminal = sTerminalId;
#region [Param Info]
RetailTransaction retailTrans = posTransaction as RetailTransaction;
if (retailTrans != null)
{
iInvLang = iLanguage;
if (Convert.ToString(retailTrans.Customer.Name) != string.Empty)
{
sCustName = Convert.ToString(retailTrans.Customer.Name);
}
if (!string.IsNullOrEmpty(Convert.ToString(retailTrans.Customer.CustomerId)))
{
sCustId = Convert.ToString(retailTrans.Customer.CustomerId);
}
if (Convert.ToString(retailTrans.Customer.Address) != string.Empty) //PrimaryAddress
{
sCustAddress = Convert.ToString(retailTrans.Customer.Address);
}
if (Convert.ToString(retailTrans.Customer.PostalCode) != string.Empty)
{
sCPinCode = Convert.ToString(retailTrans.Customer.PostalCode);
}
if (Convert.ToString(retailTrans.Customer.Email) != string.Empty)
{
sCustEmail = Convert.ToString(retailTrans.Customer.Email);
}
//if(Convert.ToString(retailTrans.Customer.MobilePhone) != string.Empty)
// sContactNo = Convert.ToString(retailTrans.Customer.MobilePhone);
if (!string.IsNullOrEmpty(retailTrans.Customer.Telephone))
{
sContactNo = Convert.ToString(retailTrans.Customer.Telephone);
}
//sCPanNo
//-------
if (Convert.ToString(retailTrans.TransactionId) != string.Empty)
{
sReceiptNo = _sTransId;// Convert.ToString(retailTrans.TransactionId);
sReceiptVoucherNo = retailTrans.ReceiptId;
}
sInvoiceNo = sReceiptNo;
if (retailTrans.EndDateTime != null)
{
sInvDt = retailTrans.EndDateTime.ToShortDateString();
}
if (retailTrans.EndDateTime != null)
{
sTime = retailTrans.EndDateTime.ToString("hh:mm tt"); //("HH:mm")
}
//if(retailTrans.BeginDateTime != null)
// sReceiptDate = retailTrans.BeginDateTime.ToShortDateString();
sAmount = oBlank.Amtinwds(Convert.ToDouble(_sAmt));
sAmtinwdsArabic = oBlank.AmtinwdsInArabic(Convert.ToDouble(_sAmt));
if (iInvLang == 2)
{
sAmount = sAmtinwdsArabic;
}
else if (iInvLang == 3)
{
sAmount = sAmount + System.Environment.NewLine + "" + sAmtinwdsArabic;
}
sCurrencySymbol = oBlank.GetCurrencySymbol();
string sAdJustItem = AdjustmentItemID();
string ItemTaxCode = getTaxGropCode(sAdJustItem);
dTaxPct = getTaxPctValue(ItemTaxCode); //getItemTaxPercentage();// ;
decimal dAmt = decimal.Round(Convert.ToDecimal(_sAmt), 2, MidpointRounding.AwayFromZero); //Convert.ToDecimal(_sAmt);
dTaxAmt = decimal.Round(Convert.ToDecimal(dAmt * dTaxPct / (100 + dTaxPct)), 2, MidpointRounding.AwayFromZero);
dExcludTaxAmt = dAmt - dTaxAmt;
if (string.IsNullOrEmpty(sGiftCardItemName))
{
sFooterText = "Request to handover Advance Receipt at the time of billing";
sRTitle = "Advance Receipt" + " " + "وصل بالدفعة المسبقة";
sDetailsLine = "Received with thanks from " + "" + sCustName + " " + sCurrencySymbol + " " + _sAmt;
}
else if (iIsAdvRefund == 1)
{
sFooterText = "";
sRTitle = "Advance Refund";
sDetailsLine = "Advance Refund" + " " + sCurrencySymbol + " " + _sAmt;
}
else
{
sFooterText = "";
sRTitle = "GIFT CARD RECEIPT";
sDetailsLine = sGiftCardItemName + " " + sGiftCardNo + " " + sCurrencySymbol + " " + _sAmt;
}
//----------store Info
//if(Convert.ToString(retailTrans.StoreName) != string.Empty)
// sStoreName = Convert.ToString(retailTrans.StoreName);
//if(Convert.ToString(retailTrans.StoreAddress) != string.Empty)
// sStoreAddress = Convert.ToString(retailTrans.StoreAddress);
//if (! string.IsNullOrEmpty(Convert.ToString(retailTrans.StorePhone)))
// sStorePhNo = Convert.ToString(retailTrans.StorePhone);
if (Convert.ToString(ApplicationSettings.Terminal.StoreName) != string.Empty)
{
sStoreName = Convert.ToString(ApplicationSettings.Terminal.StoreName);
}
if (Convert.ToString(ApplicationSettings.Terminal.StoreAddress) != string.Empty)
{
sStoreAddress = Convert.ToString(ApplicationSettings.Terminal.StoreAddress);
}
if (!string.IsNullOrEmpty(Convert.ToString(ApplicationSettings.Terminal.StorePhone)))
{
sStorePhNo = Convert.ToString(ApplicationSettings.Terminal.StorePhone);
}
if (Convert.ToString(retailTrans.OperatorId) != string.Empty)
{
sOperatorId = getStaffName(Convert.ToString(retailTrans.OperatorId));
}
sDataAreaId = Convert.ToString(ApplicationSettings.Database.DATAAREAID);
// if (Convert.ToString(retailTrans.InventLocationId) != string.Empty)
sInventLocationId = ApplicationSettings.Terminal.InventLocationId; //Convert.ToString(retailTrans.InventLocationId);
}
connection = conn;
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
GetStoreInfo(ref sStorePhNo, ref sInvoiceFooter, ref sCINNo);
//sCINNo = oBlank.getValue("select CINNO from RETAILSTORETABLE where STORENUMBER ='" + Convert.ToString(ApplicationSettings.Terminal.StoreId) + "'");
sCompanyName = oBlank.GetCompanyName(conn);//aded on 14/04/2014 R.Hossain
if (iIsAdvRefund == 1)
{
sRefRceiptNo = GetRefReciptId(retailTrans.TransactionId);
}
sRemarks = getTransactionRemarks(retailTrans.TransactionId, retailTrans.TerminalId);
sStorePhNo = getStoreEmailAndFax("PRIMARYCONTACTPHONE");
sStoreEmail = getStoreEmailAndFax("PrimaryContactEmail");
sStoreFax = getStoreEmailAndFax("PrimaryContactFax"); // PrimaryContactEmail/PrimaryContactFax
sTRN = GetCompanyTRN();
//sCurrencySymbol = ApplicationSettings.Terminal.StoreCurrency;
#endregion
}
public frmR_GSSInstalmentReceipt(IPosTransaction posTransaction, SqlConnection conn, string _sTransId, string _sAmt, string sGSSAccNo, string sTerminalId)
{
InitializeComponent();
sTerminal = sTerminalId;
#region [Param Info]
RetailTransaction retailTrans = posTransaction as RetailTransaction;
if (retailTrans != null)
{
if (Convert.ToString(retailTrans.Customer.Name) != string.Empty)
{
sCustName = Convert.ToString(retailTrans.Customer.Name);
}
if (!string.IsNullOrEmpty(Convert.ToString(retailTrans.Customer.CustomerId)))
{
sCustId = Convert.ToString(retailTrans.Customer.CustomerId);
}
if (Convert.ToString(retailTrans.Customer.Address) != string.Empty) //PrimaryAddress
{
sCustAddress = Convert.ToString(retailTrans.Customer.Address);
}
if (Convert.ToString(retailTrans.Customer.PostalCode) != string.Empty)
{
sCPinCode = Convert.ToString(retailTrans.Customer.PostalCode);
}
//if(Convert.ToString(retailTrans.Customer.MobilePhone) != string.Empty)
// sContactNo = Convert.ToString(retailTrans.Customer.MobilePhone);
if (!string.IsNullOrEmpty(retailTrans.Customer.Telephone))
{
sContactNo = Convert.ToString(retailTrans.Customer.Telephone);
}
//sCPanNo
sCurrencySymbol = oBlank.GetCurrencySymbol();
//-------
if (Convert.ToString(retailTrans.TransactionId) != string.Empty)
{
sReceiptNo = _sTransId;// Convert.ToString(retailTrans.TransactionId);
sReceiptVoucherNo = retailTrans.ReceiptId;
}
if (Convert.ToString(sReceiptVoucherNo) == string.Empty)
{
sReceiptVoucherNo = GetReciptVouNo(_sTransId, conn);
}
//if(retailTrans.BeginDateTime != null)
// sReceiptDate = retailTrans.BeginDateTime.ToShortDateString();
sAmount = oBlank.Amtinwds(Convert.ToDouble(_sAmt));
sDetailsLine = "Received with thanks from " + "" + sCustName + " " + sCurrencySymbol + " " + _sAmt;
//----------store Info
GetGSSMaturityDate(sGSSAccNo, conn); // added on 29/03/2014 req by Sailendra da. dev by R.Hossain
//if(Convert.ToString(retailTrans.StoreName) != string.Empty)
// sStoreName = Convert.ToString(retailTrans.StoreName);
//if(Convert.ToString(retailTrans.StoreAddress) != string.Empty)
// sStoreAddress = Convert.ToString(retailTrans.StoreAddress);
////if(Convert.ToString(retailTrans.StorePhone) != string.Empty)
//if (!string.IsNullOrEmpty(Convert.ToString(retailTrans.StorePhone)))
// sStorePhNo = Convert.ToString(retailTrans.StorePhone);
if (Convert.ToString(ApplicationSettings.Terminal.StoreName) != string.Empty)
{
sStoreName = Convert.ToString(ApplicationSettings.Terminal.StoreName);
}
if (Convert.ToString(ApplicationSettings.Terminal.StoreAddress) != string.Empty)
{
sStoreAddress = Convert.ToString(ApplicationSettings.Terminal.StoreAddress);
}
if (!string.IsNullOrEmpty(Convert.ToString(ApplicationSettings.Terminal.StorePhone)))
{
sStorePhNo = Convert.ToString(ApplicationSettings.Terminal.StorePhone);
}
sDataAreaId = Convert.ToString(ApplicationSettings.Database.DATAAREAID);
//if(Convert.ToString(retailTrans.InventLocationId) != string.Empty)
// sInventLocationId = Convert.ToString(retailTrans.InventLocationId);
sInventLocationId = ApplicationSettings.Terminal.InventLocationId;
}
connection = conn;
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
GetStoreInfo(ref sStorePhNo, ref sInvoiceFooter, ref sCINNo);
sCompanyName = oBlank.GetCompanyName(conn); //aded on 14/04/2014 R.Hossain
sGSSAccNumber = sGSSAccNo; // added on 18/04/2014
#endregion
}