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 }