Пример #1
0
 public int addPRatio(XObjs.PRatio x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO p_ratio (xpartnerID,p_type,xratio,r_type,xreg_date,xvisible,xsync) VALUES ('" + x.xpartnerID + "','" + x.p_type + "','" + x.xratio + "','" + x.r_type + "','" + x.xreg_date + "','" + x.xvisible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #2
0
 public int addImpXpayAgent(XObjs.XAgent x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO xagent (addressID,sys_ID,xname,cname,xpassword,nationality,xreg_date,xvisible,xsync) VALUES ('" + x.addressID + "','" + x.sys_ID + "','" + x.xname + "','" + x.cname + "','" + x.xpassword + "','" + x.nationality + "','" + x.xreg_date + "','" + x.xvisible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #3
0
 public int addApplicant(XObjs.Applicant x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO applicant (xname,address,xemail,xmobile) VALUES ('" + hf.ConvertApos2Tab(x.xname) + "','" + hf.ConvertApos2Tab(x.address) + "','" + hf.ConvertApos2Tab(x.xemail) + "','" + x.xmobile + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #4
0
 public int addFee_list(XObjs.Fee_list x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO fee_list (item,item_code,qt_code,xdesc,init_amt,tech_amt,xcategory,xlogstaff,xreg_date,xvisible,xsync) VALUES ('" + x.item + "','" + x.item_code + "','" + x.qt_code + "','" + x.item + "','" + x.init_amt + "','" + x.tech_amt + "','" + x.xcategory + "','" + x.xlogstaff + "','" + x.xreg_date + "','" + x.xvisible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #5
0
 public int addFee_details(XObjs.Fee_details x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO fee_details (fee_listID,twalletID,xqty,xused,xlogstaff,tot_amt,init_amt,tech_amt,xreg_date,xvisible,xsync) VALUES ('" + x.fee_listID + "','" + x.twalletID + "','" + x.xqty + "','" + x.xused + "','" + x.xlogstaff + "','" + x.tot_amt + "','" + x.init_amt + "','" + x.tech_amt + "','" + x.xreg_date + "','" + x.xvisible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #6
0
 public int addHwallet(XObjs.Hwallet x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO hwallet (transID,fee_detailsID,used_status,xreg_date,used_date,product_title) VALUES ('" + x.transID + "','" + x.fee_detailsID + "','" + x.used_status + "','" + x.xreg_date + "','" + x.used_date + "','" + x.product_title + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #7
0
 public int addInterSwitchRecords(XObjs.InterSwitchPostFields x)
 {
     string str = "";
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     string str3 = (str + "INSERT INTO InterSwitchPostFields (product_id,amount,isw_conv_fee,currency,site_redirect_url,txn_ref,hash,mackey,pay_item_id, ") + " site_name,cust_id,cust_id_desc,cust_name,resp_desc,pay_item_name,local_date_time,MerchantReference,TransactionDate,trans_status,pay_ref, " + " ret_ref,xreg_date,xvisible,xsync) ";
     str3 = str3 + " VALUES ('" + x.product_id + "','" + x.amount + "','" + x.isw_conv_fee + "','" + x.currency + "','" + x.site_redirect_url + "','" + x.txn_ref + "','" + x.hash + "','" + x.mackey + "', ";
     str3 = str3 + "'" + x.pay_item_id + "','" + x.site_name + "','" + x.cust_id + "','" + x.cust_id_desc + "','" + x.cust_name + "','" + x.resp_desc + "','" + x.pay_item_name + "', ";
     SqlCommand command = new SqlCommand(str3 + "'" + x.local_date_time + "','" + x.TransactionDate + "','" + x.MerchantReference + "','" + x.trans_status + "','" + x.pay_ref + "','" + x.ret_ref + "','" + x.xreg_date + "','" + x.xvisible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #8
0
 public string DoPayment(XObjs.InterSwitchPostFields ispf)
 {
     this.payment_page = ConfigurationManager.AppSettings["pd_payment_page"];
     RemotePost post = new RemotePost();
     post.Add("product_id", ispf.product_id);
     post.Add("pay_item_id", ispf.pay_item_id);
     post.Add("amount", ispf.amount);
     post.Add("currency", ispf.currency);
     post.Add("site_redirect_url", ispf.site_redirect_url);
     post.Add("txn_ref", ispf.txn_ref);
     post.Add("hash", ispf.hash);
     return post.SendForm(this.payment_page, "POST").ToString();
 }
Пример #9
0
 public int addTwallet(XObjs.Twallet x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO twallet (transID,xmemberID,xmembertype,xpay_status,xgt,ref_no,xbankerID,applicantID,xreg_date,xvisible,xsync) VALUES ('" + x.transID + "','" + x.xmemberID + "','" + x.xmembertype + "','" + x.xpay_status + "','" + x.xgt + "','" + x.ref_no + "','" + x.xbankerID + "','" + x.applicantID + "','" + x.xreg_date + "','" + x.xvisible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #10
0
 public int addPwallet(XObjs.Pwallet x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO pwallet (xemail,xmobile,xmemberID,xmembertype,xpass,reg_date) VALUES ('" + x.xemail + "','" + x.xmobile + "','" + x.xmemberID + "','" + x.xmembertype + "','" + x.xpass + "','" + x.reg_date + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #11
0
        public int updateSubAgent(XObjs.Subagent x)
        {
            string command_text = "";
            command_text += "UPDATE subagents SET Firstname='" + ConvertApos2Tab(x.Firstname) + "',Surname='" + ConvertApos2Tab(x.Surname) + "' ,Email='" + ConvertApos2Tab(x.Email) + "', ";
            command_text += " xpassword='******',DateOfBrith='" + FormatDate(x.DateOfBrith) + "' ,Sys_ID='" + x.Sys_ID + "',Telephone='" + x.Telephone + "', xreg_date='" + x.xreg_date + "' ";
            command_text += " WHERE xid='" + x.xid + "'";

            string connectionString = this.ConnectXhome();
            SqlConnection connection = new SqlConnection(connectionString);
            SqlCommand command = new SqlCommand(command_text, connection);
            connection.Open();
            int succ = command.ExecuteNonQuery();
            connection.Close();
            return succ;
        }
Пример #12
0
 public int updateFee_list(XObjs.Fee_list f)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("UPDATE fee_list SET item='" + f.item + "',item_code='" + f.item_code + "',qt_code='" + f.qt_code + "',xdesc='" + f.item + "',init_amt='" + f.init_amt + "',tech_amt='" + f.tech_amt + "',xcategory='" + f.xcategory + "',xlogstaff='" + f.xlogstaff + "',xsync='" + f.xsync + "' WHERE xid='" + f.xid + "' ", connection);
     connection.Open();
     int num = command.ExecuteNonQuery();
     connection.Close();
     return num;
 }
Пример #13
0
 public int addXpayPartner(XObjs.XPartner x)
 {
     string str = "0";
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO xpartner (addressID,sys_ID,xname,cname,xpassword,nationality,xreg_date,xvisible,xsync) VALUES ('" + x.addressID + "','" + x.sys_ID + "','" + x.xname + "','" + x.cname + "','" + x.xpassword + "','" + x.nationality + "','" + x.xreg_date + "','" + x.xvisible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     if (num > 0)
     {
         str = "XP/RP/" + num.ToString().PadLeft(5, '0');
         updateXpayMember(num.ToString(), str);
     }
     return num;
 }
Пример #14
0
 public int addXpayAddress(XObjs.Address x)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("INSERT INTO address (countryID,stateID,lgaID,city,street,zip,telephone1,telephone2,email1,email2,log_staff,reg_date,visible,xsync) VALUES ('" + x.countryID + "','" + x.stateID + "','" + x.lgaID + "','" + x.city + "','" + x.street + "','" + x.zip + "','" + x.telephone1 + "','" + x.telephone2 + "','" + x.email1 + "','" + x.email2 + "','" + x.log_staff + "','" + x.reg_date + "','" + x.visible + "','" + x.xsync + "') SELECT SCOPE_IDENTITY()", connection);
     connection.Open();
     int num = Convert.ToInt32(command.ExecuteScalar());
     connection.Close();
     return num;
 }
Пример #15
0
 public SortedList<string, string> GenerateTransactionTP(List<XObjs.Bc_AccountDetails> acc_details, List<XObjs.Bc_CustomFieldDetails> customfield_details, XObjs.Bc_ItemDetails item_detials, XObjs.Bc_Merchant merchant, XObjs.Bc_TransactionDetails transaction_details, string CBankID, string BankID)
 {
     SortedList<string, string> list = new SortedList<string, string>();
     string xMLRequest = "";
     StringBuilder output = new StringBuilder();
     XmlWriterSettings settings = new XmlWriterSettings {
         Encoding = Encoding.Default,
         Indent = true
     };
     XmlWriter writer = XmlWriter.Create(output, settings);
     writer.WriteStartDocument();
     writer.WriteStartElement("BranchCollectRequest");
     writer.WriteStartElement("MerchantDetails");
     writer.WriteStartElement("Merchant");
     writer.WriteStartAttribute("DevID");
     writer.WriteValue(merchant.DevID);
     writer.WriteStartAttribute("MerchantID");
     writer.WriteValue(merchant.MerchantID);
     writer.WriteStartAttribute("MerchantCode");
     writer.WriteValue(merchant.MerchantCode);
     writer.WriteEndAttribute();
     writer.WriteEndElement();
     writer.WriteEndElement();
     writer.WriteStartElement("TransactionDetails");
     writer.WriteStartElement("Transaction");
     writer.WriteStartAttribute("TransactionID");
     writer.WriteValue(transaction_details.TransactionID);
     writer.WriteStartAttribute("MAC");
     writer.WriteValue(transaction_details.MAC);
     writer.WriteStartAttribute("TotalAmount");
     writer.WriteValue(transaction_details.TotalAmount);
     writer.WriteStartAttribute("CustomerID");
     writer.WriteValue(transaction_details.CustomerID);
     writer.WriteStartAttribute("CustomerSurname");
     writer.WriteValue(transaction_details.CustomerSurname);
     writer.WriteStartAttribute("CustomerFirstname");
     writer.WriteValue(transaction_details.CustomerFirstname);
     writer.WriteStartAttribute("CustomerOthernames");
     writer.WriteValue(transaction_details.CustomerOthernames);
     writer.WriteStartAttribute("CustomerEmail");
     writer.WriteValue(transaction_details.CustomerEmail);
     writer.WriteStartAttribute("CustomerGSM");
     writer.WriteValue(transaction_details.CustomerGSM);
     writer.WriteStartAttribute("UpdateURL");
     writer.WriteValue(transaction_details.UpdateURL);
     writer.WriteStartAttribute("UpdateURLThirdParty");
     writer.WriteValue(transaction_details.UpdateURLThirdParty);
     writer.WriteEndAttribute();
     writer.WriteEndElement();
     writer.WriteEndElement();
     writer.WriteStartElement("ItemDetails");
     writer.WriteStartAttribute("ItemDescription");
     writer.WriteValue(item_detials.ItemDescription);
     writer.WriteStartAttribute("InstallmentID");
     writer.WriteValue(item_detials.InstallmentID);
     writer.WriteStartAttribute("Split");
     writer.WriteValue(item_detials.Split);
     writer.WriteStartAttribute("ItemCode");
     writer.WriteValue(item_detials.ItemCode);
     writer.WriteStartAttribute("ExpiryDate");
     writer.WriteValue(item_detials.ExpiryDate);
     writer.WriteEndAttribute();
     foreach (XObjs.Bc_Items items in item_detials.lt_Item)
     {
         writer.WriteStartElement("Item");
         writer.WriteStartAttribute("ItemName");
         writer.WriteValue(items.ItemName);
         writer.WriteStartAttribute("ItemAmount");
         writer.WriteValue(items.ItemAmount);
         writer.WriteEndAttribute();
         writer.WriteEndElement();
     }
     writer.WriteEndElement();
     writer.WriteStartElement("CustomFieldDetails");
     foreach (XObjs.Bc_CustomFieldDetails details in customfield_details)
     {
         writer.WriteStartElement("CustomField");
         writer.WriteStartAttribute("CustomFieldLabel");
         writer.WriteValue(details.CustomFieldLabel);
         writer.WriteStartAttribute("CustomFieldValue");
         writer.WriteValue(details.CustomFieldValue);
         writer.WriteEndAttribute();
         writer.WriteEndElement();
     }
     writer.WriteEndElement();
     writer.WriteStartElement("CollectionBankDetails");
     writer.WriteStartElement("CollectionBank");
     writer.WriteStartAttribute("CBankID");
     writer.WriteValue(BankID);
     writer.WriteEndAttribute();
     writer.WriteEndElement();
     writer.WriteEndElement();
     writer.WriteStartElement("BankAccounts");
     writer.WriteStartElement("BankDetails");
     writer.WriteStartAttribute("BankID");
     writer.WriteValue(BankID);
     writer.WriteEndAttribute();
     foreach (XObjs.Bc_AccountDetails details2 in acc_details)
     {
         writer.WriteStartElement("AccountDetails");
         writer.WriteStartAttribute("AccountID");
         writer.WriteValue(details2.AccountID);
         writer.WriteStartAttribute("AccountName");
         writer.WriteValue(details2.AccountName);
         writer.WriteStartAttribute("AccountNo");
         writer.WriteValue(details2.AccountNo);
         writer.WriteStartAttribute("SplitAmount");
         writer.WriteValue(details2.SplitAmount);
         writer.WriteEndAttribute();
         writer.WriteEndElement();
     }
     writer.WriteEndElement();
     writer.WriteEndElement();
     writer.WriteEndElement();
     writer.WriteEndDocument();
     writer.Flush();
     writer.Close();
     xMLRequest = output.ToString().Replace("utf-16", "UTF-8");
     XmlTextReader reader = new XmlTextReader(new StringReader(this.bc_service.GenerateTransactionTP(xMLRequest)));
     XmlDocument document = new XmlDocument();
     document.Load(reader);
     this.RespCode = document.GetElementsByTagName("RespCode");
     this.Message = document.GetElementsByTagName("Message");
     list.Add("Response_code", this.RespCode[0].InnerText);
     list.Add("Message", this.Message[0].InnerText);
     return list;
 }
Пример #16
0
        public void sendemail(XObjs.Registration px2)
        {
            try
            {
                int port = 0x24b;

                MailMessage mail = new MailMessage();
                mail.From =
               new MailAddress("*****@*****.**", "*****@*****.**");
                // new MailAddress("*****@*****.**");
                mail.Priority = MailPriority.High;

                mail.To.Add(
            new MailAddress(px2.Email));

                //    new MailAddress("*****@*****.**"));

                //mail.CC.Add(new MailAddress("*****@*****.**"));

                mail.Subject = "Agent Accreditation Request Approved";

                mail.IsBodyHtml = true;
                String ss2 = "Dear " + px2.CompanyName + ",<br/> <br/>" + " You have successfully made payment for:   .<br/>";

                //  ss2 = ss2 + "To gain access to your account, you would need to click here <a href=\"http://88.150.164.30/IpoTest2/#/Register/" + vid + " \">click</a>   to validate your account and also make payment. " + "<br/><br/><br/>";

                ss2 = ss2 + " <table style=\"border:1px solid black;border-collapse:collapse; \"   >  <tr> <td style=\"border:1px solid black;\" > AGENT CODE </td> <td style=\"border:1px solid black;\" >" + px2.Sys_ID + "</td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" > FIRSTNAME </td> <td style=\"border:1px solid black;\" >" + px2.Firstname + "</td> </tr>";
                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" > SURNAME </td> <td style=\"border:1px solid black;\" >" + px2.Surname + "</td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" > EMAIL </td> <td style=\"border:1px solid black;\" >" + px2.Email + "</td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" > DATE OF BIRTH </td> <td style=\"border:1px solid black;\" >" + px2.DateOfBrith + "</td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" > COMPANY NAME </td> <td style=\"border:1px solid black;\" >" + px2.CompanyName + "</td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" > COMPANY ADDRESS </td> <td style=\"border:1px solid black;\" >" + px2.CompanyAddress + "</td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" > CERTIFICATE </td> <td style=\"border:1px solid black;\" ><a href=\"http://ipo.cldng.com/" + px2.Certificate + " \">Download</a> </td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" >  LETTER OF INTRODUCTION </td> <td style=\"border:1px solid black;\" ><a href=\"http://ipo.cldng.com/" + px2.Introduction + " \">Download</a> </td> </tr>";

                ss2 = ss2 + "<tr> <td style=\"border:1px solid black;\" >  PASSPORT </td> <td style=\"border:1px solid black;\" ><a href=\"http://ipo.cldng.com/" + px2.logo + " \">Download</a> </td> </tr>";

                ss2 = ss2 + "</table> <br/><br/>";

                ss2 = ss2 + "Your application will be reviewed by the accreditation panel to ensure you have met the minimum standard requirements as required by the registry. <br/>";

                ss2 = ss2 + "You will be notified on the status of your application in due course. <br/> <br/>";

                ss2 = ss2 + "Please do not reply this mail <br/> <br/>";

                ss2 = ss2 + "Live 24/7 Support: (+234) 09038979681 <br/>";

                ss2 = ss2 + "[email protected] or go online to use our live feedback form <br/><br/> ";

                ss2 = ss2 + "<b>Disclaimer:</b>This e-mail and any attachments are confidential; it must not be read, copied, disclosed or used by any person other than the above named addressees. Unauthorized use, disclosure or copying is strictly prohibited and may be unlawful. Iponigeria.com disclaims any liability for any action taken in reliance on the content of this e-mail. The comments or statements expressed in this e-mail could be personal opinions and are not necessarily those of iponigeria.com. If you have received this email in error or think you may have done so, you may not peruse, use, disseminate, distribute or copy this message. Please notify the sender immediately and delete the original e-mail from your system.";

                //ss2 = ss2 + "Please keep your password safe and do not share your log in details with anyone. You may change your password at your convenience. In the event that you cannot remember your password, kindly follow the instructions provided for password recovery."  + "<br/>";
                //ss2 = ss2 + "Please do not reply this mail" +  "<br/><br/>";
                //ss2 = ss2 + "Email: [email protected] or go online to use our live feedback form .<br/><br/>";

                String ss = "<html> <head> </head> <body>" + ss2 + "</body> </html>";

                //  mail.Body = ss;

                mail.Body = ss;

                SmtpClient client = new SmtpClient("88.150.164.30");
                //  SmtpClient client = new SmtpClient("192.168.0.12");

                client.Port = port;

                //    client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Zues.4102.Hector");

                client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Einao2015@@$");

                //   new System.Net.NetworkCredential("*****@*****.**", "welcome@123");
                //   new System.Net.NetworkCredential(q60.smtp_user, q60.smtp_password);

                client.Send(mail);

            }
            catch (Exception ee)
            {

            }
        }
Пример #17
0
        public int updateRegistration(XObjs.Registration x)
        {
            string command_text = "";
            command_text += "UPDATE registrations SET Firstname='" + ConvertApos2Tab(x.Firstname) + "',Surname='" + ConvertApos2Tab(x.Surname) + "' ,Email='" + ConvertApos2Tab(x.Email) + "', ";
            command_text += " xpassword='******',DateOfBrith='" + FormatDate(x.DateOfBrith) + "' ,IncorporatedDate='" + FormatDate(x.IncorporatedDate) + "',PhoneNumber='" + x.PhoneNumber + "', Sys_ID='" + x.Sys_ID + "', ";
            command_text += " CompanyName='" + ConvertApos2Tab(x.CompanyName) + "',CompanyAddress='" + ConvertApos2Tab(x.CompanyAddress) + "' ,ContactPerson='" + ConvertApos2Tab(x.ContactPerson) + "',ContactPersonPhone='" + x.ContactPersonPhone + "',  ";
            command_text += " CompanyWebsite='" + ConvertApos2Tab(x.CompanyWebsite) + "', xreg_date='" + x.xreg_date + "'  ";
            command_text += " WHERE xid='" + x.xid + "'";

            string connectionString = this.ConnectXhome();
            SqlConnection connection = new SqlConnection(connectionString);
            SqlCommand command = new SqlCommand(command_text, connection);
            connection.Open();
            int succ = command.ExecuteNonQuery();
            connection.Close();
            return succ;
        }
Пример #18
0
 public int updatePRatio(XObjs.PRatio f)
 {
     SqlConnection connection = new SqlConnection(hf.ConnectXpay());
     SqlCommand command = new SqlCommand("UPDATE p_ratio SET xpartnerID='" + f.xpartnerID + "',p_type='" + f.p_type + "',xratio='" + f.xratio + "',r_type='" + f.r_type + "' WHERE xid='" + f.xid + "' ", connection);
     connection.Open();
     int num = command.ExecuteNonQuery();
     connection.Close();
     return num;
 }
Пример #19
0
        public int addRegistration(XObjs.Registration x)
        {
            string command_text = "";
            string connectionString = this.ConnectXpay();
            SqlConnection connection = new SqlConnection(connectionString);
            command_text += "INSERT INTO InterSwitchPostFields (product_id,amount,isw_conv_fee,currency,site_redirect_url,txn_ref,hash,mackey,pay_item_id, ";
            command_text += " site_name,cust_id,cust_id_desc,cust_name,resp_desc,pay_item_name,local_date_time,MerchantReference,TransactionDate,trans_status,pay_ref, ";
            command_text += " ret_ref,xreg_date,xvisible,xsync) ";
            SqlCommand command = new SqlCommand(command_text, connection);
            connection.Open();
            int succ = Convert.ToInt32(command.ExecuteScalar());
            connection.Close();

            return succ;
        }
Пример #20
0
        public void sendemail(XObjs.Registration px2)
        {
            try
            {
                int port = 0x24b;

                MailMessage mail = new MailMessage();
                mail.From =
               new MailAddress("*****@*****.**", "*****@*****.**");
                // new MailAddress("*****@*****.**");
                mail.Priority = MailPriority.High;

                mail.To.Add(
            new MailAddress(px2.Email));

                //    new MailAddress("*****@*****.**"));

                //mail.CC.Add(new MailAddress("*****@*****.**"));

                mail.Subject = "Agent Accreditation Request Rejected";

                mail.IsBodyHtml = true;
                String ss2 = "Dear " + px2.CompanyName + ",<br/> <br/>" + " This is to inform you that your application has been refused!! Please contact our personnel for further details .<br/> <br/>";

                //  ss2 = ss2 + "To gain access to your account, you would need to click here <a href=\"http://88.150.164.30/IpoTest2/#/Register/" + vid + " \">click</a>   to validate your account and also make payment. " + "<br/><br/><br/>";
                ss2 = ss2 + "Please do not reply this mail. <br/> <br/>";

                ss2 = ss2 + "Email: [email protected] or go online to use our live feedback form <br/> <br/>";

                ss2 = ss2 + "<b> Disclaimer: </b>This e-mail and any attachments are confidential; it must not be read, copied, disclosed or used by any person other than the above named addressees. Unauthorized use, disclosure or copying is strictly prohibited and may be unlawful. Iponigeria.com disclaims any liability for any action taken in reliance on the content of this e-mail. The comments or statements expressed in this e-mail could be personal opinions and are not necessarily  those of iponigeria.com. If you have received this email in error or think you may have done so, you may not peruse, use, disseminate, distribute or copy this message. Please notify the sender immediately and delete the original e-mail from your system.";

                //ss2 = ss2 + "Please keep your password safe and do not share your log in details with anyone. You may change your password at your convenience. In the event that you cannot remember your password, kindly follow the instructions provided for password recovery."  + "<br/>";
                //ss2 = ss2 + "Please do not reply this mail" +  "<br/><br/>";
                //ss2 = ss2 + "Email: [email protected] or go online to use our live feedback form .<br/><br/>";

                String ss = "<html> <head> </head> <body>" + ss2 + "</body> </html>";

                //  mail.Body = ss;

                mail.Body = ss;

                SmtpClient client = new SmtpClient("88.150.164.30");
                //  SmtpClient client = new SmtpClient("192.168.0.12");

                client.Port = port;

                //    client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Zues.4102.Hector");

                client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Einao2015@@$");

                //   new System.Net.NetworkCredential("*****@*****.**", "welcome@123");
                //   new System.Net.NetworkCredential(q60.smtp_user, q60.smtp_password);

                client.Send(mail);

            }
            catch (Exception ee)
            {

            }
        }