public string ApplyCouponCode(string CouponCode)
{
PropCouponCode objProperty = new PropCouponCode();
objProperty.CouponCode = CouponCode;
string str = string.Empty;
BllCouponCode objCouponCode = new BllCouponCode();
str = objCouponCode.CheckCouponCode(objProperty);
return(str);
}
public string CheckCouponCode(PropCouponCode objCouponCode)
{
DllCouponCode objDal = new DllCouponCode();
try
{
string dd = objDal.SearchCouponcode(objCouponCode);
return(dd);
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public string SearchCouponcode(PropCouponCode objCouponCode)
{
SqlCommand cmd = new SqlCommand("proc_CouponCodeForRegistration", objCon.Con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Apply");
cmd.Parameters.AddWithValue("@CouponCode", objCouponCode.CouponCode);
SqlDataAdapter adpt = new SqlDataAdapter();
DataSet ds = new DataSet();
if (objCon.Con.State == ConnectionState.Open)
{
}
else
{
objCon.Con.Open();
}
cmd.Connection = objCon.Con;
adpt.SelectCommand = cmd;
adpt.Fill(ds, "ccsign");
objCon.Con.Close();
return(ds.GetXml());
}