Programmer:Member List and Point Balance: Difference between revisions

From AutoCount Resource Center
Content added Content deleted
No edit summary
Line 65: Line 65:
==Load selected Member(s) (filter member) and Member Point Balance==
==Load selected Member(s) (filter member) and Member Point Balance==
<syntaxhighlight lang="csharp">
<syntaxhighlight lang="csharp">
public DataTable LoadMemberBalPointByMultiSelectMember(List<string> memberNo, BCE.Data.DBSetting dbSetting)
public DataTable LoadMemberBalPointByMultiSelectMember(List<string> memberNoList, BCE.Data.DBSetting dbSetting)
{
{
BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report =
BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report =
Line 77: Line 77:
//Filter Member by multi-select
//Filter Member by multi-select
filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
memberNo.ForEach(s => filterMember.Add(s));
memberNoList.ForEach(s => filterMember.Add(s));


//Set the from and to date to future, so the BF Balance is actual member total balance
//Set the from and to date to future, so the BF Balance is actual member total balance
Line 93: Line 93:


<br/>
<br/>

==Load a range of MemberType (filter MemberType) and Member Point Balance==
==Load a range of MemberType (filter MemberType) and Member Point Balance==
<syntaxhighlight lang="csharp">
<syntaxhighlight lang="csharp">

Revision as of 02:39, 10 August 2018

Load Member data

public DataTable LoadMemberData(BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberCommand cmd =
        BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberCommand.Create(dbSetting);
    return cmd.LoadBrowseTable();
}


Load Member Transaction Listing by Date Range with Member Point

public DataSet LoadAllMemberListingByDateWithPoint(DateTime fromDate, DateTime toDate, BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report
        = BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing.Create(dbSetting);

    //5 filters are required by report.Inquire
    BCE.AutoCount.SearchFilter.Filter filterMember = new BCE.AutoCount.SearchFilter.Filter("B", "MemberNo");
    BCE.AutoCount.SearchFilter.Filter filterMemberType = new BCE.AutoCount.SearchFilter.Filter("B", "MemberType");
    BCE.AutoCount.SearchFilter.Filter filterAgent = new BCE.AutoCount.SearchFilter.Filter("C", "SalesAgent");
    BCE.AutoCount.SearchFilter.Filter filterArea = new BCE.AutoCount.SearchFilter.Filter("B", "AreaCode");
    BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");

    //the value of true to indicate whether to load Zero Balance member
    report.Inquire(fromDate, toDate,
        filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
    DataSet ds = report.DsBonusPointTransactionListing;

    return ds;
}
  • Contains 2 Tables in the DataSet
    1. Master
      Table of member listing and transactions with earning points by date range.
    2. BalanceBF
      List of members and Balance Point until the toDate.


Load All Member and Member Point Balance

public DataTable LoadAllMemberBalancePoint(BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report
        = BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing.Create(dbSetting);
    BCE.AutoCount.SearchFilter.Filter filterMember = new BCE.AutoCount.SearchFilter.Filter("B", "MemberNo");
    BCE.AutoCount.SearchFilter.Filter filterMemberType = new BCE.AutoCount.SearchFilter.Filter("B", "MemberType");
    BCE.AutoCount.SearchFilter.Filter filterAgent = new BCE.AutoCount.SearchFilter.Filter("C", "SalesAgent");
    BCE.AutoCount.SearchFilter.Filter filterArea = new BCE.AutoCount.SearchFilter.Filter("B", "AreaCode");
    BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");

    //Set the from and to date to future, so the BalanceBF is actual member point balance 
    report.Inquire(new DateTime(9900, 12, 31), new DateTime(9900, 12, 31),
        filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);

    return report.DsBonusPointTransactionListing.Tables["BalanceBF"];
}


Columns in return table of LoadAllMemberBalancePoint


Load selected Member(s) (filter member) and Member Point Balance

public DataTable LoadMemberBalPointByMultiSelectMember(List<string> memberNoList, BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report =
        BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing.Create(dbSetting);
    BCE.AutoCount.SearchFilter.Filter filterMember = new BCE.AutoCount.SearchFilter.Filter("B", "MemberNo");
    BCE.AutoCount.SearchFilter.Filter filterMemberType = new BCE.AutoCount.SearchFilter.Filter("B", "MemberType");
    BCE.AutoCount.SearchFilter.Filter filterAgent = new BCE.AutoCount.SearchFilter.Filter("C", "SalesAgent");
    BCE.AutoCount.SearchFilter.Filter filterArea = new BCE.AutoCount.SearchFilter.Filter("B", "AreaCode");
    BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");

    //Filter Member by multi-select
    filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
    memberNoList.ForEach(s => filterMember.Add(s));

    //Set the from and to date to future, so the BF Balance is actual member total balance 
    report.Inquire(new DateTime(9900, 12, 31), new DateTime(9900, 12, 31),
        filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);

    return report.DsBonusPointTransactionListing.Tables["BalanceBF"];
}
  • To call the method of LoadMemberBalPointByMultiSelectMember
string[] selectedMembers = { "M-0001", "M-0003" };
LoadMemberBalPointByMultiSelectMember(selectedMembers.ToList(), mydbset);


Load a range of MemberType (filter MemberType) and Member Point Balance

public DataTable LoadMemberBalPointByRangeSelectMemberType(string fromMemberType, string toMemberType, BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report =
        BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing.Create(dbSetting);
    BCE.AutoCount.SearchFilter.Filter filterMember = new BCE.AutoCount.SearchFilter.Filter("B", "MemberNo");
    BCE.AutoCount.SearchFilter.Filter filterMemberType = new BCE.AutoCount.SearchFilter.Filter("B", "MemberType");
    BCE.AutoCount.SearchFilter.Filter filterAgent = new BCE.AutoCount.SearchFilter.Filter("C", "SalesAgent");
    BCE.AutoCount.SearchFilter.Filter filterArea = new BCE.AutoCount.SearchFilter.Filter("B", "AreaCode");
    BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");

    //Filter MemberType by range
    filterMemberType.Type = BCE.AutoCount.SearchFilter.FilterType.ByRange;
    filterMemberType.From = fromMemberType;
    filterMemberType.To = toMemberType;

    //Set the from and to date to future, so the BF Balance is actual member total balance 
    report.Inquire(new DateTime(9900, 12, 31), new DateTime(9900, 12, 31),
        filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);

    return report.DsBonusPointTransactionListing.Tables["BalanceBF"];
}


See Also

Maintenance (Master Data)

Transactions

Reporting

  • Member List and Point Balance - [1.8, 1.9] [2.0]

    Go to menu

    Go to top
    Resources For AutoCount Software Developers