public void BindRechargeOperator()
{
//ddlOperator.Items.Add(new ListItem("Select", "-1", true));
//ddlOperator.Items.Insert(0, new ListItem("---Please Select---", "-1"));
ddlOperator.Items.Add("Add New");
clsFramework objFramework = new clsFramework();
SqlParameter[] parameters =
{
new SqlParameter("@ServiceType", SqlDbType.VarChar)
{
Value = "prepaid"
}
};
DataTable dt = objFramework.GetRecordSet("adv_proc_BindOperator", CommandType.StoredProcedure, parameters);
ddlOperator.DataTextField = "operatorname";
ddlOperator.DataValueField = "opratorcode";
ddlOperator.DataSource = dt;
ddlOperator.DataBind();
//if (ddlOperator != null)
//{
// SqlParameter[] parameters1 ={};
// foreach (ListItem li in ddlOperator.Items)
// {
// DataTable dtimage = objFramework.GetRecordSet("Select OperatorImage from adv_OperatorCode where opratorcode='"+li.Value+"'", CommandType.Text, parameters1);
// li.Attributes["title"] = "~/Images/OperatorImage" + dtimage.Rows[0]["OperatorImage"].ToString(); // it ll set the value of items in dropdownlist as tooltip
// }
//}
}
protected void btnPayment_Click(object sender, EventArgs e)
{
try
{
btnPayment.Text = "waiting..";
btnPayment.Enabled = false;
clsFramework objFramework = new clsFramework();
SqlParameter[] parameters = {};
string a = string.Empty;
decimal WAmount = 0;
if (chkWallet.Checked == true)
{
WAmount = Convert.ToDecimal(hdnWalletAmount.Value);
if (Convert.ToDecimal(hdnRechargeAmount.Value) < WAmount)
{
WAmount = WAmount = Convert.ToDecimal(hdnRechargeAmount.Value);
}
}
objFramework.ExecuteNonQuery("update adv_Operator_APIResponse set CouponCode='" + txtCouponCode.Text.Trim() + "',WalletAmount='" + WAmount.ToString() + "' where OurOrderID='" + hdnOrderID.Value + "' ", CommandType.Text, parameters);
if (WAmount >= Convert.ToDecimal(hdnRechargeAmount.Value))
{
Session["OrderID"] = hdnOrderID.Value;
Response.Redirect("ResponseHandling.aspx");
}
else
{
AllowpaymetGateWay(WAmount);
}
}
catch (Exception ex)
{ }
}
public void BindOperatorImage(string operatorName)
{
clsFramework objFramework = new clsFramework();
SqlParameter[] parameters1 = { };
DataTable dtimage = objFramework.GetRecordSet("Select OperatorImage from adv_OperatorCode where operatorname='" + operatorName + "'", CommandType.Text, parameters1);
ImgOperator.ImageUrl = "~/Images/OperatorImage/" + dtimage.Rows[0]["OperatorImage"].ToString();
}
public void RefundMoneyToBank(string OrderID)
{
try
{
clsFramework objFramework = new clsFramework();
SqlParameter[] parameters = { };
objFramework.ExecuteNonQuery("update adv_PaymentGatewayTransaction set TransactionStatus=3 where CashOnShopOrderID='" + OrderID + "'", CommandType.Text, parameters);
}
catch (Exception ex)
{ }
}
public void BindRechargecircle()
{
clsFramework objFramework = new clsFramework();
SqlParameter[] parameters =
{
};
DataTable dt = objFramework.GetRecordSet("adv_proc_BindCircle", CommandType.StoredProcedure, parameters);
ddlCircle.DataTextField = "CircleName";
ddlCircle.DataValueField = "CircleCode";
ddlCircle.DataSource = dt;
ddlCircle.DataBind();
}
private DataTable GetEamilsList(int from, int to)
{
clsFramework objFramework = new clsFramework();
DataTable dt = new DataTable();
SqlParameter[] parameters =
{
new SqlParameter("@MailStartFrom", SqlDbType.Int)
{
Value = Convert.ToInt32(from)
},
new SqlParameter("@MailCount", SqlDbType.Int)
{
Value = Convert.ToInt32(to)
}
};
dt = objFramework.GetRecordSet("Adv_Proc_SendMail", CommandType.StoredProcedure, parameters);
return(dt);
}
public UserDetails[] BindRechargeOrders(string PageIndex)
{
MembershipUser mu = Membership.GetUser();
clsFramework objFramework = new clsFramework();
SqlParameter[] parameters =
{
new SqlParameter("@PageIndex", SqlDbType.VarChar)
{
Value = PageIndex
},
new SqlParameter("@PageSize", SqlDbType.VarChar)
{
Value = 10
},
new SqlParameter("@CashOnShopUserID", SqlDbType.VarChar)
{
Value = mu.ProviderUserKey.ToString()
}
};
DataTable dt = new DataTable();
//DataTable data = objFramework.GetRecordSet("select ourorderid,Service,Amount,SuccessStatus,operatorName,Time from adv_Operator_APIResponse A inner join adv_OperatorCode B on A.Operator=B.OperatorCodeName where A.CashOnShopUserID='"+mu.ProviderUserKey.ToString()+"'", CommandType.Text, parameters);
DataTable data = objFramework.GetRecordSet("usp_proc_GetOrdersPageWise", CommandType.StoredProcedure, parameters);
List <UserDetails> details = new List <UserDetails>();
foreach (DataRow dtrow in data.Rows)
{
UserDetails user = new UserDetails();
user.operatorName = dtrow["operatorName"].ToString();
user.SuccessStatus = dtrow["SuccessStatus"].ToString();
user.Amount = dtrow["Amount"].ToString();
user.ourorderid = dtrow["ourorderid"].ToString();
user.Time = dtrow["Time"].ToString();
user.RefundStatus = dtrow["RefundStaus"].ToString();
user.RefundProcess = dtrow["RefundProcess"].ToString();
user.Mobile = dtrow["Service"].ToString();
user.OperatorImage = dtrow["OperatorImage"].ToString();
details.Add(user);
}
return(details.ToArray());
}
public static UserDetails[] GetCaskBackdetailForUser(string PageIndex)
{
MembershipUser mu = Membership.GetUser();
clsFramework objFramework = new clsFramework();
SqlParameter[] parameters =
{
new SqlParameter("@PageIndex", SqlDbType.VarChar)
{
Value = PageIndex
},
new SqlParameter("@PageSize", SqlDbType.VarChar)
{
Value = 2
},
new SqlParameter("@CashOnShopUserID", SqlDbType.VarChar)
{
Value = mu.ProviderUserKey.ToString()
}
};
DataTable dt = new DataTable();
DataTable data = objFramework.GetRecordSet("adv_PROC_CashBackHistory", CommandType.StoredProcedure, parameters);
List <UserDetails> details = new List <UserDetails>();
foreach (DataRow dtrow in data.Rows)
{
UserDetails user = new UserDetails();
user.operatorName = dtrow["OperatorName"].ToString();
user.RechargeType = dtrow["RechargeType"].ToString();
user.Mobile = dtrow["Mobile"].ToString();
user.RechargeAmount = dtrow["RechargeAmount"].ToString();
user.CouponCode = dtrow["CouponCode"].ToString();
user.OrderID = dtrow["OrderID"].ToString();
user.CashBackAmount = dtrow["CashBackAmount"].ToString();
user.Status = dtrow["Status"].ToString();
user.CreatedDate = dtrow["CreatedDate"].ToString();
details.Add(user);
}
return(details.ToArray());
}
public void CalculateWalletAmount()
{
clsFramework objFramework = new clsFramework();
MembershipUser mu = Membership.GetUser();
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.VarChar)
{
Value = mu.ProviderUserKey.ToString()
}
};
DataTable dt = objFramework.GetRecordSet("Adv_WalletHistory_New", CommandType.StoredProcedure, parameters);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
lblWalletAmount.Text = " Rs. " + Convert.ToString(dt.Rows[0]["ConfirmAmount"]);
}
}
}
public string RechargeAndBillpayment(string OrderID, string PaymentGatewayTransactionID, DataTable dtRecord)
{
clsFramework objFramework = new clsFramework();
string mess = string.Empty;
#region Find Operator Code
SqlParameter[] parametersOperator = { };
DataTable dtOperator = new DataTable();
string operatorcodeName = Convert.ToString(dtRecord.Rows[0]["operator"]);
//dtOperator = objFramework.GetRecordSet("select opratorcode,operatorname,operatorCodename from adv_OperatorCode where Activestatus =1 and serviceType='" + Convert.ToString(dtRecord.Rows[0]["RechargeType"]) + "' and opratorcode='" + Convert.ToString(dtRecord.Rows[0]["operator"]) + "' ", CommandType.Text, parametersOperator);
//if (dtOperator != null)
//{
// if (dtOperator.Rows.Count > 0)
// operatorcodeName = dtOperator.Rows[0]["operatorCodename"].ToString();
//}
#endregion
SqlParameter[] parameters = { };
WebClient client = new WebClient();
//string OrderID = string.Empty;
//DataTable dtMaxID = objFramework.GetRecordSet("select isnull(max(APIResponseID),0)+1 from adv_Operator_APIResponse", CommandType.Text, parameters);
//OrderID = dtMaxID.Rows[0][0].ToString().PadLeft(6, '1');
Int64 uniqueID = DateTime.Now.Ticks;
string API = string.Empty;
if (Convert.ToString(dtRecord.Rows[0]["RechargeType"]).ToLower() == "prepaid")
{
API = "https://joloapi.com/api/recharge.php?mode=1&userid=cashonshop&key=899388873156283&operator=" + operatorcodeName + "&service=" + Convert.ToString(dtRecord.Rows[0]["Service"]) + "&amount=" + Convert.ToString(dtRecord.Rows[0]["Amount"]) + "&orderid=" + OrderID + "&type=text";
}
else if (Convert.ToString(dtRecord.Rows[0]["RechargeType"]).ToLower() == "postpaid")
{
API = "https://joloapi.com/api/cbill.php?mode=1&userid=cashonshop&key=899388873156283&operator=" + operatorcodeName + "&service=" + Convert.ToString(dtRecord.Rows[0]["Service"]) + "&amount=" + Convert.ToString(dtRecord.Rows[0]["Amount"]) + "&orderid=" + OrderID + "&type=text";
}
var dotd = client.DownloadString(API);
DataTable dt = new DataTable();
if (dotd.Split(',').Length == 2)
{
dt = objFramework.GetRecordSet("SELECT ErrorCode, ErrorDetail, Status FROM adv_OperatorErrorCode where isnull(Status,1) =1 and ErrorCode='" + dotd.Split(',')[1].ToString() + "' ", CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
mess = dt.Rows[0]["ErrorDetail"].ToString();
}
objFramework.ExecuteNonQuery("update adv_Operator_APIResponse set SuccessStatus='" + dotd.Split(',')[0].ToString() + "',ErrorCode='" + dotd.Split(',')[1].ToString() + "',PaymentGatewayTransactionID='" + PaymentGatewayTransactionID + "',Time=getdate() where ourOrderID='" + OrderID + "'", CommandType.Text, parameters);
//if Payment gateway transaction is successfull but mobile recharge failed then call for refund
}
else if (dotd.Split(',').Length > 2)
{
MembershipUser mu = Membership.GetUser();
string[] data = dotd.Split(',');
if (data[7].ToString() == string.Empty)
{
DataTable dtDispute = new DataTable();
string uri1 = "https://joloapi.com/api/dispute.php?userid=cashonshop&key=899388873156283&servicetype=1&txn=" + data[0].ToString() + "&type=text";
var dotd1 = client.DownloadString(uri1);
objFramework.ExecuteNonQuery("update adv_Operator_APIResponse set JoloOrderID='" + data[0].ToString() + "',SuccessStatus='" + dotd1[0].ToString() + "',ErrorCode='" + data[6].ToString() + "',OperatorID='" + data[7].ToString() + "',Balance='" + data[8].ToString() + "',Margin='" + data[9].ToString() + "',Time='" + data[10].ToString() + "',PaymentGatewayTransactionID='" + PaymentGatewayTransactionID + "' where ourOrderID='" + OrderID + "' ", CommandType.Text, parameters);
mess = "Waiting For Operator Confirmation.";
}
else
{
//objFramework.ExecuteNonQuery("insert into adv_Operator_APIResponse(CashOnShopUserID,JoloOrderID,SuccessStatus,Operator,Service,Amount,OurOrderID,ErrorCode,OperatorID,Balance,Margin,Time,WalletAmount,PaymentGatewayTransactionID)values('" + mu.ProviderUserKey.ToString() + "','" + data[0].ToString() + "','" + data[1].ToString() + "','" + data[2].ToString() + "','" + data[3].ToString() + "','" + data[4].ToString() + "','" + data[5].ToString() + "','" + data[6].ToString() + "','" + data[7].ToString() + "','" + data[8].ToString() + "','" + data[9].ToString() + "','" + data[10].ToString() + "','" + WalletAmt + "','" + PaymentGatewayTransactionID + "')", CommandType.Text, parameters);
objFramework.ExecuteNonQuery("update adv_Operator_APIResponse set JoloOrderID='" + data[0].ToString() + "',SuccessStatus='" + data[1].ToString() + "',ErrorCode='" + data[6].ToString() + "',OperatorID='" + data[7].ToString() + "',Balance='" + data[8].ToString() + "',Margin='" + data[9].ToString() + "',Time='" + data[10].ToString() + "',PaymentGatewayTransactionID='" + PaymentGatewayTransactionID + "' where ourOrderID='" + OrderID + "'", CommandType.Text, parameters);
mess = "Transaction Completed Successfully.";
}
}
return(mess);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string[] merc_hash_vars_seq;
string merc_hash_string = string.Empty;
string merc_hash = string.Empty;
string order_id = string.Empty;
string hash_seq = "key|txnid|amount|productinfo|firstname|email|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10";
clsFramework objFrame = new clsFramework();
SqlParameter[] parametersNew = { };
DataTable dt = new DataTable();
if (Request.Form["status"] == "success")
{
dt = objFrame.GetRecordSet("select Time, operator,Service,Amount,WalletAmount,RechargeType,OperatorName,OperatorImage from adv_Operator_APIResponse A inner join adv_OperatorCode B on A.Operator=B.OperatorCodeName where OurOrderID='" + Convert.ToString(Request.Form["udf1"]) + "'", CommandType.Text, parametersNew);
decimal rechAmount = Convert.ToDecimal(dt.Rows[0]["Amount"]) - Convert.ToDecimal(dt.Rows[0]["WalletAmount"]);
merc_hash_vars_seq = hash_seq.Split('|');
Array.Reverse(merc_hash_vars_seq);
merc_hash_string = ConfigurationManager.AppSettings["SALT"] + "|" + Request.Form["status"];
foreach (string merc_hash_var in merc_hash_vars_seq)
{
merc_hash_string += "|";
merc_hash_string = merc_hash_string + (Request.Form[merc_hash_var] != null ? Request.Form[merc_hash_var] : "");
}
merc_hash = Generatehash512(merc_hash_string).ToLower();
if (merc_hash != Request.Form["hash"])
{
//Response.Write("Hash value did not matched");
}
else
{
order_id = Request.Form["txnid"];
clsFramework objFramework = new clsFramework();
MembershipUser mu = Membership.GetUser();
SqlParameter[] parameters =
{
new SqlParameter("@CashOnShopUserID", SqlDbType.VarChar)
{
Value = mu.ProviderUserKey.ToString()
},
new SqlParameter("@GatewayTransactionID", SqlDbType.VarChar)
{
Value = order_id
},
new SqlParameter("@ProductInfo", SqlDbType.VarChar)
{
Value = Convert.ToString(Request.Form["productinfo"])
},
new SqlParameter("@RechargeType", SqlDbType.VarChar)
{
Value = dt.Rows[0]["RechargeType"].ToString()
},
new SqlParameter("@OperatorCode", SqlDbType.VarChar)
{
Value = dt.Rows[0]["operator"].ToString()
},
new SqlParameter("@MobileOrDTH", SqlDbType.VarChar)
{
Value = dt.Rows[0]["Service"].ToString()
},
new SqlParameter("@AmountPaid", SqlDbType.VarChar)
{
Value = rechAmount.ToString()
},
new SqlParameter("@TransactionStatus", SqlDbType.VarChar)
{
Value = "1"
},
new SqlParameter("@CashOnShopOrderID", SqlDbType.VarChar)
{
Value = Convert.ToString(Request.Form["udf1"])
}
};
objFramework.ExecuteNonQuery("adv_Proc_PaymentGatewayTransaction", CommandType.StoredProcedure, parameters);
lblmsg.Text = RechargeAndBillpayment(Convert.ToString(Request.Form["udf1"]), order_id, dt);
//Response.Write("value matched");
//Details
if (dt != null)
{
if (dt.Rows.Count > 0)
{
lblTransationNo.Text = Convert.ToString(Request.Form["udf1"]);
lblOrderNo.Text = Convert.ToString(Request.Form["udf1"]);
lblWalletAmount.Text = Convert.ToString(dt.Rows[0]["WalletAmount"]);
lblTransationAmount.Text = Convert.ToString(Convert.ToDecimal(dt.Rows[0]["Amount"]) - Convert.ToDecimal(dt.Rows[0]["WalletAmount"]));
lblTotalAmount.Text = Convert.ToString(dt.Rows[0]["Amount"]);
lblAmount.Text = Convert.ToString(dt.Rows[0]["Amount"]);
lblTime.Text = Convert.ToString(dt.Rows[0]["Time"]);
pImage.ImageUrl = "~/Images/OperatorImage/" + dt.Rows[0]["OperatorImage"].ToString();
if (Convert.ToString(dt.Rows[0]["RechargeType"]).ToLower() == "prepaid")
{
lblRechargeMessage.Text = "Recharge of " + Convert.ToString(dt.Rows[0]["OperatorName"]) + " Mobile " + Convert.ToString(dt.Rows[0]["Service"]) + " For Amount Rs. " + Convert.ToString(dt.Rows[0]["Amount"]);
}
else if (Convert.ToString(dt.Rows[0]["RechargeType"]).ToLower() == "postpaid")
{
lblRechargeMessage.Text = "Bill Payment of " + Convert.ToString(dt.Rows[0]["OperatorName"]) + " Mobile " + Convert.ToString(dt.Rows[0]["Service"]) + " For Amount Rs. " + Convert.ToString(dt.Rows[0]["Amount"]);
}
}
}
//End details
}
}
else if (Request.Form["status"] == null)
{
dt = objFrame.GetRecordSet("select Time, operator,Service,Amount,WalletAmount,RechargeType,OperatorName,OperatorImage from adv_Operator_APIResponse A inner join adv_OperatorCode B on A.Operator=B.OperatorCodeName where OurOrderID='" + Convert.ToString(Session["OrderID"]) + "'", CommandType.Text, parametersNew);
//Details
if (dt != null)
{
if (dt.Rows.Count > 0)
{
lblTransationNo.Text = Convert.ToString(Session["OrderID"]);
lblOrderNo.Text = Convert.ToString(Session["OrderID"]);
lblWalletAmount.Text = Convert.ToString(dt.Rows[0]["WalletAmount"]);
lblTransationAmount.Text = Convert.ToString(Convert.ToDecimal(dt.Rows[0]["Amount"]) - Convert.ToDecimal(dt.Rows[0]["WalletAmount"]));
lblTotalAmount.Text = Convert.ToString(dt.Rows[0]["Amount"]);
lblAmount.Text = Convert.ToString(dt.Rows[0]["Amount"]);
lblTime.Text = Convert.ToString(dt.Rows[0]["Time"]);
pImage.ImageUrl = "~/Images/OperatorImage/" + dt.Rows[0]["OperatorImage"].ToString();
if (Convert.ToString(dt.Rows[0]["RechargeType"]).ToLower() == "prepaid")
{
lblRechargeMessage.Text = "Recharge of " + Convert.ToString(dt.Rows[0]["OperatorName"]) + " Mobile " + Convert.ToString(dt.Rows[0]["Service"]) + " For Amount Rs. " + Convert.ToString(dt.Rows[0]["Amount"]);
}
else if (Convert.ToString(dt.Rows[0]["RechargeType"]).ToLower() == "postpaid")
{
lblRechargeMessage.Text = "Bill Payment of " + Convert.ToString(dt.Rows[0]["OperatorName"]) + " Mobile " + Convert.ToString(dt.Rows[0]["Service"]) + " For Amount Rs. " + Convert.ToString(dt.Rows[0]["Amount"]);
}
}
}
//End details
lblmsg.Text = RechargeAndBillpayment(Convert.ToString(Session["OrderID"]), "", dt);
//Session.Remove("mobile");
//Session.Remove("OperatorCode");
//Session.Remove("RechAmount");
Session.Remove("OrderID");
}
else
{
//Details
dt = objFrame.GetRecordSet("select Time, operator,Service,Amount,WalletAmount,RechargeType,OperatorName,OperatorImage from adv_Operator_APIResponse A inner join adv_OperatorCode B on A.Operator=B.OperatorCodeName where OurOrderID='" + Convert.ToString(Request.Form["udf1"]) + "'", CommandType.Text, parametersNew);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
lblTransationNo.Text = Convert.ToString(Request.Form["udf1"]);
lblOrderNo.Text = Convert.ToString(Request.Form["udf1"]);
lblWalletAmount.Text = Convert.ToString(dt.Rows[0]["WalletAmount"]);
lblTransationAmount.Text = Convert.ToString(Convert.ToDecimal(dt.Rows[0]["Amount"]) - Convert.ToDecimal(dt.Rows[0]["WalletAmount"]));
lblTotalAmount.Text = Convert.ToString(dt.Rows[0]["Amount"]);
lblAmount.Text = Convert.ToString(dt.Rows[0]["Amount"]);
lblTime.Text = Convert.ToString(dt.Rows[0]["Time"]);
pImage.ImageUrl = "~/Images/OperatorImage/" + dt.Rows[0]["OperatorImage"].ToString();
if (Convert.ToString(dt.Rows[0]["RechargeType"]).ToLower() == "prepaid")
{
lblRechargeMessage.Text = "Recharge of " + Convert.ToString(dt.Rows[0]["OperatorName"]) + " Mobile " + Convert.ToString(dt.Rows[0]["Service"]) + " For Amount Rs. " + Convert.ToString(dt.Rows[0]["Amount"]);
}
else if (Convert.ToString(dt.Rows[0]["RechargeType"]).ToLower() == "postpaid")
{
lblRechargeMessage.Text = "Bill Payment of " + Convert.ToString(dt.Rows[0]["OperatorName"]) + " Mobile " + Convert.ToString(dt.Rows[0]["Service"]) + " For Amount Rs. " + Convert.ToString(dt.Rows[0]["Amount"]);
}
}
}
//End details
//Response.Write("Hash value did not matched");
lblmsg.Text = "Transaction Failed";
//osc_redirect(osc_href_link(FILENAME_CHECKOUT, 'payment' , 'SSL', null, null,true));
order_id = Request.Form["txnid"];
clsFramework objFramework = new clsFramework();
MembershipUser mu = Membership.GetUser();
decimal rechAmount = Convert.ToDecimal(dt.Rows[0]["Amount"]) - Convert.ToDecimal(dt.Rows[0]["WalletAmount"]);
SqlParameter[] parameters =
{
new SqlParameter("@CashOnShopUserID", SqlDbType.VarChar)
{
Value = mu.ProviderUserKey.ToString()
},
new SqlParameter("@GatewayTransactionID", SqlDbType.VarChar)
{
Value = order_id
},
new SqlParameter("@ProductInfo", SqlDbType.VarChar)
{
Value = Convert.ToString(Request.Form["productinfo"])
},
new SqlParameter("@RechargeType", SqlDbType.VarChar)
{
Value = dt.Rows[0]["RechargeType"].ToString()
},
new SqlParameter("@OperatorCode", SqlDbType.VarChar)
{
Value = dt.Rows[0]["operator"].ToString()
},
new SqlParameter("@MobileOrDTH", SqlDbType.VarChar)
{
Value = dt.Rows[0]["Service"].ToString()
},
new SqlParameter("@AmountPaid", SqlDbType.VarChar)
{
Value = rechAmount.ToString()
},
new SqlParameter("@TransactionStatus", SqlDbType.VarChar)
{
Value = "2"
},
new SqlParameter("@CashOnShopOrderID", SqlDbType.VarChar)
{
Value = Convert.ToString(Request.Form["udf1"])
}
};
objFramework.ExecuteNonQuery("adv_Proc_PaymentGatewayTransaction", CommandType.StoredProcedure, parameters);
SqlParameter[] parameters1 = { };
objFramework.ExecuteNonQuery("update adv_Operator_APIResponse set SuccessStatus='Pament Failed',PaymentGatewayTransactionID='" + order_id + "' where ourOrderID='" + Convert.ToString(Request.Form["udf1"]) + "'", CommandType.Text, parameters1);
}
}
catch (Exception ex)
{
//Response.Write("<span style='color:red'>" + ex.Message + "</span>");
litMessage.Text = ex.Message;
//Response.Redirect("~/Security.ashx");
}
}
public CommonService()
{
objFramework = new clsFramework();
//Uncomment the following line if using designed components
//InitializeComponent();
}
protected void Button1_Click(object sender, EventArgs e)
{
clsFramework objFramework = new clsFramework();
DataTable dt = new DataTable();
SqlParameter[] parameters =
{
new SqlParameter("@MailStartFrom", SqlDbType.Int)
{
Value = Convert.ToInt32(txtSendMail.Text.Trim())
},
new SqlParameter("@MailCount", SqlDbType.Int)
{
Value = Convert.ToInt32(txtMailCount.Text.Trim())
}
};
dt = objFramework.GetRecordSet("Adv_Proc_SendMail", CommandType.StoredProcedure, parameters);
string SendMail = string.Empty;
using (Ad_ConnectionString model = new Ad_ConnectionString())
{
if (ddlTemplateType.SelectedValue == Constants.MailFormatContentType.ImageContent.ToString())
{
Int16 mailFormatType = Convert.ToInt16(Constants.MailFormatContentType.ImageContent);
var contentMail = (from pro in model.Adv_MailContents
where pro.MailType == mailFormatType
select pro).SingleOrDefault();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MailSender.SendHtmlFormattedEmail(txtSubject.Text.Trim(), dt.Rows[i]["SubscribeEmail"].ToString(), contentMail.MailContent.ToString(), Constants.FromAddress.Info);
Thread.Sleep(3000);
//SendMail = SendMail + dt.Rows[i]["SubscribeEmail"].ToString() + ",";
}
SendMail = SendMail.TrimEnd(',');
}
}
lblmsg.Text = "Send";
}
else if (ddlTemplateType.SelectedValue == Constants.MailFormatContentType.OfferContent.ToString())
{
Int16 mailFormatType = Convert.ToInt16(Constants.MailFormatContentType.OfferContent);
var contentMail = (from pro in model.Adv_MailContents
where pro.MailType == mailFormatType
select pro).SingleOrDefault();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MailSender.SendHtmlFormattedEmail(txtSubject.Text.Trim(), dt.Rows[i]["SubscribeEmail"].ToString(), contentMail.MailContent.ToString(), Constants.FromAddress.Info);
Thread.Sleep(3000);
//SendMail = SendMail + dt.Rows[i]["SubscribeEmail"].ToString() + ",";
}
SendMail = SendMail.TrimEnd(',');
}
}
lblmsg.Text = "Send";
}
}
}
