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