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"; } } }