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