public static DataTable GetVoucherTable(RedemptionInfoCollection VoucherList)
{
XmlSerializer XmlSerializer = new XmlSerializer(typeof(RedemptionInfoCollection));
MemoryStream stream = new MemoryStream();
XmlSerializer.Serialize(stream, VoucherList);
stream.Position = 0;
DataSet DataSet = new DataSet();
DataSet.ReadXml(stream);
return DataSet.Tables[0];
}
/// <summary>
/// This method is used to Redeem voucher.
/// </summary>
/// <param name="Info"></param>
/// <param name="UserID"></param>
public static void RedeemVouchers(RedemptionInfoCollection RedemData, string UserID)
{
try
{
clsParameterCollection ParameterCollection = new clsParameterCollection();
ParameterCollection.ProcedureName = "BS_Redemption_Redeem";
ParameterCollection.Add(new clsParameter("@RedeempedBy", UserID));
ParameterCollection.Add(new clsParameter("@VoucherNo", GetVoucherTable(RedemData)));
//ParameterCollection.Add(new clsParameter("@VoucherNo", VocuherNo));
//ParameterCollection.Add(new clsParameter("@RedeempedBy", UserID));
//DataAccess.ExecuteNonQuerySp(ParameterCollection);
}
catch (Exception Ex)
{
if (!Ex.Message.Contains("User Define:"))
BL_Exception.WriteLog(Ex);
throw Ex;
}
}