private IEnumerable <ListReqVahed> GetData() { CheckOutRequestBusiness reqBusiness = new CheckOutRequestBusiness(); var idVahed = drpUniversity.SelectedItem.Value; var startDate = StartDateTxt.Text; var endDate = EndDateTxt.Text; var MadrakType = 2; var listByVahed = reqBusiness.GetListOFRequestByVahedAndDate(Convert.ToInt32(idVahed), startDate, endDate, Convert.ToInt32(MadrakType)); var vahedList = RequestHandler.ConvertDataTableToList <ListReqVahed>(listByVahed); switch (drpReportType.SelectedItem.Value) { case "1": return(vahedList.Where(w => w.DateApprovePay == null && w.DateSendToPay == null)); case "2": return(vahedList.Where(w => w.DateSendToPay != null)); case "3": return(vahedList); } //if (drpReportType.SelectedItem.Value == "1") //return vahedList.Where(w => w.DateApprovePay == null && w.DateSendToPay == null); //else return(vahedList.Where(w => w.DateSendToPay != null)); }
private IEnumerable <ListReqVahed> GetData() { CheckOutRequestBusiness reqBusiness = new CheckOutRequestBusiness(); var idVahed = drpUniversity.SelectedItem.Value; var startDate = StartDateTxt.Text; var endDate = EndDateTxt.Text; var MadrakType = drpTypeMadrak.SelectedItem.Value; var listByVahed = reqBusiness.GetListOFRequestByVahedAndDate(Convert.ToInt32(idVahed), startDate, endDate, Convert.ToInt32(MadrakType)); var vahedList = RequestHandler.ConvertDataTableToList <ListReqVahed>(listByVahed); //var fareghNull = reqBusiness.GetListOFApproveList(); //var nullFaregh = RequestHandler.ConvertDataTableToList<ApproveList>(fareghNull); //return from x in nullFaregh // where x.ApproveDateMali == null // join y in vahedList // on x.StudentRequestId equals y.StudentRequestID // select y; return(vahedList.Where(w => w.DateApprovePay == null && w.DateSendToPay != null)); //return nullFaregh.Join(nullFaregh, vahed=> vahed.StudentRequestId, faregh=> faregh.StudentRequestId, (vahed, faregh) => new );//vahedList.Where(w => !nullFaregh.Contains(w.StudentRequestID)); }
private IEnumerable <ListReqVahed> GetData() { CheckOutRequestBusiness reqBusiness = new CheckOutRequestBusiness(); var idVahed = drpUniversity.SelectedItem.Value; var startDate = StartDateTxt.Text; var endDate = EndDateTxt.Text; var MadrakType = 2; var listByVahed = reqBusiness.GetListOFRequestByVahedAndDate(Convert.ToInt32(idVahed), startDate, endDate, Convert.ToInt32(MadrakType)); var vahedList = RequestHandler.ConvertDataTableToList <ListReqVahed>(listByVahed); //var fareghNull = reqBusiness.GetListOFApproveList(); //var nullFaregh = RequestHandler.ConvertDataTableToList<ApproveList>(fareghNull) // .Where(w=> w.ApproveDateFaregh != null && w.ApproveDateMali != null) // .Select(s => s.StudentRequestId); switch (drpReportType.SelectedItem.Value) { case "1": return(vahedList.Where(w => w.DateApprovePay != null && w.DateSendToPay != null)); //nullFaregh.Contains(w.StudentRequestID) case "2": return(vahedList); } return(vahedList.Where(w => w.DateApprovePay != null && w.DateSendToPay != null));//nullFaregh.Contains(w.StudentRequestID) }