public static List <LPDetail> GetAllActiveLPsForAProperty(string propertyBBL, DateTime?startdate)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnActiveLPsForaProperty_Result>, List <LPDetail> >(nycourtsE.tfnActiveLPsForaProperty(propertyBBL, startdate).ToList()));
}
}
public static CaseDetails GetCaseDetails(string countyId, string caseIndexNumber)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <CaseDetails>(nycourtsE.vwCaseExpandeds.Find(countyId, caseIndexNumber)));
}
}
public IHttpActionResult GetCasesColumnValueChanges(string columnName, string startDate, string endDate)
{
DateTime sDateTime, eDateTime;
if (!DateTime.TryParseExact(startDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out sDateTime) ||
!DateTime.TryParseExact(endDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out eDateTime))
{
return(this.BadRequest("Incorrect Date Format - use yyyyMMdd format for dates - eg: 20161030 which Oct 30, 2016"));
}
try
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
List <tfnGetCaseColumnChanges_Result> caseColumnChangesList = nycourtsE.tfnGetCaseColumnChanges("ccis.case", columnName, sDateTime, eDateTime).ToList();
if (caseColumnChangesList == null || caseColumnChangesList.Count == 0)
{
return(NotFound());
}
return(Ok(Mapper.Map <List <tfnGetCaseColumnChanges_Result>, List <DAL.CaseDataChange> >(caseColumnChangesList)));
}
}
catch (Exception e)
{
Common.Logs.log().Error(string.Format("Exception encountered for Start Date: {0} End Date:{1}{2}", startDate, endDate, Common.Logs.FormatException(e)));
return(Common.HttpResponse.InternalError(Request, "Internal Error in processing request"));
}
}
public static vwMotionSummaryByReliefSought GetMotionSummaryStatisticsByReliefSought(string reliefSought)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(nycourtsE.vwMotionSummaryByReliefSoughts.Where(i => i.ReliefSought == reliefSought).FirstOrDefault());
}
}
public IHttpActionResult GetMortgageForeclosureCasesForaProperty(string propertyBBL)
{
if (!BAL.BBL.IsValidFormat(propertyBBL))
{
return(this.BadRequest("Incorrect BBL - Borough Block Lot number"));
}
try
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
List <tfnGetMortgageForeclosureCasesForaProperty_Result> casesList = nycourtsE.tfnGetMortgageForeclosureCasesForaProperty(propertyBBL).ToList();
if (casesList == null || casesList.Count == 0)
{
return(NotFound());
}
return(Ok(Mapper.Map <List <tfnGetMortgageForeclosureCasesForaProperty_Result>, List <DAL.CaseBasicInformation> >(casesList)));
}
}
catch (Exception e)
{
Common.Logs.log().Error(string.Format("Exception encountered for BBL {0}{1}", propertyBBL, Common.Logs.FormatException(e)));
return(Common.HttpResponse.InternalError(Request, "Internal Error in processing request"));
}
}
public static List <AttorneyDetails> GetAllAttorneysForACase(string countyId, string caseIndexNumber)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <vwAttorneyExpanded>, List <AttorneyDetails> >(nycourtsE.vwAttorneyExpandeds.Where(i => i.CountyId == countyId && i.CaseIndexNumber == caseIndexNumber)
.OrderByDescending(m => m.SeqNumber).ToList()));
}
}
public static List <FirmDetail> GetRelatedLawFirms(string countyId, string firmId, string partyIndicator, bool withinSameCounty)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnGetRelatedFirmsForAttorneyOfRecord_Result>, List <FirmDetail> >(nycourtsE.tfnGetRelatedFirmsForAttorneyOfRecord(countyId, firmId, partyIndicator, withinSameCounty)
.OrderByDescending(m => m.Count).ToList()));
}
}
public static List <JudgeNameCount> GetJudgesPresidedOverRelatedLawFirmsCases(string countyId, string firmId, string partyIndicator, bool withinSameCounty)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnGetJudgesForRelatedFirmsForAttorneyOfRecord_Result>, List <JudgeNameCount> >(nycourtsE.tfnGetJudgesForRelatedFirmsForAttorneyOfRecord(countyId, firmId, partyIndicator, withinSameCounty)
.ToList()));
}
}
public static List <vwMotionSummaryByJudgeReliefSought> GetMotionSummaryStatisticsByJudgeReliefSought(string countyId, string judgeId)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(nycourtsE.vwMotionSummaryByJudgeReliefSoughts.Where(i => i.CountyId == countyId &&
i.JudgeId == judgeId).ToList());
}
}
public static List <CaseCompletionDecision5NumberSummaryPlus> GetCaseCompletionDecision5NumberSummary(string countyId, string firmId, bool withinSameCounty, string judgeCountyId, string judgeId)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnCaseCompletionDecision5NSForLawFirmAndJudge_Result>, List <CaseCompletionDecision5NumberSummaryPlus> >
(nycourtsE.tfnCaseCompletionDecision5NSForLawFirmAndJudge(countyId, firmId, withinSameCounty, judgeCountyId, judgeId).ToList()));
}
}
public static vwJudgeReliefSought5NumberSummary GetJudgeReliefSought5PlusNumberSummary(string countyId, string judgeId, string reliefSought)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(nycourtsE.vwJudgeReliefSought5NumberSummary.Where(i => i.CountyId == countyId &&
i.JudgeId == judgeId &&
i.ReliefSought == reliefSought).FirstOrDefault());
}
}
public static List <vwCaseByJudgeReliefSought> GetCasesByJudgeReliefSought(string countyId, string judgeId, string reliefSought)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(nycourtsE.vwCaseByJudgeReliefSoughts.Where(i => i.CountyId == countyId &&
i.JudgeId == judgeId &&
i.ReliefSought == reliefSought).ToList());
}
}
public static List <AppearanceDetails> GetAllAppearancesForACase(string countyId, string caseIndexNumber)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <vwAppearanceExpanded>, List <AppearanceDetails> >(nycourtsE.vwAppearanceExpandeds
.Where(i => i.CountyId == countyId && i.CaseIndexNumber == caseIndexNumber)
.OrderBy(m => m.AppearanceDate).ToList()));
}
}
public static List <ReliefSoughtDecision5NumberSummaryPlus> GetReliefSoughtDecision5NumberSummary(string countyId, string firmId, string partyIndicator, bool withinSameCounty, string judgeCountyId, string judgeId)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnReliefSoughtDecision5NSForLawFirmAndJudge_Result>, List <ReliefSoughtDecision5NumberSummaryPlus> >
(nycourtsE.tfnReliefSoughtDecision5NSForLawFirmAndJudge(countyId, firmId, partyIndicator, withinSameCounty, judgeCountyId, judgeId)
.OrderBy(m => m.ReliefSought).ToList()));
}
}
public static List <FirmCompletedCaseDetail> GetLawFirmCompletedCases(string countyId, string firmId, string partyIndicator, bool withinSameCounty, string judgeCountyId, string judgeId, string decision)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnGetCompletedCasesForRelatedFirmsForAttorneyOfRecord_Result>, List <FirmCompletedCaseDetail> >
(nycourtsE.tfnGetCompletedCasesForRelatedFirmsForAttorneyOfRecord(countyId, firmId, partyIndicator, withinSameCounty, judgeCountyId, judgeId, decision)
.OrderByDescending(m => m.DateRJIFiled).ToList()));
}
}
public static List <CaseUpdate> GetRecordedCaseHistory(string countyId, string caseIndexNumber)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnGetCaseUpdates_Result>, List <CaseUpdate> >(nycourtsE.tfnGetCaseUpdates(countyId, caseIndexNumber)
.OrderBy(m => m.TransactionDateTime)
.ThenBy(m => m.DateTimeProcessed).ToList()));
}
}
public static List <CaseDocumentDetails> GetAllMinutesForACase(string countyId, string caseIndexNumber)
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
return(Mapper.Map <List <tfnGetDocumentExtractForCase_Result>, List <CaseDocumentDetails> >(nycourtsE.tfnGetDocumentExtractForCase(countyId, caseIndexNumber)
.OrderByDescending(m => m.DateCreated)
.ToList()));
}
}
public IHttpActionResult GetMortgageForeclosureLPsForaProperty(string propertyBBL, string effectiveDate = "")
{
if (!BAL.BBL.IsValidFormat(propertyBBL))
{
return(BadRequest("Incorrect BBL - Borough Block Lot number"));
}
DateTime?sDateTime = null;
DateTime actualDateTime = DateTime.MinValue;
if (effectiveDate != "" && !DateTime.TryParseExact(effectiveDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out actualDateTime))
{
return(this.BadRequest("Incorrect Date Format - use yyyyMMdd format for dates - Eg: 20161030 which Oct 30, 2016"));
}
if (effectiveDate != "")
{
sDateTime = actualDateTime;
}
try
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
List <tfnGetMortgageForeclosureLPsForaProperty_Result> lpsList = nycourtsE.tfnGetMortgageForeclosureLPsForaProperty(propertyBBL, sDateTime)
.OrderByDescending(m => m.EffectiveDateTime).ToList();
if (lpsList == null || lpsList.Count == 0)
{
return(NotFound());
}
return(Ok(Mapper.Map <List <tfnGetMortgageForeclosureLPsForaProperty_Result>, List <DAL.LPCaseDetails> >(lpsList)));
}
}
catch (Exception e)
{
Common.Logs.log().Error(string.Format("Exception encountered for BBL {0}{1}", propertyBBL, Common.Logs.FormatException(e)));
return(Common.HttpResponse.InternalError(Request, "Internal Error in processing request"));
}
}
public IHttpActionResult GetAllActiveLPsForaProperty(string propertyBBL, string effectiveAsOfDate = "20070101")
{
if (!BAL.BBL.IsValidFormat(propertyBBL))
{
return(this.BadRequest("Incorrect BBL - Borough Block Lot number"));
}
DateTime?sDateTime = null;
DateTime actualDateTime = DateTime.MinValue;
if (effectiveAsOfDate != "" && !DateTime.TryParseExact(effectiveAsOfDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out actualDateTime))
{
return(this.BadRequest("Incorrect Date Format - use yyyyMMdd format for dates - Eg: 20161030 which Oct 30, 2016"));
}
if (effectiveAsOfDate != "")
{
sDateTime = actualDateTime;
}
try
{
using (NYCOURTSEntities nycourtsE = new NYCOURTSEntities())
{
var resultList = DAL.eCourts.GetAllActiveLPsForAProperty(propertyBBL, sDateTime);
if (resultList == null || resultList.Count == 0)
{
return(NotFound());
}
return(Ok(resultList));
}
}
catch (Exception e)
{
Common.Logs.log().Error(string.Format("Exception encountered for BBL {0} with effectiveDate{1}{2}", propertyBBL, effectiveAsOfDate, Common.Logs.FormatException(e)));
return(Common.HttpResponse.InternalError(Request, "Internal Error in processing request"));
}
}
