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