//paymet Gateway public static void PaymentResponseSave(Entity.Common.PaymentGateway payment) { using (DataManager oDm = new DataManager()) { oDm.Add("@pPaymentId", SqlDbType.Int, ParameterDirection.InputOutput, payment.PaymentId); oDm.Add("@pMemberId", SqlDbType.Int, payment.MemberId); oDm.Add("@pMemberType", SqlDbType.VarChar, 10, payment.MemberType); oDm.Add("@pOrderId", SqlDbType.VarChar, 30, payment.OrderId); if (payment.TrackingId != null && payment.TrackingId.Length > 0) { oDm.Add("@pTrackingId", SqlDbType.VarChar, 20, payment.TrackingId); } else { oDm.Add("@pTrackingId", SqlDbType.VarChar, 20, DBNull.Value); } if (payment.BankRefNo != null && payment.BankRefNo.Length > 0) { oDm.Add("@pBankRefNo", SqlDbType.VarChar, 100, payment.BankRefNo); } else { oDm.Add("@pBankRefNo", SqlDbType.VarChar, 100, DBNull.Value); } if (payment.OrderStatus != null && payment.OrderStatus.Length > 0) { oDm.Add("@pOrderStatus", SqlDbType.VarChar, 20, payment.OrderStatus); } else { oDm.Add("@pOrderStatus", SqlDbType.VarChar, 20, DBNull.Value); } if (payment.FailureMessage != null && payment.FailureMessage.Length > 0) { oDm.Add("@pFailureMessage", SqlDbType.VarChar, 500, payment.FailureMessage); } else { oDm.Add("@pFailureMessage", SqlDbType.VarChar, 500, DBNull.Value); } if (payment.PaymentMode != null && payment.PaymentMode.Length > 0) { oDm.Add("@pPaymentMode", SqlDbType.VarChar, 20, payment.PaymentMode); } else { oDm.Add("@pPaymentMode", SqlDbType.VarChar, 20, DBNull.Value); } if (payment.CardName != null && payment.CardName.Length > 0) { oDm.Add("@pCardName", SqlDbType.VarChar, 30, payment.CardName); } else { oDm.Add("@pCardName", SqlDbType.VarChar, 30, DBNull.Value); } if (payment.StatusCode != null && payment.StatusCode.Length > 0) { oDm.Add("@pStatusCode", SqlDbType.VarChar, 5, payment.StatusCode); } else { oDm.Add("@pStatusCode", SqlDbType.VarChar, 5, DBNull.Value); } if (payment.StatusMessage != null && payment.StatusMessage.Length > 0) { oDm.Add("@pStatusMessage", SqlDbType.VarChar, 300, payment.StatusMessage); } else { oDm.Add("@pStatusMessage", SqlDbType.VarChar, 300, DBNull.Value); } oDm.Add("@pPaymentAmount", SqlDbType.Decimal, payment.PaymentAmount); oDm.Add("@pCurrency", SqlDbType.VarChar, 3, payment.Currency); if (payment.PaymentDate == DateTime.MinValue) { oDm.Add("@pPaymentDate", SqlDbType.DateTime, DBNull.Value); } else { oDm.Add("@pPaymentDate", SqlDbType.DateTime, payment.PaymentDate); } oDm.Add("@pCreatedBy", SqlDbType.Int, payment.CreatedBy); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_MemberPaymentGateway_Save"); } }
protected void btnSave_Click(object sender, EventArgs e) { Message.Show = false; FeesXml = "<NewDataSet>"; foreach (GridViewRow gvr in dgvMemberOutstanding.Rows) { if (gvr.RowType == DataControlRowType.DataRow) { FeesXml += "<Row"; FeesXml += " FeesHeadId = \"" + dgvMemberOutstanding.DataKeys[gvr.RowIndex].Values["FeesHeadId"].ToString() + "\""; FeesXml += " FeesPaymentAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtFeesPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtFeesPaymentAmount")).Text.Trim()) + "\""; FeesXml += " TaxPaymentAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) + "\""; FeesXml += " />"; } } FeesXml += "</NewDataSet>"; BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); Entity.Common.MemberPayment payment = new Entity.Common.MemberPayment(); payment.PaymentId = PaymentId; payment.MemberId = Convert.ToInt32(ddlMember.SelectedValue); payment.PaymentMode = ddlPaymentMode.SelectedValue; payment.PaymentDate = Convert.ToDateTime(txtPaymentDate.Text.Split('/')[2] + "-" + txtPaymentDate.Text.Split('/')[1] + "-" + txtPaymentDate.Text.Split('/')[0]); //if (Session["UserType"].ToString().Equals("Member")) { payment.PaymentAmount = PaymentAmount; }//PaymentAmount; } //else //{ payment.PaymentAmount = Convert.ToDecimal(hdnAmount.Value.Trim()); //} payment.Narration = txtNarration.Text.Trim(); payment.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); payment.CreatedByUserType = Session["UserType"].ToString(); payment.CashBankLedgerId = Convert.ToInt32(ddlCashBankLedger.SelectedValue); payment.FeesXml = FeesXml; payment.IsExcelUpload = false; if (Session["UserType"].ToString().Equals("Admin") || Session["UserType"].ToString().Equals("Agent")) { payment.IsApproved = true; payment.ApprovedBy = Convert.ToInt32(Session["UserId"].ToString()); payment.ApprovedDate = DateTime.Now; } else { payment.IsApproved = null; payment.ApprovedBy = null; payment.ApprovedDate = null; } string strPaymentNo = objMemberPayment.Save(payment); PaymentId = 0; txtPaymentNo.Text = strPaymentNo; LoadMemberOutstandingList(); txtPaymentAmount.Text = "0.00"; txtPaymentDate.Enabled = true; txtNarration.Text = ""; LoadLedgerOpeningBalance(); btnPrint.Visible = true; Message.IsSuccess = true; Message.Text = "Payment detail saved successfully"; Message.Show = true; if (Session["UserType"].ToString().Equals("Member") && ddlPaymentMode.SelectedItem.Text.ToUpper().Equals("ONLINE PAYMENT")) { //Response.Redirect(@"https://www.onlinesbi.com/prelogin/icollecthome.htm?corpid=649959"); BusinessLayer.Common.MemberPayment ObjPayment = new BusinessLayer.Common.MemberPayment(); Entity.Common.PaymentGateway paymentGate = new Entity.Common.PaymentGateway(); paymentGate.PaymentId = payment.PaymentId; paymentGate.MemberId = payment.MemberId; paymentGate.MemberType = "Member"; paymentGate.OrderId = GetAutoTransactionId(); paymentGate.PaymentAmount = payment.PaymentAmount; paymentGate.Currency = "INR"; paymentGate.CreatedBy = payment.CreatedBy; ObjPayment.PaymentResponseSave(paymentGate);//&tid=76023071 string ccaRequest = "merchant_id=211354&order_id=" + paymentGate.OrderId + "&amount=" + payment.PaymentAmount + "¤cy=INR&" + "redirect_url=http://accounts.wbpoultryfederation.org/ccavResponseHandler.aspx&cancel_url=http://accounts.wbpoultryfederation.org/MemberDefault.aspx&"; //+ "redirect_url=http://localhost:1044/ccavResponseHandler.aspx&cancel_url=http://localhost:1044/ccavResponseHandler.aspx&"; ccaRequest += "billing_name=" + ddlMember.SelectedItem.Text + "&billing_address=46C, Chowringhee Road, 11th Floor, Room No - C&billing_city=Kolkata&billing_state=West Bengal&billing_zip=700071&billing_country=India&billing_tel=03365229085&[email protected]&" + "delivery_name=" + ddlMember.SelectedItem.Text + "&delivery_address=46C, Chowringhee Road, 11th Floor, Room No - C&delivery_city=Kolkata&delivery_state=West Bengal&delivery_zip=700071&delivery_country=India&delivery_tel=03365229085" + "&merchant_param1=" + payment.PaymentId + "&merchant_param2=" + payment.MemberId + "&merchant_param3=Member"; string strEncRequest = ccaCrypto.Encrypt(ccaRequest, workingKey); Response.Redirect("../ccavRequestHandler.aspx?DATA=" + strEncRequest); } //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "VariableRegisteration", "window.open('renewal-bill.aspx?PaymentNo=" + strPaymentNo + "','','height=600,width=1000')", true); }
//Payment Gateway public void PaymentResponseSave(Entity.Common.PaymentGateway payment) { DataAccess.Common.MemberPayment.PaymentResponseSave(payment); }
protected void Page_Load(object sender, EventArgs e) { //if (!IsPostBack) //{ //if (Request.Form["encResp"] != null && Request.Form["encResp"].Length > 0) { Response.Write("<script>alert('Payment Cancel '" + Request.Form["encResp"] + ");</script>"); } try { Message.Show = false; if (Request.Form.AllKeys.Contains("encResp")) { if (Request.Form["encResp"] != null && Request.Form["encResp"].Length > 0) { string workingKey = "FF119789EA009958AC9FF44758A5A526";// "272ECCEC820303D21327C07B92A5A367";//"FF119789EA009958AC9FF44758A5A526";//put in the 32bit alpha numeric key in the quotes provided here CCA.Util.CCACrypto ccaCrypto = new CCA.Util.CCACrypto(); string encResponse = ccaCrypto.Decrypt(Request.Form["encResp"], workingKey); NameValueCollection Params = new NameValueCollection(); string[] segments = encResponse.Split('&'); foreach (string seg in segments) { string[] parts = seg.Split('='); if (parts.Length > 0) { string Key = parts[0].Trim(); string Value = parts[1].Trim(); Params.Add(Key, Value); } } #region //string jsMethodName = ""; //for (int i = 0; i < Params.Count; i++) //{ // StringBuilder sb = new StringBuilder(); // jsMethodName+=("<tr><td class='label'>" + Params.Keys[i] + "</td><td>" + Params[i] + "</td></tr>"); // //Response.Write(Params.Keys[i] + " = " + Params[i] + "<br>"); //} //string[] values = null; //foreach (string key in Params.Keys) //{ // values = Params.GetValues(key); // foreach (string value in values) // { // //MessageBox.Show(key + " - " + value); // //if (key.Equals("order_id")) // //{ // // lblOrderId.Text = Params["order_id"]; // //} // Response.Write(key + " = " + value + "<br>"); // } //} #endregion order_id.Text = Params["order_id"]; tracking_id.Text = Params["tracking_id"]; bank_ref_no.Text = Params["bank_ref_no"]; order_status.Text = Params["order_status"]; mer_amount.Text = Params["mer_amount"]; trans_date.Text = Params["trans_date"]; failure_message.Text = Params["failure_message"]; payment_mode.Text = Params["payment_mode"]; billing_name.Text = Params["billing_name"]; //ScriptManager.RegisterClientScriptBlock(this, typeof(string), "ALert", "alert('" + jsMethodName + "')", true); Entity.Common.PaymentGateway payment = new Entity.Common.PaymentGateway(); payment.PaymentId = Convert.ToInt32(Params["merchant_param1"]); payment.MemberId = Convert.ToInt32(Params["merchant_param2"]); payment.MemberType = Params["merchant_param3"]; payment.OrderId = Params["order_id"]; payment.TrackingId = Params["tracking_id"]; payment.BankRefNo = Params["bank_ref_no"]; payment.OrderStatus = Params["order_status"]; payment.PaymentAmount = Convert.ToDecimal(Params["mer_amount"]); payment.FailureMessage = Params["failure_message"]; payment.PaymentMode = Params["payment_mode"]; string transDate = Params["trans_date"]; if (transDate != null && transDate.Length > 0) { string[] tranDate = transDate.Split(' '); string[] tranDate1 = tranDate[0].Split('/'); payment.PaymentDate = Convert.ToDateTime(tranDate1[2] + "-" + tranDate1[1] + "-" + tranDate1[0] + " " + tranDate[1]);// Params["trans_date"]); } else { payment.PaymentDate = DateTime.Now; } payment.Currency = Params["currency"]; payment.CardName = Params["card_name"]; payment.StatusCode = Params["status_code"]; payment.StatusMessage = Params["status_message"]; payment.CardName = Params["card_name"]; payment.CreatedBy = Session["UserId"] != null?Convert.ToInt32(Session["UserId"]) : 0; BusinessLayer.Common.MemberPayment ObjPayment = new BusinessLayer.Common.MemberPayment(); //DataTable DT = ObjPayment.GetAllById(payment.PaymentId); //if (Convert.ToDecimal(DT.Rows[0]["PaymentAmount"]) == payment.PaymentAmount) //{ ObjPayment.PaymentResponseSave(payment); //} //else //{ // order_status.Text = "Transaction Failed"; // failure_message.Text = "Amount is not matched"; //} if (payment.OrderStatus == "Success") { order_status.ForeColor = System.Drawing.Color.Green; Message.IsSuccess = true; Message.Text = "Payment detail saved successfully"; } else { order_status.ForeColor = System.Drawing.Color.Red; failure_message.ForeColor = System.Drawing.Color.Red; Message.IsSuccess = false; Message.Text = "Please try again later!"; } Message.Show = true; } else { Response.Write("<script>alert('Payment Cancel ');</script>"); } } else { Response.Write("<script>alert('Payment Cancel ');</script>"); } } catch (Exception ex) { Message.Text = ex.Message; Message.Show = true; } //} }