public DeleteCircuitStatus DeleteCircuit(int ID) { try { if (CaseComponent.IsCaseConnectedToCircuit(ID)) { return(DeleteCircuitStatus.CaseConnectedToCircuit); } //if (CircuitComponent.IsStartDateAfterToday(ID)==false) //{ // return DeleteCircuitStatus.CircuitStartDateBeforeToday; //} else { using (var Transaction = BeginDatabaseTransaction()) { var r1 = CircuitRollsComponent.DeleteCircuitRollsByCircuitID(ID); var r2 = CircuitMembersComponent.DeleteCircuitMemberByCircuitID(ID); PoliceComp.DeleteCircuitPoliceStations(ID); CircuitComponent.DeleteCircuit(ID); if (Transaction != null) { Transaction.Commit(); } return(DeleteCircuitStatus.Deleted); } } } catch (Exception ex) { HandleException(ex); return(DeleteCircuitStatus.NotDeleted); } }
public CaseSaveStatus UpdateBasicData(vw_CrimeCaseBasicData caseBasicData) { try { // using (var Transaction = BeginDatabaseTransaction()) { int MasterCaseID = CaseComponent.GetMasterCaseID(caseBasicData.CaseID); if (MasterCaseComponent.IsSecondLevelNumberExistBefore(caseBasicData.SecondNumberInt, caseBasicData.SecondYearInt, caseBasicData.SecondProsecutionID.Value, MasterCaseID)) { return(CaseSaveStatus.SecondNumberExistBefore); } else { CaseComponent.UpdateCaseBasicData(caseBasicData); MasterCaseComponent.UpdateCaseBasicData(MasterCaseID, caseBasicData); //if (Transaction != null) // Transaction.Commit(); return(CaseSaveStatus.Saved); } } } catch (Exception ex) { HandleException(ex); return(CaseSaveStatus.Failed); } }
public CaseSaveStatus AddBasicData(vw_CrimeCaseBasicData caseBasicData, out int CaseID) { try { int MasterCaseID; CaseSaveStatus CaseResult = MasterCaseComponent.AddCaseBasicData(caseBasicData, out MasterCaseID); if (CaseResult == CaseSaveStatus.SecondNumberExistBefore) { CaseID = 0; return(CaseSaveStatus.SecondNumberExistBefore); } else { using (var Transaction = BeginDatabaseTransaction()) { CaseID = CaseComponent.AddCaseData(caseBasicData, MasterCaseID); if (Transaction != null) { Transaction.Commit(); } return(CaseSaveStatus.Saved); } } } catch (Exception ex) { CaseID = 0; HandleException(ex); return(CaseSaveStatus.Failed); } }
public vw_CaseData GetCaseData(int CaseID) { vw_CaseData CaseFulldata = new vw_CaseData(); CaseFulldata.CaseBasicData = CaseComponent.GetCaseData(CaseID); CaseFulldata.Defendants = DefendantsComp.GetDefendantsByCaseID(CaseID); CaseFulldata.Victims = VictimsComp.GetVictimsByCaseID(CaseID); CaseFulldata.CaseDecision = DecisionsComp.GetCaseDecisions(CaseID); CaseFulldata.CaseSessions = SessionsComp.GetSessionDataByCaseID(CaseID); CaseFulldata.OrderOfAssignment = OrderOfAssignmentComponent.GetOrderByID(CaseID); // CaseFulldata.CaseDescription = DescComponent .GetCaseDescriptionByCaseID (CaseID); List <vw_Documents> Doc = AttachComponent.GetDocuments(CaseID, null, null).ToList(); List <vw_CaseDocuments> Documents = new List <vw_CaseDocuments>(); foreach (vw_Documents d in Doc) { Documents.Add(new vw_CaseDocuments { DocumentID_Guid = d.ID, DocumentName = d.DocumentTitle }); } CaseFulldata.Documents = Documents; return(CaseFulldata); }
public vw_CrimeCaseBasicData GetCaseBasicData(int CaseID) { try { return(CaseComponent.GetCaseData(CaseID)); } catch (Exception ex) { HandleException(ex); return(null); } }
public DeleteStatus DeleteBasicData(int CaseID) { try { using (var Transaction = BeginDatabaseTransaction()) { int MasterCase = 0; var cases = GetCaseBasicData(CaseID); //AttachmentsComponent.DeleteCaseDocuments(CaseID); // List<vw_CaseDefectsData> Def=DefendantsComp.GetDefendantsByCaseID(CaseID); //foreach (vw_CaseDefectsData X in Def) //{ DefendantsComp.DeleteDefendant(CaseID, X.ID); } //List<vw_CaseDefectsData> Vic = VictimsComp.GetVictimsByCaseID (CaseID); //foreach (vw_CaseDefectsData Y in Vic) //{ VictimsComp.DeleteVictim(CaseID, Y.ID); } CaseComponent.DeleteCaseBasicData(CaseID, cases.IsComplete, out MasterCase); if (cases.IsComplete) { OverAllNumberCombonent.DisableOverAll(CaseID); } else { MasterCaseComponent.DeleteCaseBasicData(MasterCase); } // if (Transaction != null) { Transaction.Commit(); } return(DeleteStatus.Deleted); } } catch (Exception ex) { HandleException(ex); return(DeleteStatus.NotDeleted); } }
public bool DeleteNotCompleteCase(int CaseID) { try { using (var Transaction = BeginDatabaseTransaction()) { int MasterID = 0; var Result = AttachmentsComponent.DeleteCaseDocuments(CaseID) && DefectsService.DeleteCaseDefects(CaseID) && CaseComponent.DeleteCaseBasicData(CaseID, false, out MasterID); if (Result) { MasterCaseComp.DeleteCaseBasicData(MasterID); } if (Result && Transaction != null) { Transaction.Commit(); } return(Result); } } catch (Exception ex) { HandleException(ex); return(false); } }
public void UpdateCaseStatus_AfterJudgeApprove(int CaseID) { CaseComponent.UpdateCaseStatus_AfterJudgeApprove(CaseID); }
public IQueryable <vw_CrimeCaseBasicData> GetAllCasesPendingDate(int CourtID) { return(CaseComponent.GetAllCasesPendingDate(CourtID)); }
public AddOverAllStatus EditOverAllNumber(int CaseID, long Number, int Year) { return(OverAllNumberComponent.EditOverAll(CaseID, Number, CaseComponent.GetCaseData(CaseID).FirstProsecutionID, Year)); }