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