/// <summary>
/// This method is used to convert List collection into DataSet
/// </summary>
/// <param name="VoucherDataList"></param>
/// <returns></returns>
public static DataTable GetVoucherTable(CommonVoucerInfoCollection VoucherDataList)
{
XmlSerializer XmlSerializer = new XmlSerializer(typeof(CommonVoucerInfoCollection));
MemoryStream stream = new MemoryStream();
XmlSerializer.Serialize(stream, VoucherDataList);
stream.Position = 0;
DataSet DataSet = new DataSet();
DataSet.ReadXml(stream);
return DataSet.Tables[0];
}
/// <summary>
/// This method is used to collect all entered vocuhers.
/// </summary>
/// <returns></returns>
private CommonVoucerInfoCollection GetVoucherCollection()
{
CommonVoucerInfoCollection InfoCollection = new CommonVoucerInfoCollection();
string AllVoucherId = Convert.ToString(hdnVoucherIdsValue.Value);
AllVoucherId = AllVoucherId.EndsWith(",") ? AllVoucherId.Substring(0, AllVoucherId.Length - 1) : AllVoucherId;
string[] splitAllVocuherID = AllVoucherId.Split(',');
foreach (string strVoucher in splitAllVocuherID)
{
InfoCollection.Add(new CommonVoucherInfo { VoucherNo = strVoucher });
}
return InfoCollection;
}
/// <summary>
///
/// </summary>
/// <param name="VoucherDataList"></param>
/// <param name="UserID"></param>
/// <param name="ProcedurName"></param>
/// <returns></returns>
public static DataTable CancelVoucherRandom(CommonVoucerInfoCollection VoucherDataList, string UserID, string ProcedurName)
{
try
{
clsParameterCollection ParameterCollection = new clsParameterCollection();
ParameterCollection.ProcedureName = ProcedurName;
ParameterCollection.Add(new clsParameter("@UserID", UserID));
ParameterCollection.Add(new clsParameter("@tblVoucher", GetVoucherTable(VoucherDataList)));
//DataAccess.ExecuteNonQuerySp(ParameterCollection);
return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
}
catch (Exception Ex)
{
if (!Ex.Message.Contains("User Define:"))
BL_Exception.WriteLog(Ex);
throw Ex;
}
}
/// <summary>
/// This method is used to perform operations on vocuhers (Redeemption/Cancelation)
/// </summary>
/// <param name="Info"></param>
/// <param name="UserID"></param>
public static DataTable VoucherOperation(CommonVoucerInfoCollection VoucherDataList, string UserID, string ProcedurName, string RequestorName, string RequestorEmail, string RequestorPhone)
{
try
{
clsParameterCollection ParameterCollection = new clsParameterCollection();
ParameterCollection.ProcedureName = ProcedurName;
ParameterCollection.Add(new clsParameter("@UserID", UserID));
ParameterCollection.Add(new clsParameter("@name", RequestorName));
ParameterCollection.Add(new clsParameter("@EmailId", RequestorEmail));
ParameterCollection.Add(new clsParameter("@phoneNumber", RequestorPhone));
ParameterCollection.Add(new clsParameter("@tblVoucher", GetVoucherTable(VoucherDataList)));
//DataAccess.ExecuteNonQuerySp(ParameterCollection);
return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
}
catch (Exception Ex)
{
if (!Ex.Message.Contains("User Define:"))
BL_Exception.WriteLog(Ex);
throw Ex;
}
}
public static void SaleVoucher(CommonVoucerInfoCollection VoucherDataList, string UserID, bool isVendor, int VendorID, string RequestorName, string RequestorEmail, string RequestorPhone, int Amount)
{
try
{
clsParameterCollection ParameterCollection = new clsParameterCollection();
ParameterCollection.ProcedureName = "BS_SalesNew2_Sale";
ParameterCollection.Add(new clsParameter("@UserID", UserID));
ParameterCollection.Add(new clsParameter("@IsVendor", isVendor));
ParameterCollection.Add(new clsParameter("@VendorId", VendorID));
ParameterCollection.Add(new clsParameter("@name", RequestorName));
ParameterCollection.Add(new clsParameter("@EmailId", RequestorEmail));
ParameterCollection.Add(new clsParameter("@phoneNumber", RequestorPhone));
ParameterCollection.Add(new clsParameter("@Amount", Amount));
ParameterCollection.Add(new clsParameter("@tblVoucher", GetVoucherTable(VoucherDataList)));
DataAccess.ExecuteNonQuerySp(ParameterCollection);
}
catch (Exception Ex)
{
if (!Ex.Message.Contains("User Define:"))
BL_Exception.WriteLog(Ex);
throw Ex;
}
}
