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