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 SaveCircuitStatus EditCircuit(vw_CircuitData circuitData)
{
try
{
DateTime EndCircuitDate = new DateTime(DateTime.Today.Year, SystemConfigurations.Settings_CircuitEndMonth, SystemConfigurations.Settings_CircuitEndDay);
bool isSameYearCircuit = (circuitData.CircuitStartDate < EndCircuitDate || (circuitData.CircuitStartDate > EndCircuitDate && DateTime.Today > EndCircuitDate) ? true : false);
DateTime CircuitEndDate = new DateTime(circuitData.CircuitStartDate.Year, SystemConfigurations.Settings_CircuitEndMonth, SystemConfigurations.Settings_CircuitEndDay);
if (circuitData.CircuitStartDate > CircuitEndDate)
{
CircuitEndDate = circuitData.CircuitStartDate.AddYears(1);
}
//if (CircuitComponent.IsStartDateAfterToday(circuitData.ID) == false)
//{
// return SaveCircuitStatus.CircuitStartDateBeforeToday;
//}
if (ValidateJudges(circuitData.JudgesID))
{
return(SaveCircuitStatus.Judge_Used_Twice);
}
if (CircuitComponent.IsSavedBefore(isSameYearCircuit, circuitData.CircuitName, circuitData.ID))
{
return(SaveCircuitStatus.Saved_Before);
}
circuitData.IsActive = isSameYearCircuit;
circuitData.IsFutureCircuit = !isSameYearCircuit;
using (var Transaction = BeginDatabaseTransaction())
{
PoliceComp.DeleteCircuitPoliceStations(circuitData.ID);
PoliceComp.SaveCircuitPoliceStations(circuitData.PoliceStations, circuitData.ID);
CircuitMembersComponent.EditCircuitJudges(circuitData.JudgesID, circuitData.ID, circuitData.CircuitStartDate);
//CircuitMembersComponent.DeleteCircuitMemberByCircuitID (circuitData.ID);
//CircuitMembersComponent.AddCircuitJudges ( circuitData.JudgesID ,circuitData.ID,circuitData.CircuitStartDate );
CircuitComponent.EditCircuit(circuitData);
if (Transaction != null)
{
Transaction.Commit();
}
return(SaveCircuitStatus.Saved_Successfully);
}
}
catch (DbEntityValidationException ex)
{
HandleException(ex);
return(SaveCircuitStatus.Failed_To_Save);
}
}
public vw_CircuitsGrid GetCircuitsFullDataByID(int CircuitID)
{
vw_CircuitsGrid CObj = CircuitComponent.GetCircuitsFullDataByID(CircuitID);
CObj.CircuitMembers = CircuitMembersComponent.GetCircuitMembersByCircuitID(CObj.ID);
CObj.PoliceStations = PsComponent.GetPoliceStationsByCircuitID(CObj.ID);
return(CObj);
}
public List <vw_CircuitsGrid> GetCircuitsFullData(int CourtID)
{
List <vw_CircuitsGrid> CircuitsList = CircuitComponent.GetCircuitsFullData(CourtID);
foreach (vw_CircuitsGrid CObj in CircuitsList)
{
CObj.CircuitMembers = CircuitMembersComponent.GetCircuitMembersByCircuitID(CObj.ID);
CObj.PoliceStations = PsComponent.GetPoliceStationsByCircuitID(CObj.ID);
}
return(CircuitsList);
}
public Deactive DeActivateUser(int UserID)
{
if (CircuitMembersComponent.IsCircuitMember(UserID) || CircuitsComponent.GetCircuitsBySecretairyID(UserID).Count > 0)
{
return(Deactive.CannotDeactive);
}
if (UserComponent.DeActivateUser(UserID) == Deactive.Deactive)
{
return(Deactive.Deactive);
}
else
{
return(Deactive.failed);
}
//else if (SystemConfigurations.Settings_InDevelopmentMode)
//{
// return Deactive.CannotDeactive;
// throw new ValidationExceptions("لا يمكن تعطيل مستخدم ضمن تشكيل حالي لدائرة");
//}
}
public DeleteUserStatus DeleteUser(int UserID)
{
try
{
if (CircuitMembersComponent.IsCircuitMember(UserID))
{
return(DeleteUserStatus.IsMember);
}
else if (CircuitsComponent.GetCircuitsBySecretairyID(UserID).Count > 0)
{
return(DeleteUserStatus.IsSecretary);
}
else
{
UserComponent.Delete(UserID);
return(DeleteUserStatus.Succeeded);
}
}
catch (Exception ex)
{
HandleException(ex);
return(DeleteUserStatus.Failed);
}
}
public SaveCircuitStatus AddCircuit(vw_CircuitData circuitData, out int CircuitID)
{
try
{
DateTime EndCircuitDate = new DateTime(DateTime.Today.Year, SystemConfigurations.Settings_CircuitEndMonth, SystemConfigurations.Settings_CircuitEndDay);
if (DateTime.Today > EndCircuitDate)
{
EndCircuitDate.AddYears(1);
}
bool isSameYearCircuit = (circuitData.CircuitStartDate < EndCircuitDate) ? true : false;
DateTime CircuitEndDate = new DateTime(circuitData.CircuitStartDate.Year, SystemConfigurations.Settings_CircuitEndMonth, SystemConfigurations.Settings_CircuitEndDay);
if (circuitData.CircuitStartDate > CircuitEndDate)
{
CircuitEndDate = circuitData.CircuitStartDate.AddYears(1);
}
if (ValidateJudges(circuitData.JudgesID))
{
CircuitID = 0;
return(SaveCircuitStatus.Judge_Used_Twice);
}
if (circuitData.SecretaryID == circuitData.AssistantSecretaryID)
{
CircuitID = 0;
return(SaveCircuitStatus.Secretary_Used_Twice);
}
if (CircuitComponent.IsSavedBefore(isSameYearCircuit, circuitData.CircuitName, circuitData.ID))
{
CircuitID = 0;
return(SaveCircuitStatus.Saved_Before);
}
circuitData.IsActive = isSameYearCircuit;
circuitData.IsFutureCircuit = !isSameYearCircuit;
if (circuitData.AssistantSecretaryID == 0)
{
circuitData.AssistantSecretaryID = null;
}
using (var Transaction = BeginDatabaseTransaction())
{
CircuitComponent.AddCircuit(circuitData, out CircuitID);
PoliceComp.SaveCircuitPoliceStations(circuitData.PoliceStations, CircuitID);
SaveCircuitStatus SaveJudgesStatus = CircuitMembersComponent.AddCircuitJudges(circuitData.JudgesID, CircuitID, circuitData.CircuitStartDate);
if (Transaction != null)
{
Transaction.Commit();
}
return(SaveCircuitStatus.Saved_Successfully);
}
}
catch (Exception ex)
{
CircuitID = 0;
HandleException(ex);
return(SaveCircuitStatus.Failed_To_Save);
}
}
