private void SetCompanyRecords(string companyID)
{
query = " Select ProductID,MerchantID,MerchantAuthkey,TransactionTypeID,TransactionAuthkey " +
"From CompanyIOPayerMaster Where CompanyID='" + this.hfCompanyID.Value.Trim() + "'";
dtCompanyIOMaster = objDbutility.BindDataTable(query);
if (dtCompanyIOMaster.Rows.Count > 0)
{
txtProductID.Text = Convert.ToString(dtCompanyIOMaster.Rows[0]["ProductID"]);
txtMerchantID.Text = Convert.ToString(dtCompanyIOMaster.Rows[0]["MerchantID"]);
txtMerchantAuthkey.Text = Convert.ToString(dtCompanyIOMaster.Rows[0]["MerchantAuthkey"]);
txtTransactionTypeID.Text = Convert.ToString(dtCompanyIOMaster.Rows[0]["TransactionTypeID"]);
txtTransactionAuthkey.Text = Convert.ToString(dtCompanyIOMaster.Rows[0]["TransactionAuthkey"]);
}
}
private void ViewRecord(string i)
{
query = " Select PaymentGatewayID,ProductID,MerchantID,MerchantAuthkey,TransactionTypeID,TransactionAuthkey " +
"From PaymentGatewayIOPayer Where PaymentGatewayID=" + i;
dtPaymentGatewayIO = objDbutility.BindDataTable(query);
if (dtPaymentGatewayIO?.Rows.Count > 0)
{
this.hfPaymentGateway.Value = this.dtPaymentGatewayIO.Rows[0]["PaymentGatewayID"].ToString();
this.lblProductID.Text = this.dtPaymentGatewayIO.Rows[0]["ProductID"].ToString();
this.lblMerchantID.Text = this.dtPaymentGatewayIO.Rows[0]["MerchantID"].ToString();
this.lblMerchantAuthkey.Text = this.dtPaymentGatewayIO.Rows[0]["MerchantAuthkey"].ToString();
this.lblTransactionTypeID.Text = this.dtPaymentGatewayIO.Rows[0]["TransactionTypeID"].ToString();
this.lblTransactionAuthkey.Text = this.dtPaymentGatewayIO.Rows[0]["TransactionAuthkey"].ToString();
}
else
{
return;
}
}
protected void btnDisplay_Click(object sender, EventArgs e)
{
try
{
if (objDbutility.ReturnNumericValue("Select Count(*) From CustomerMaster Where ACCNO='" + Accno.Value.Trim().Replace("'", "''") + "' ") > 0)
{
int CustomerID = objDbutility.ReturnNumericValue("Select CustomerID From CustomerMaster Where ACCNO='" + Accno.Value.Trim().Replace("'", "''") + "' ");
if (CustomerID == 0)
{
return;
}
DataTable dtCust = new DataTable();
dtCust = objDbutility.BindDataTable("Select * From CustomerMaster Where CustomerID='" + CustomerID + "'");
foreach (DataRow row in dtCust.Rows)
{
string gender = row["Sex"].ToString();
if (gender == "F")
{
genderF.Checked = true;
genderM.Checked = false;
}
else
{
genderF.Checked = false;
genderM.Checked = true;
}
firstname.Value = row["FirstName"].ToString();
middlename.Value = row["MiddleName"].ToString();
lastname.Value = row["LastName"].ToString();
txtDOB.Value = row["DateOfBirth"].ToString();
email.Value = row["EmailID"].ToString();
FatherName.Value = row["FatherName"].ToString();
panNo.Value = row["PanNo"].ToString();
balance.Value = row["Balance"].ToString();
Accno.Value = row["ACCNO"].ToString();
}
}
else
{
lblMessage.Text = "Account No. Is Invalid!";
//ClientScript.RegisterStartupScript(this.GetType(), "myModal", "ShowPopup();", true);
ShowMessage("Account No. Is Invalid!", MessageType.Warning);
}
}
catch (Exception ex)
{
ShowMessage("Something went wrong, zplease contact support!", MessageType.Error);
}
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
if (user != null)
{
string str = user.ToString();
if (Roles.IsUserInRole(str, "Admin"))
{
this.objCompanyLoginMasterDT = this.objCompanyLoginMasterBll.GetDataByCompanyLoginName(str);
if (this.objCompanyLoginMasterDT.Rows.Count > 0)
{
this.hfCompanyID.Value = this.objCompanyLoginMasterDT.Rows[0]["CompanyID"].ToString();
}
}
else if (Roles.IsUserInRole(str, "Employee"))
{
this.objStaffMasterDT = this.objStaffMasterBll.GetDataByStaffUserName(str);
if (this.objStaffMasterDT.Rows.Count > 0)
{
this.hfCompanyID.Value = this.objStaffMasterDT.Rows[0]["CompanyID"].ToString();
}
}
Dbutility objDbutility = new Dbutility();
query = string.Format("SELECT CloudPackageID,CloudPackageName,CloudPackagePriceMonthly,CloudPackagePriceYearly,CloudPackageCurrency FROM CloudPackageMaster " +
" Where CloudPackageID={0}", this.Request.QueryString["id"]);
dtCloudPackageMaster = objDbutility.BindDataTable(query);
if (dtCloudPackageMaster?.Rows.Count > 0)
{
hCloudPackageType.Value = Convert.ToString(dtCloudPackageMaster.Rows[0]["CloudPackageName"]);
if (this.Request.QueryString["type"] == "M")
{
amount = Convert.ToString(dtCloudPackageMaster.Rows[0]["CloudPackagePriceMonthly"]);
lblPaymentAmount.Text = String.Format("{0:0.00}", dtCloudPackageMaster.Rows[0]["CloudPackagePriceMonthly"]);
}
else
{
amount = Convert.ToString(dtCloudPackageMaster.Rows[0]["CloudPackagePriceMonthly"]);
lblPaymentAmount.Text = String.Format("{0:0.00}", dtCloudPackageMaster.Rows[0]["CloudPackagePriceYearly"]);
}
lblPaymentAmount.Text = String.Format("{0} {1}", GetCurrency(Convert.ToString(dtCloudPackageMaster.Rows[0]["CloudPackageCurrency"])),
lblPaymentAmount.Text);
}
}
}
protected void btnPay_Click(object sender, ImageClickEventArgs e)
{
string str1 = "https://www.paypal.com/cgi-bin/webscr?cmd=_xclick";
this.objCompanyPaypalMasterDT = this.objCompanyPaypalMasterBll.GetDataByCompanyID(Convert.ToInt32(this.hfCompanyID.Value));
if (this.objCompanyPaypalMasterDT.Rows.Count > 0)
{
int num = (this.Request.QueryString["type"] == "Y") ? 365 : 30;
query = String.Format("SELECT COMPANYID FROM COMPANYPACKAGEMASTER WHERE COMPANYID={0}; ", this.hfCompanyID.Value);
dtCloudPackageMaster = objDbutility.BindDataTable(query);
if (dtCloudPackageMaster?.Rows.Count > 0)
{
query = " Update c Set c.CloudPackageID={1},c.PackageStartDate='{2}',c.PackageEndDate='{3}',c.PackageType='{4}', " +
" c.PackageAmount={5},c.PackagePaymentTransDetail='{6}',c.PackagePaymentTransDate='{7}',c.PackageAssignDate='{8}',c.ActivePackage='{9}' " +
" From CompanyPackageMaster c Where c.CompanyID={0}; ";
}
else
{
query = "Insert Into CompanyPackageMaster (CompanyID,CloudPackageID,PackageStartDate,PackageEndDate, " +
"PackageType,PackageAmount,PackagePaymentTransDetail,PackagePaymentTransDate,PackageAssignDate, ActivePackage) " +
" Select {0},{1},'{2}','{3}','{4}',{5},'{6}','{7}','{8}','{9}' ";
}
query = string.Format(query, this.hfCompanyID.Value, this.Request.QueryString["id"], new DateTime?(DateTime.Now), new DateTime?(DateTime.Now.AddDays((double)num)),
hCloudPackageType.Value, new Decimal?(Decimal.Parse(amount)), "Pay by PayPal", new DateTime?(DateTime.Now), new DateTime?(DateTime.Now), true);
objDbutility.ExecuteQuery(query);
string invoiceno = DateTime.Now.ToString("dd MM yyyy HH:mm:ss");
invoiceno = invoiceno.Replace(":", string.Empty);
invoiceno = Regex.Replace(invoiceno, "\\s", string.Empty);
string str2 = str1 + (object)"&business=" + (string)this.objCompanyPaypalMasterDT.Rows[0]["PaypalID"];
str2 = str2 + "&item_name=invoice no: " + invoiceno;
if (!string.IsNullOrEmpty(amount))
{
str2 = str2 + "&amount=" + amount;
}
this.Response.Redirect(str2 + "&return=" + ConfigurationManager.AppSettings["SuccessClientURL"] + "&cancel_return=" + ConfigurationManager.AppSettings["FailedClientURL"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
if (user != null)
{
query = user.ToString();
if (Roles.IsUserInRole(query, "Admin"))
{
this.objCompanyLoginMasterDT = this.objCompanyLoginMasterBll.GetDataByCompanyLoginName(query);
if (this.objCompanyLoginMasterDT.Rows.Count > 0)
{
companyId = this.objCompanyLoginMasterDT.Rows[0]["CompanyID"].ToString();
}
}
else if (Roles.IsUserInRole(query, "Employee"))
{
this.objStaffMasterDT = this.objStaffMasterBll.GetDataByStaffUserName(query);
if (this.objStaffMasterDT.Rows.Count > 0)
{
companyId = this.objStaffMasterDT.Rows[0]["CompanyID"].ToString();
}
}
query = string.Format("SELECT CloudPackageID,CloudPackageName,CloudPackagePriceMonthly,CloudPackagePriceYearly FROM CloudPackageMaster " +
" Where CloudPackageID={0}", this.Request.QueryString["id"]);
dtCloudPackageMaster = objDbutility.BindDataTable(query);
if (dtCloudPackageMaster?.Rows.Count > 0)
{
if (this.Request.QueryString["type"] == "M")
{
amount = String.Format("{0:0.00}", dtCloudPackageMaster.Rows[0]["CloudPackagePriceMonthly"]);
}
else
{
amount = String.Format("{0:0.00}", dtCloudPackageMaster.Rows[0]["CloudPackagePriceYearly"]);
}
int num = (this.Request.QueryString["type"] == "Y") ? 365 : 30;
query = String.Format("SELECT COMPANYID FROM COMPANYPACKAGEMASTER WHERE COMPANYID={0}; ", companyId);
dtCompanyPackageMaster = objDbutility.BindDataTable(query);
if (dtCompanyPackageMaster?.Rows.Count > 0)
{
query = " Update c Set c.CloudPackageID={1},c.PackageStartDate='{2}',c.PackageEndDate='{3}',c.PackageType='{4}', " +
" c.PackageAmount={5},c.PackagePaymentTransDetail='{6}',c.PackagePaymentTransDate='{7}',c.PackageAssignDate='{8}',c.ActivePackage='{9}' " +
" From CompanyPackageMaster c Where c.CompanyID={0}; ";
}
else
{
query = "Insert Into CompanyPackageMaster (CompanyID,CloudPackageID,PackageStartDate,PackageEndDate, " +
"PackageType,PackageAmount,PackagePaymentTransDetail,PackagePaymentTransDate,PackageAssignDate, ActivePackage) " +
" Select {0},{1},'{2}','{3}','{4}',{5},'{6}','{7}','{8}','{9}' ";
}
query = string.Format(query, companyId, this.Request.QueryString["id"], new DateTime?(DateTime.Now), new DateTime?(DateTime.Now.AddDays((double)num)),
Convert.ToString(dtCloudPackageMaster.Rows[0]["CloudPackageName"]), new Decimal?(Decimal.Parse(amount))
, "Pay by Billtransact", new DateTime?(DateTime.Now), new DateTime?(DateTime.Now), true);
objDbutility.ExecuteQuery(query);
}
}
var request = (HttpWebRequest)WebRequest.Create("http://www.iopayer.com/iopg/IOPayerPaymentGateway.aspx");
objDbutility = new Dbutility();
string str = " Select ProductID,MerchantID,MerchantAuthkey,TransactionTypeID,TransactionAuthkey From PaymentGatewayIOPayer Where PaymentGatewayID=1";
DataTable dtIOPayerMaster = objDbutility.BindDataTable(str);
if (dtIOPayerMaster?.Rows.Count > 0)
{
str = Convert.ToString(dtIOPayerMaster.Rows[0]["MerchantID"]);
string postData = "MerchantID=" + Uri.EscapeDataString(str);
str = Convert.ToString(dtIOPayerMaster.Rows[0]["ProductID"]);
postData += "&ProductID=" + Uri.EscapeDataString(str);
str = Convert.ToString(dtIOPayerMaster.Rows[0]["TransactionTypeID"]);
postData += "&TransactionTypeID=" + Uri.EscapeDataString(str);
str = Convert.ToString(dtIOPayerMaster.Rows[0]["MerchantAuthkey"]);
postData += "&MerchantAuthKey=" + Uri.EscapeDataString(str);
str = Convert.ToString(dtIOPayerMaster.Rows[0]["TransactionAuthkey"]);
postData += "&TranAuthKey=" + Uri.EscapeDataString(str);
postData += "&OrderAmount=" + Uri.EscapeDataString(amount);
postData += "&ReturnURL=" + Uri.EscapeDataString(ConfigurationManager.AppSettings["SuccessClientURL"]);
string invoiceno = DateTime.Now.ToString("dd MM yyyy HH:mm:ss");
invoiceno = invoiceno.Replace(":", string.Empty);
invoiceno = Regex.Replace(invoiceno, "\\s", string.Empty);
postData += "&OrderNo=" + Uri.EscapeDataString(invoiceno);
var data = Encoding.ASCII.GetBytes(postData);
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = data.Length;
using (var stream = request.GetRequestStream())
{
stream.Write(data, 0, data.Length);
}
Response.Clear();
var response = (HttpWebResponse)request.GetResponse();
var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
string strResultnew = responseString.Replace("./IOPayerPaymentGateway.aspx", "http://www.iopayer.com/iopg/IOPayerPaymentGateway.aspx");
Response.Write(strResultnew);
return;
}
else
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(),
"<script language=\"JavaScript\">" + "alert('IO Payer Master detail not found!');" + "</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string invoiceId = InvoiceIOPayment.Decrypt(HttpUtility.UrlDecode(this.Request.QueryString["invoice"]), this.Request.QueryString["val"]);
objInvoiceMasterDT = objInvoiceMasterBLL.GetDataByInvoiceID(Convert.ToInt32(invoiceId));
if (objInvoiceMasterDT?.Rows.Count > 0)
{
var request = (HttpWebRequest)WebRequest.Create("http://www.iopayer.com/iopg/IOPayerPaymentGateway.aspx");
string str = Convert.ToString(objInvoiceMasterDT.Rows[0]["CompanyID"]);
if (!string.IsNullOrEmpty(str))
{
Dbutility objDbutility = new Dbutility();
str = " Select ProductID,MerchantID,MerchantAuthkey,TransactionTypeID,TransactionAuthkey " +
"From CompanyIOPayerMaster Where CompanyID=" + str;
DataTable dtCompanyIOMaster = objDbutility.BindDataTable(str);
if (dtCompanyIOMaster.Rows.Count > 0)
{
string MerchantID = Convert.ToString(dtCompanyIOMaster.Rows[0]["MerchantID"]);
string ProductID = Convert.ToString(dtCompanyIOMaster.Rows[0]["ProductID"]);
string TransactionTypeID = Convert.ToString(dtCompanyIOMaster.Rows[0]["TransactionTypeID"]);
string MerchantAuthKey = Convert.ToString(dtCompanyIOMaster.Rows[0]["MerchantAuthkey"]);
string TranAuthKey = Convert.ToString(dtCompanyIOMaster.Rows[0]["TransactionAuthkey"]);
string ReturnURL = ConfigurationManager.AppSettings["SuccessClientURL"];
string ExtraParam1 = "";
string ExtraParam2 = "";
string ExtraParam3 = "";
string invoiceno = DateTime.Now.ToString("dd MM yyyy HH:mm:ss");
invoiceno = invoiceno.Replace(":", string.Empty);
invoiceno = Regex.Replace(invoiceno, "\\s", string.Empty);
invoiceno += Convert.ToString(objInvoiceMasterDT.Rows[0]["InvoiceNumber"]) + "BT";
str = "Update InvoiceMaster Set OrderNo='" + invoiceno + "' Where InvoiceID=" + invoiceId;
objDbutility.ExecuteQuery(str);
var postData = "MerchantID=" + Uri.EscapeDataString(MerchantID);
postData += "&ProductID=" + Uri.EscapeDataString(ProductID);
postData += "&TransactionTypeID=" + Uri.EscapeDataString(TransactionTypeID);
postData += "&MerchantAuthKey=" + Uri.EscapeDataString(MerchantAuthKey);
postData += "&TranAuthKey=" + Uri.EscapeDataString(TranAuthKey);
postData += "&OrderAmount=" + Uri.EscapeDataString(Convert.ToString(objInvoiceMasterDT.Rows[0]["InvoiceTotal"]));
postData += "&ReturnURL=" + Uri.EscapeDataString(ReturnURL);
postData += "&OrderNo=" + Uri.EscapeDataString(invoiceno);
postData += "&ExtraParam1=" + Uri.EscapeDataString(ExtraParam1);
postData += "&ExtraParam2=" + Uri.EscapeDataString(ExtraParam2);
postData += "&ExtraParam3=" + Uri.EscapeDataString(ExtraParam3);
var data = Encoding.ASCII.GetBytes(postData);
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = data.Length;
using (var stream = request.GetRequestStream())
{
stream.Write(data, 0, data.Length);
}
Response.Clear();
var response = (HttpWebResponse)request.GetResponse();
var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
string strResultnew = responseString.Replace("./IOPayerPaymentGateway.aspx", "http://www.iopayer.com/iopg/IOPayerPaymentGateway.aspx");
Response.Write(strResultnew);
return;
}
else
{
Response.Redirect("~/Client/InvoiceNoPayment.aspx?companyid=" + Convert.ToString(objInvoiceMasterDT.Rows[0]["CompanyID"]));
}
}
}
else
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(),
"<script language=\"JavaScript\">" + "alert('Invoice details not found!');" + "</script>");
}
}
}