public List <vw_AddSessionSearchResult> AddSessionsSearch(vw_AddSessionsSearchData searchData)
{
List <vw_AddSessionSearchResult> result2 = new List <vw_AddSessionSearchResult>();
var result = (from MasterCase in this.DataContext.Cases_MasterCase
join Cases in this.DataContext.Cases_Cases on MasterCase.ID equals Cases.MasterCaseID
join Courts in this.DataContext.Configurations_Courts on Cases.CourtID equals Courts.ID
join PoliceStation in this.DataContext.Configurations_PoliceStations on MasterCase.PoliceStationID equals PoliceStation.ID
join FirstLevelProsecution in this.DataContext.Configurations_Prosecutions on PoliceStation.ProsecutionID equals FirstLevelProsecution.ID
join SecondLevelProsecution in this.DataContext.Configurations_Prosecutions on MasterCase.ProsecutionID equals SecondLevelProsecution.ID
join CT in this.DataContext.Cases_CrimeTypes on MasterCase.CrimeType equals CT.ID
join MainCrimelookup in this.DataContext.Configurations_Lookups on MasterCase.CrimeID equals MainCrimelookup.ID
join CaseStatuslookup in this.DataContext.Configurations_Lookups on Cases.CaseStatusID equals CaseStatuslookup.ID
where
((MasterCase.IsComplete && Cases.IsDeleted != true) &&
((Courts.ID == searchData.CourtID && searchData.CourtID.HasValue) || !searchData.CourtID.HasValue) &&
((MasterCase.FirstLevelNumber.Contains(searchData.FirstLevelNumber.ToString())) || string.IsNullOrEmpty(searchData.FirstLevelNumber.ToString())) &&
((MasterCase.SecondLevelNumber.Contains(searchData.SecondLevelNumber.ToString())) || string.IsNullOrEmpty(searchData.SecondLevelNumber.ToString())) &&
((MasterCase.FirstLevelYear == searchData.FirstLevelYear.ToString() && searchData.FirstLevelYear.HasValue) || string.IsNullOrEmpty(searchData.FirstLevelYear.ToString())) &&
((MasterCase.SecondLevelYear == searchData.SecondLevelYear.ToString() && searchData.SecondLevelYear.HasValue) || string.IsNullOrEmpty(searchData.SecondLevelYear.ToString())) &&
(((PoliceStation.ProsecutionID == searchData.FirstLevelProsecutionID && searchData.FirstLevelProsecutionID.HasValue)) || !searchData.FirstLevelProsecutionID.HasValue) &&
((MasterCase.ProsecutionID == searchData.SecondLevelProsecutionID && searchData.SecondLevelProsecutionID.HasValue) || !searchData.SecondLevelProsecutionID.HasValue) &&
((MasterCase.PoliceStationID == searchData.PoliceStationID && searchData.PoliceStationID.HasValue) || !searchData.PoliceStationID.HasValue) &&
((CT.ID == searchData.CrimeType && searchData.CrimeType.HasValue) || !searchData.CrimeType.HasValue) &&
((MasterCase.CrimeType == searchData.CrimeType && searchData.CrimeType.HasValue) || !searchData.CrimeType.HasValue) &&
((Cases.CaseStatusID == searchData.CaseStatusID && searchData.CaseStatusID.HasValue) || !searchData.CaseStatusID.HasValue) &&
((MasterCase.CrimeID == searchData.CrimeID && searchData.CrimeID.HasValue) || !searchData.CrimeID.HasValue) &&
((Cases.Cases_CaseDefendants.Any(x => x.Cases_DefendatnsCaseLog.Where(y => y.PoliceStationStatusID == searchData.DefendantStatus).Any())) || !searchData.DefendantStatus.HasValue)
)
select new
{
CaseID = Cases.ID,
FirstLevelNumber = MasterCase.FirstLevelNumber,
SecondLevelNumber = MasterCase.SecondLevelNumber,
CrimeType = CT.Name,
PoliceStation = PoliceStation.Name,
MainCrime = MainCrimelookup.Name,
CaseStatusID = CaseStatuslookup.Name,
CrimeID = CT.ID
}).ToList();
result2 = (from res in result
where !(from r in result
join sessions in DataContext.Cases_CaseSessions on r.CaseID equals sessions.CaseID
join rolls in DataContext.CourtConfigurations_CircuitRolls on sessions.RollID equals rolls.ID
select r.CaseID).ToList().Contains(res.CaseID)
select new vw_AddSessionSearchResult
{
CaseID = res.CaseID,
FirstLevelNumber = res.FirstLevelNumber,
SecondLevelNumber = res.SecondLevelNumber,
CrimeType = res.CrimeType,
PoliceStation = res.PoliceStation,
MainCrime = res.MainCrime,
CaseStatus = res.CaseStatusID,
CrimeID = res.CrimeID
}).ToList();
return(result2);
}
public ActionResult AllCases(SessionsSearchViewModel model)
{
if (CurrentUser != null)
{
try
{
vw_AddSessionsSearchData sessionsSearchData = new vw_AddSessionsSearchData
{
CaseStatusID = model.CaseStatusID,
CircuitID = model.CircuitID,
CrimeID = model.CrimeID,
CourtID = CurrentUser.CourtID,
CrimeType = model.CrimeType,
DefendantStatus = model.DefendantStatusID,
FirstLevelNumber = model.FirstLevelNumber,
FirstLevelProsecutionID = model.FirstLevelProsecutionID,
FirstLevelYear = model.FirstLevelYear,
PoliceStationID = model.PoliceStationID,
SecondLevelNumber = model.SecondLevelNumber,
SecondLevelProsecutionID = model.SecondLevelProsecutionID,
SecondLevelYear = model.SecondLevelYear
};
List <vw_AddSessionSearchResult> SearchResult = searchCasesService.AddSessionsSearch(sessionsSearchData);
model = FillLists();
model.cases.AddRange(SearchResult.Select(x => new SessionsSearchGridViewModel
{
CaseID = x.CaseID,
CaseStatus = x.CaseStatus,
CrimeType = x.CrimeType,
FirstLevelNumber = x.FirstLevelNumber,
MainCrime = x.MainCrime,
PoliceStation = x.PoliceStation,
SecondLevelNumber = x.SecondLevelNumber,
CrimeID = x.CrimeID
}));
ViewData["SessionEnded"] = false;
return(CPartialView(model));
}
catch (Exception ex)
{
return(ErrorPage(ex));
}
}
else
{
ViewData["SessionEnded"] = true;
return(CPartialView());
}
}
public ActionResult Edit([Bind(Prefix = "Edit")] SessionsSearchViewModel model)
{
if (CurrentUser != null)
{
//ViewData.TemplateInfo.HtmlFieldPrefix = "Edit";
vw_AddSessionsSearchData sessionsSearchData = new vw_AddSessionsSearchData
{
CaseStatusID = model.CaseStatusID,
CircuitID = model.CircuitID,
CrimeID = model.CrimeID,
CourtID = CurrentUser.CourtID,
CrimeType = model.CrimeType,
DefendantStatus = model.DefendantStatusID,
FirstLevelNumber = model.FirstLevelNumber,
FirstLevelProsecutionID = model.FirstLevelProsecutionID,
FirstLevelYear = model.FirstLevelYear,
PoliceStationID = model.PoliceStationID,
SecondLevelNumber = model.SecondLevelNumber,
SecondLevelProsecutionID = model.SecondLevelProsecutionID,
SecondLevelYear = model.SecondLevelYear
};
List <vw_AddSessionSearchResult> SearchResult = searchCasesService.EditSessionSearch(sessionsSearchData);
model = FillLists();
model.cases.AddRange(SearchResult.Select(x => new SessionsSearchGridViewModel
{
CaseID = x.CaseID,
CaseStatus = x.CaseStatus,
CrimeType = x.CrimeType,
FirstLevelNumber = x.FirstLevelNumber,
MainCrime = x.MainCrime,
PoliceStation = x.PoliceStation,
SecondLevelNumber = x.SecondLevelNumber,
SessionDate = x.SessionDate.ToShortDateString(),
CrimeID = x.CrimeID,
CircuitName = x.CircuitName,
}));
model.tabName = "#NotSendcases";
ViewData["SessionEnded"] = false;
return(CPartialView(model).WithPrefix("Edit"));
//return RedirectTo(Url.Action("Index")).WithSuccessMessages(JIC.Base.Resources.Messages.OperationCompletedSuccessfully);
}
else
{
ViewData["SessionEnded"] = true;
return(CPartialView());
}
}
//[ValidateAntiForgeryToken]
public ActionResult Index(SessionsSearchViewModel model)
{
if (CurrentUser != null)
{
vw_AddSessionsSearchData sessionsSearchData = new vw_AddSessionsSearchData
{
CaseStatusID = model.CaseStatusID,
CircuitID = model.CircuitID,
CrimeID = model.CrimeID,
CourtID = CurrentUser.CourtID,
CrimeType = model.CrimeType,
DefendantStatus = model.DefendantStatusID,
FirstLevelNumber = model.FirstLevelNumber,
FirstLevelProsecutionID = model.FirstLevelProsecutionID,
FirstLevelYear = model.FirstLevelYear,
PoliceStationID = model.PoliceStationID,
SecondLevelNumber = model.SecondLevelNumber,
SecondLevelProsecutionID = model.SecondLevelProsecutionID,
SecondLevelYear = model.SecondLevelYear
};
List <vw_AddSessionSearchResult> SearchResult = searchCasesService.AddSessionsSearch(sessionsSearchData);
model = FillLists();
model.cases.AddRange(SearchResult.Select(x => new SessionsSearchGridViewModel
{
CaseID = x.CaseID,
CaseStatus = x.CaseStatus,
CrimeType = x.CrimeType,
FirstLevelNumber = x.FirstLevelNumber,
MainCrime = x.MainCrime,
PoliceStation = x.PoliceStation,
SecondLevelNumber = x.SecondLevelNumber
}));
return(View(model));
}
else
{
return(RedirectTo(Url.Action("login", "User", new { returnUrl = "/" })).WithErrorMessages("تم الخروج بشكل تلقائى لعدم التفاعل اكثر من 15 دقيقة"));
}
}
public List <vw_AddSessionSearchResult> EditSessionSearch(vw_AddSessionsSearchData searchData)
{
return(SearchCaseComponent.EditSessionSearch(searchData));
}
public List <vw_AddSessionSearchResult> EditSessionSearch(vw_AddSessionsSearchData searchData)
{
throw new NotImplementedException();
}
public List <vw_AddSessionSearchResult> EditSessionSearch(vw_AddSessionsSearchData searchData)
{
return(SearchCaseRepository.EditSessionSearch(searchData));
}
