Exemplo n.º 1
0
        public static bool fcnCashLinqRepeatSale(long _lngCTID, long _lngRecordID, decimal _decAmt, string _strPNRefIn, ref string _strReturnedPNRef, ref string _strAuthNumber)
        {
            string strCQUserID = "";
            string strUserType = "";
            string strUserKey = "";

            bool blnRes = false;

            string strCustomQWSUserName = "";
            string strCustomQWSPW = "";
            string strCustomQMerchantID = "";

            strCustomQWSUserName = clsAppSettings.GetAppSettings().strCashLinqCQUser;
            strCustomQWSPW = clsAppSettings.GetAppSettings().strCashLinqCQPW;
            strCustomQMerchantID = clsAppSettings.GetAppSettings().strCashLinqCQMerchantID;

            string strResXML = "";

            using (wsCashLinq.CQ wsCLCQ = new global::CTWebMgmt.wsCashLinq.CQ())
            {
                //login to service
                using (DataSet dsLoginRes = new DataSet())
                {
                    strResXML = wsCLCQ.MerchLogin(strCustomQWSUserName, strCustomQWSPW, strCustomQMerchantID);

                    dsLoginRes.ReadXml(new System.IO.MemoryStream(System.Text.Encoding.ASCII.GetBytes(strResXML)));

                    try
                    {
                        strCQUserID = dsLoginRes.Tables[0].Rows[0]["UID"].ToString();
                        strUserType = dsLoginRes.Tables[0].Rows[0]["UType"].ToString();
                        strUserKey = dsLoginRes.Tables[0].Rows[0]["UserKey"].ToString();
                    }
                    catch
                    {
                        strCQUserID = "";
                        strUserType = "";
                        strUserKey = "";
                    }
                }

                wsCashLinq.Response wsCLResponse = new global::CTWebMgmt.wsCashLinq.Response();

                wsCLResponse = wsCLCQ.RepeatSale(Convert.ToInt64(strCQUserID), Convert.ToByte(strUserType), strUserKey, Convert.ToInt32(_strPNRefIn), _decAmt, DateTime.Now);

                string strRespMsg = "";

                strRespMsg = wsCLResponse.RespMSG;
                _strReturnedPNRef = wsCLResponse.PNRef;
                _strAuthNumber = wsCLResponse.AuthCode;

                if (strRespMsg.ToUpper() != "Approved".ToUpper())
                    blnRes = false;
                else
                    blnRes = true;
            }

            return blnRes;
        }
        private bool fcnGetCashLinqTrans(DateTime _dteStart, DateTime _dteEnd)
        {
            bool blnRes = false;

            try
            {
                string strCQUserID = "";
                string strUserType = "";
                string strUserKey = "";

                //need to be looked up from db
                string strCustomQWSUserName = clsAppSettings.GetAppSettings().strCashLinqCQUser;
                string strCustomQWSPW = clsAppSettings.GetAppSettings().strCashLinqCQPW;
                string strCustomQMerchantID = clsAppSettings.GetAppSettings().strCashLinqCQMerchantID;

                string strResXML = "";

                using (wsCashLinq.CQ wsCLCQ = new global::CTWebMgmt.wsCashLinq.CQ())
                {
                    //login to get cquserid
                    using (DataSet dsLoginRes = new DataSet())
                    {
                        strResXML = wsCLCQ.MerchLogin(strCustomQWSUserName, strCustomQWSPW, strCustomQMerchantID);

                        try { dsLoginRes.ReadXml(new System.IO.MemoryStream(System.Text.Encoding.ASCII.GetBytes(strResXML))); }
                        catch { }

                        try
                        {
                            strCQUserID = dsLoginRes.Tables[0].Rows[0]["UID"].ToString();
                            strUserType = dsLoginRes.Tables[0].Rows[0]["UType"].ToString();
                            strUserKey = dsLoginRes.Tables[0].Rows[0]["UserKey"].ToString();
                        }
                        catch
                        {
                            strCQUserID = "";
                            strUserType = "";
                            strUserKey = "";
                        }
                    }

                    wsCashLinq.Response wsCLResp = new global::CTWebMgmt.wsCashLinq.Response();

                    string strPageName = "";
                    string strRes = "";

                    if (radAllCTTrans.Checked || radUnmatched.Checked || radCTWeb.Checked)
                    {
                        if (clsAppSettings.GetAppSettings().lngCTUserID == 876299671)
                            strPageName = "CTPmtPageAlt_" + clsAppSettings.GetAppSettings().lngCTUserID.ToString();
                        else
                            strPageName = "CTPmtPage_" + clsAppSettings.GetAppSettings().lngCTUserID.ToString();

                        strRes = wsCLCQ.GetReconciled(Convert.ToInt64(strCQUserID), Convert.ToByte(strUserType), strUserKey, strPageName, _dteStart, _dteEnd);

                        if (strRes == "Invalid Login")
                        {
                            MessageBox.Show("Invalid CashLinq credentials.\nIn CampTrak select Administration-->Set Defaults to update your CashLinq CustomQ user name and password.");
                            return false;
                        }

                        blnRes = fcnAddCashLinqTrans(strRes, "Web Module");
                    }

                    if (blnRes || radCTLocal.Checked)
                    {
                        if (clsAppSettings.GetAppSettings().lngCTUserID == 876299671)
                            strPageName = "LocalTranAlt_" + clsAppSettings.GetAppSettings().lngCTUserID.ToString();
                        else
                            strPageName = "LocalTran_" + clsAppSettings.GetAppSettings().lngCTUserID.ToString();

                        strRes = wsCLCQ.GetReconciled(Convert.ToInt64(strCQUserID), Convert.ToByte(strUserType), strUserKey, strPageName, _dteStart, _dteEnd);

                        blnRes = fcnAddCashLinqTrans(strRes, "Local App");

                    }

                    //eliminate matched transactions from data set if needed
                    if (radUnmatched.Checked)
                    {
                        string strSQL = "";

                        using (OleDbConnection conDB = new OleDbConnection(clsAppSettings.GetAppSettings().strCTConn))
                        {
                            conDB.Open();

                            strSQL = "DROP VIEW qryMerchantTransSummary";

                            using (OleDbCommand cmdDB = new OleDbCommand(strSQL, conDB))
                            {
                                try { cmdDB.ExecuteNonQuery(); }
                                catch { }

                                strSQL = "DROP VIEW qryMerchantGiftSummary";

                                cmdDB.CommandText = strSQL;
                                cmdDB.Parameters.Clear();

                                try { cmdDB.ExecuteNonQuery(); }
                                catch { }

                                strSQL = "CREATE VIEW qryMerchantTransSummary AS " +
                                            "SELECT Count(tblTransactions.lngTransactionID) AS CountOflngTransactionID, " +
                                                "Sum(tblTransactions.curPayment) AS curTotAmt, " +
                                                "Min(tblTransactions.dteDateAdded) AS dteDateAdded, " +
                                                "tblTransactions.strPNRef " +
                                            "FROM tblTransactions " +
                                            "WHERE IIf([tblTransactions].[strPNRef] Is Null, '', [tblTransactions].[strPNRef]) <>'' AND " +
                                                "DateDiff('d', #" + _dteStart.ToShortDateString() + "#, [tblTransactions].[dteDateAdded]) >= 0 AND " +
                                                "DateDiff('d', [tblTransactions].[dteDateAdded], #" + _dteEnd.ToShortDateString() + "#) >=0 " +
                                            "GROUP BY tblTransactions.strPNRef";

                                cmdDB.CommandText = strSQL;
                                cmdDB.Parameters.Clear();

                                try { cmdDB.ExecuteNonQuery(); }
                                catch { }

                                strSQL = "CREATE VIEW qryMerchantGiftSummary AS " +
                                            "SELECT Count(tblGift.lngGiftID) AS CountOflngGiftID, " +
                                                "Sum(tblGift.curAmount) AS curTotAmt, " +
                                                "Min(tblGift.dteGiftDate) AS dteGiftDate, " +
                                                "tblGift.strPNRef " +
                                            "FROM tblGift " +
                                            "WHERE DateDiff('d', #" + _dteStart.ToShortDateString() + "#, [tblGift].[dteGiftDate]) >=0 AND " +
                                                "DateDiff('d', [tblGift].[dteGiftDate], #" + _dteEnd.ToShortDateString() + "#) >= 0 AND " +
                                                "IIf([tblGift].[strPNRef] Is Null, '', [tblGift].[strPNRef]) <> '' " +
                                            "GROUP BY tblGift.strPNRef";

                                cmdDB.CommandText = strSQL;
                                cmdDB.Parameters.Clear();

                                try { cmdDB.ExecuteNonQuery(); }
                                catch { }

                                strSQL = "DELETE tblMerchantGatewayTrans.* " +
                                        "FROM tblMerchantGatewayTrans " +
                                        "WHERE tblMerchantGatewayTrans.lngGWTransID In " +
                                            "(" +
                                                "SELECT tblMerchantGatewayTrans.lngGWTransID " +
                                                "FROM (tblMerchantGatewayTrans " +
                                                    "LEFT JOIN qryMerchantGiftSummary ON (tblMerchantGatewayTrans.strMerchantRef = qryMerchantGiftSummary.strPNRef) AND " +
                                                        "(tblMerchantGatewayTrans.decAmount = qryMerchantGiftSummary.curTotAmt)) " +
                                                    "LEFT JOIN qryMerchantTransSummary ON (tblMerchantGatewayTrans.decAmount = qryMerchantTransSummary.curTotAmt) AND " +
                                                        "(tblMerchantGatewayTrans.strMerchantRef = qryMerchantTransSummary.strPNRef) " +
                                                "WHERE qryMerchantGiftSummary.CountOflngGiftID Is Not Null OR " +
                                                    "qryMerchantTransSummary.CountOflngTransactionID Is Not Null " +
                                            ")";

                                cmdDB.CommandText = strSQL;
                                cmdDB.Parameters.Clear();

                                try { cmdDB.ExecuteNonQuery(); }
                                catch { }
                            }

                            conDB.Close();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                blnRes = false;
            }

            return blnRes;
        }
Exemplo n.º 3
0
        public static void subProcessRefundCashLinqCC(decimal _decAmt, string _strPNRef)
        {
            try
            {
                Int64 lngTransID = Convert.ToInt64(_strPNRef);
                decimal decAmt = _decAmt;
                string strReason = "Reg Cancelled";

                string strCQUserID = "";
                string strUserType = "";
                string strUserKey = "";

                //need to be looked up from db
                string strCustomQWSUserName = clsAppSettings.GetAppSettings().strCashLinqCQUser;
                string strCustomQWSPW = clsAppSettings.GetAppSettings().strCashLinqCQPW;
                string strCustomQMerchantID = clsAppSettings.GetAppSettings().strCashLinqCQMerchantID;

                string strResXML = "";

                using (wsCashLinq.CQ wsCLCQ = new global::CTWebMgmt.wsCashLinq.CQ())
                {
                    //login to get cquserid
                    using (DataSet dsLoginRes = new DataSet())
                    {
                        strResXML = wsCLCQ.MerchLogin(strCustomQWSUserName, strCustomQWSPW, strCustomQMerchantID);

                        dsLoginRes.ReadXml(new System.IO.MemoryStream(System.Text.Encoding.ASCII.GetBytes(strResXML)));

                        try
                        {
                            strCQUserID = dsLoginRes.Tables[0].Rows[0]["UID"].ToString();
                            strUserType = dsLoginRes.Tables[0].Rows[0]["UType"].ToString();
                            strUserKey = dsLoginRes.Tables[0].Rows[0]["UserKey"].ToString();
                        }
                        catch
                        {
                            strCQUserID = "";
                            strUserType = "";
                            strUserKey = "";
                        }
                    }

                    wsCashLinq.Response wsCLResp = new global::CTWebMgmt.wsCashLinq.Response();

                    wsCLResp = wsCLCQ.Refund(Convert.ToInt64(strCQUserID), Convert.ToByte(strUserType), strUserKey, lngTransID, decAmt, strReason);

                    if (wsCLResp.RespMSG.ToUpper() != "Approved".ToUpper())
                    {
                        System.Windows.Forms.MessageBox.Show("There was an error processing the refund: " + wsCLResp.RespMSG);
                    }
                }
            }
            catch (Exception ex)
            {
                System.Windows.Forms.MessageBox.Show("Error: " + ex.Message);
            }

            return;
        }