public List <DA_TRN> GetLimitOverwriteReport(SessionInfo sessionInfo, string strReportDate, string strCtpy) { try { DateTime dteReport; Guid guCtpyID = Guid.Empty; DealBusiness _dealBusiness = new DealBusiness(); if (String.IsNullOrEmpty(strReportDate)) { throw this.CreateException(new Exception(), "Please input date."); } else if (!DateTime.TryParseExact(strReportDate, "dd/MM/yyyy", null, DateTimeStyles.None, out dteReport)) { throw this.CreateException(new Exception(), "Invalid date."); } else { dteReport = DateTime.ParseExact(strReportDate, "dd/MM/yyyy", null); } var trns = _dealBusiness.GetDealByProcessDate(dteReport).AsQueryable(); trns = trns.Where(t => t.OVER_APPROVER != null && t.SOURCE == "INT" && t.MA_STATUS.LABEL != StatusCode.CANCELLED.ToString()); if (Guid.TryParse(strCtpy, out guCtpyID)) { trns = trns.Where(a => a.CTPY_ID == guCtpyID); } return(trns.ToList()); } catch (DataServicesException ex) { throw this.CreateException(ex, null); } }
public void GetDealByProcessDateTest() { DealBusiness target = new DealBusiness(); // TODO: Initialize to an appropriate value DateTime processdate = new DateTime(); // TODO: Initialize to an appropriate value List <DA_TRN> expected = null; // TODO: Initialize to an appropriate value List <DA_TRN> actual; actual = target.GetDealByProcessDate(processdate); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
public List <DA_TRN> GetPCEDetailReport(SessionInfo sessioninfo, string strReportDate, string strCtpy, string strProduct, string strSource) { try { DateTime dteReport; DealBusiness _dealBusiness = new DealBusiness(); Guid guTemp; if (String.IsNullOrEmpty(strReportDate)) { throw this.CreateException(new Exception(), "Please input report date."); } else if (!DateTime.TryParseExact(strReportDate, "dd/MM/yyyy", null, DateTimeStyles.None, out dteReport)) { throw this.CreateException(new Exception(), "Invalid report date."); } else { dteReport = DateTime.ParseExact(strReportDate, "dd/MM/yyyy", null); } if (_dealBusiness.CountByProcessDate(dteReport) == 0) { throw this.CreateException(new Exception(), "No data for selected report date."); } var trns = _dealBusiness.GetDealByProcessDate(dteReport).Where(p => p.MA_STATUS.LABEL.ToString() != StatusCode.CANCELLED.ToString()).AsQueryable(); if (!string.IsNullOrEmpty(strSource)) { trns = trns.Where(p => p.SOURCE == strSource); } if (Guid.TryParse(strCtpy, out guTemp)) { trns = trns.Where(t => t.CTPY_ID == Guid.Parse(strCtpy)); } if (Guid.TryParse(strProduct, out guTemp)) { trns = trns.Where(s => s.PRODUCT_ID == Guid.Parse(strProduct)); } return(trns.ToList()); } catch (DataServicesException ex) { throw this.CreateException(ex, null); } }