Soft-Tech Solving

protected void MailSendWithCoponPdf(string Email,string Coupon)     {         using (StringWriter sw = new StringWriter())         {             using (HtmlTextWriter hw = new HtmlTextWriter(sw))             {                 string companyName = "xxxxxxxx";                 string orderNo = "#2303";                 StringBuilder sb = new StringBuilder();                 sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>");                 sb.Append("<tr><td align='center' style='background-color: #18B5F0' colspan = '2'><b>Coupon</b></td></tr>");                 sb.Append("<t...

<?xml version="1.0"?> <!--   For more information on how to configure your ASP.NET application, please visit   http://go.microsoft.com/fwlink/?LinkId=169433   --> <configuration>     <system.web>       <compilation debug="true" targetFramework="4.5" />       <httpRuntime targetFramework="4.5" />     </system.web>   <connectionStrings>     <add name="conn" connectionString="Data Source=WIN-PC\SQLEXPRESS;Initial Catalog=st_SubiTechnologies;Integrated Security=True;" providerName="System.Data.SqlClient"/>     <!--<add name="conn" connectionString="Data Source=.\SQLServer2012;Initial Catalog=st_SubiTechnologies;User Id=subi;Password=ysN9o2^6;Connect Timeout=120;" providerName="System.Data.SqlClient" />-->   </connectionStrings> </configuration>

public static int Save(string Name, string Emailid, string PhoneNo, string LaptopBrand, string Model, string SerialNo, string Description, DateTime DOE, string Coupon)     {         int n;         SqlCommand cmd = new SqlCommand();         try         {             cmd.Connection = DataConnection.Con;             cmd.CommandText = "Sp_Register_Save";             cmd.CommandType = CommandType.StoredProcedure;             cmd.Parameters.AddWithValue("@rowId", 0);             cmd.Parameters.AddWithValue("@Name", Name);             cmd.Parameters.AddWithValue("@Emailid", Emailid);             cmd.Parameters.AddWithValue("@PhoneNo", PhoneNo);            ...

USE [st_SubiTechnologies] GO /****** Object:  StoredProcedure [dbo].[Sp_Register_GetLastCoupon]    Script Date: 2/10/2017 10:56:47 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Sp_Register_GetLastCoupon] --@flag int output AS BEGIN begin transaction select top(1) Coupon from tbl_registration order by rowId desc --if @@ERROR=0 --begin -- set @flag=1 -- commit transaction --end --else --begin -- set @flag=0 -- rollback transaction --end END

USE [st_SubiTechnologies] GO /****** Object:  StoredProcedure [dbo].[Sp_Register_Save]    Script Date: 2/10/2017 10:46:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Sp_Register_Save] @rowId int, @Name varchar(300), @Emailid varchar(300), @PhoneNo varchar(20), @LaptopBrand varchar(50), @Model varchar(50), @SerialNo varchar(200), @Description varchar(700), @DOE datetime, @Coupon varchar(10), @flag int output AS BEGIN begin transaction insert into [dbo].[tbl_registration](Name,Emailid,PhoneNo,LaptopBrand,Model,SerialNo,Description,DOE,Coupon) values(@Name,@Emailid,@PhoneNo,@LaptopBrand,@Model,@SerialNo,@Description,@DOE,@Coupon) if @@ERROR=0 begin set @flag=1 commit transaction end else begin set @flag=0 rollback transaction end END

HTML Code: <!--bangk gateway-->     < a href = 'https://shopping.BANGK.com/?business_account_number=xxxxxxxxxxxxxxxxxxx&description=1&color=n%2Fa&size=%2Fa&weight=n%2Fa&price_per_item=99.00&currency_code_iso3=USD' >          Click to Buy Now     </ a >     // Replace xxxxxxxxxxxxxxxxxxx to your business_account_number of bang k gateway <!--/bangk gateway--> UI :

HTML Code: <!--GSPay gateway-->   < form   target = _new   method = post         action = "https://secure.redirect2pay.com/payment/pay.php" >       < input   type = hidden   name = "siteID"   value = "xxxxx" >   // replace xxxxx to your siteId on GSPay       < input   type = hidden   name = 'OrderDescription[1]'   value = 'PC Tuneup Software' >       < input   type = hidden   name = 'Amount[1]'   value = '10' >       < input   type = hidden   name = 'Qty[1]'   value = '1' >       < input   type = "hidden"   name = "OrderID"   value = "25Nov2008152022_25"   />       < input   type = "hidden"   name = "customerFullName"   value = "Md Boktiar Rahama...