public List <BusinessCommissionTransaction> getAllSelectedMonthBusinessCommissionTransaction(int BN, string month, string year)
{
var list = new List <BusinessCommissionTransaction>();
try
{
int intMonth = Convert.ToInt32(month);
int intYear = Convert.ToInt32(year);
DateTime firstDate = CommonLibrary.StartOfMonth(intYear, intMonth);
DateTime lastDate = CommonLibrary.EndOfMonth(intYear, intMonth);
var query = from busTrans in db.TBUS_CMSN_TRANS
join trans in db.TTRANS_TRSF_CRDT_DBT on busTrans.TRANS_ID equals trans.TRANS_ID
join busUsr in db.TBUS_USR on busTrans.BUS_USR_NBR equals busUsr.BUS_USR_NBR
where (busUsr.BN == BN && trans.TRANS_SCD == "06" && trans.TRANS_CDT >= firstDate && trans.TRANS_CDT <= lastDate)
orderby trans.TRANS_ID descending
select busTrans;
foreach (var item in query)
{
list.Add(item);
}
return(list);
}
catch
{
return(list);
}
}
public List <AgentTransfer> getAllSelectedMonthAgentTransferByAgentID(int agntID, string month, string year)
{
var list = new List <AgentTransfer>();
try
{
int intMonth = Convert.ToInt32(month);
int intYear = Convert.ToInt32(year);
DateTime firstDate = CommonLibrary.StartOfMonth(intYear, intMonth);
DateTime lastDate = CommonLibrary.EndOfMonth(intYear, intMonth);
return(db.TAGNT_TRSF.Where(x => x.AGNT_ID == agntID && x.AGNT_TRSF_DT >= firstDate && x.AGNT_TRSF_DT <= lastDate).OrderByDescending(x => x.AGNT_TRSF_DT).ToList());
}
catch
{
return(list);
}
}