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_GSSAccStaement(SqlConnection conn, DataSet dsGSSAccSt, string sGSSAcc, string sCName, string sCAdd, string sCId, string sCContactNo) { InitializeComponent(); if (!string.IsNullOrEmpty(Convert.ToString(sCName))) { sCustName = Convert.ToString(sCName); } if (!string.IsNullOrEmpty(Convert.ToString(sCId))) { sCustId = Convert.ToString(sCId); } if (!string.IsNullOrEmpty(sCAdd)) { sCustAddress = Convert.ToString(sCAdd); } if (!string.IsNullOrEmpty(sCContactNo)) { sContactNo = Convert.ToString(sCContactNo); } 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); } sGSSAccNumber = sGSSAcc; connection = conn; if (connection.State == ConnectionState.Closed) { connection.Open(); } GetGSSAccInfo(sGSSAcc, connection); dsGSSAccStatement = new DataSet(); dsGSSAccStatement = dsGSSAccSt; for (int i = 0; i <= dsGSSAccStatement.Tables[0].Rows.Count - 1; i++) { dTotAmt = dTotAmt + Convert.ToDecimal(dsGSSAccStatement.Tables[0].Rows[i]["Amount"]); } sAmountInWords = oBlank.Amtinwds(Convert.ToDouble(Math.Abs(dTotAmt))); sCompanyName = oBlank.GetCompanyName(conn);//aded on 14/04/2014 R.Hossain sGSSDueDays = Convert.ToString(GSSDueDays()); GetCustomData(dsGSSAccStatement.Tables[0]); }
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 }