public ActionResult UpdatePresentence()
{
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
//initialise model repositry
PCMCaseModel Model = new PCMCaseModel();
//initialise view model
PCMPresentenceDetailsViewModel VM = new PCMPresentenceDetailsViewModel();
return(PartialView("GetPCMPresentense", VM));
}
public PCMPresentenceDetailsViewModel GetPresentenseList(int Presentence_Id)
{
PCMPresentenceDetailsViewModel fvm = new PCMPresentenceDetailsViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_Details act = db.PCM_Presentence_Details.Find(Presentence_Id);
fvm.Presentence_Id = act.Presentence_Id;
fvm.Court_id = act.Referral_Court_Id;
fvm.Date_Request_Received = act.Date_Request_Received;
fvm.Court_Appearance_Date = act.Court_Appearance_Date;
fvm.Date_Report_Submitted_To_Court = act.Date_Report_Submitted_To_Court;
fvm.Reasons_For_Non_Submission = act.Reasons_For_Non_Submission;
fvm.Sentencing_Options = act.Sentencing_Options;
fvm.Community_Based_Options_Id = act.Community_Based_Options_Id;
fvm.Restorective_Justice_Option_Id = act.Restorective_Justice_Option_Id;
fvm.Programme_Type_Id = act.Programme_Type_Id;
fvm.Programme_Id = act.Programme_Id;
fvm.Fine_or_Alternatives_To_Fine = act.Fine_or_Alternatives_To_Fine ?? false;
fvm.Fine_Alternatives_Fine_Comments = act.Fine_Alternatives_Fine_Comments;
fvm.Suspended_Postponed_Sentence_Id = act.Suspended_Postponed_Sentence_Id;
fvm.Commital_Treatment_Centre = act.Commital_Treatment_Centre ?? false;
fvm.Center_Name = act.Center_Name;
fvm.CYCCCenter_Name = act.Center_Name_CYCC;
fvm.Period_Commital_Treatment_Centre_From = act.Period_Commital_Treatment_Centre_From;
fvm.Period_Commital_Treatment_Centre_To = act.Period_Commital_Treatment_Centre_To;
fvm.Compulsory_esidence_CYCC = act.Compulsory_esidence_CYCC ?? false;
fvm.Compulsory_esidence_CYCC_From = act.Compulsory_esidence_CYCC_From;
fvm.Compulsory_esidence_CYCC_To = act.Compulsory_esidence_CYCC_To;
fvm.Imprisoment = act.Imprisoment ?? false;
fvm.Imprisoment_Id = act.Imprisoment_Id;
fvm.Imprisomen_From = act.Imprisomen_From;
fvm.Imprisomen_To = act.Imprisomen_To;
fvm.Department_Id = act.Department_Id;
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(fvm);
}
}
public void UpdatePresentence(PCMPresentenceDetailsViewModel cases, int userId, int Summary_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_Details editCase = db.PCM_Presentence_Details.Find(Summary_Id);
if (Summary_Id > 0)
{
editCase.Referral_Court_Id = cases.Court_id;
editCase.Date_Request_Received = cases.Date_Request_Received;
editCase.Court_Appearance_Date = cases.Court_Appearance_Date;
editCase.Date_Report_Submitted_To_Court = cases.Date_Report_Submitted_To_Court;
editCase.Reasons_For_Non_Submission = cases.Reasons_For_Non_Submission;
editCase.Sentencing_Options = cases.Sentencing_Options;
editCase.Community_Based_Options_Id = cases.Community_Based_Options_Id;
editCase.Restorective_Justice_Option_Id = cases.Restorective_Justice_Option_Id;
editCase.Programme_Type_Id = cases.Programme_Type_Id;
editCase.Programme_Id = cases.Programme_Id;
editCase.Fine_or_Alternatives_To_Fine = cases.Fine_or_Alternatives_To_Fine;
editCase.Fine_Alternatives_Fine_Comments = cases.Fine_Alternatives_Fine_Comments;
editCase.Suspended_Postponed_Sentence_Id = cases.Suspended_Postponed_Sentence_Id;
editCase.Commital_Treatment_Centre = cases.Commital_Treatment_Centre;
editCase.Center_Name = cases.Center_Name;
editCase.Center_Name_CYCC = cases.CYCCCenter_Name;
editCase.Period_Commital_Treatment_Centre_From = cases.Period_Commital_Treatment_Centre_From;
editCase.Period_Commital_Treatment_Centre_To = cases.Period_Commital_Treatment_Centre_To;
editCase.Compulsory_esidence_CYCC = cases.Compulsory_esidence_CYCC;
editCase.Compulsory_esidence_CYCC_From = cases.Compulsory_esidence_CYCC_From;
editCase.Compulsory_esidence_CYCC_To = cases.Compulsory_esidence_CYCC_To;
editCase.Imprisoment = cases.Imprisoment;
editCase.Imprisoment_Id = cases.Imprisoment_Id;
editCase.Imprisomen_From = cases.Imprisomen_From;
editCase.Imprisomen_To = cases.Imprisomen_To;
editCase.Department_Id = cases.Department_Id;
editCase.Date_Modified = DateTime.Now;
editCase.Modified_By = userId;
}
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
public void UpdateSentenseDetails(PCMPresentenceDetailsViewModel vm, int Sentence_Id, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_OutCome newCase = db.PCM_Presentence_OutCome.Find(Sentence_Id);
newCase.Sentence_Id = Sentence_Id;
newCase.Court_Date = vm.Court_Date;
newCase.Reason_for_Remand = vm.Reason_for_Remand;
newCase.NextCourtDate = vm.NextCourtDate;
newCase.Court_Outcome = vm.Court_Outcome;
newCase.Community_Based_Options_Id = vm.Community_Based_Options_Id;
newCase.Restorective_Justice_Option_Id = vm.Restorective_Justice_Option_Id;
newCase.Programme_Type_Id = vm.Programme_Type_Id;
newCase.Programme_Id = vm.Programme_Id;
newCase.Fine_or_Alternatives_To_Fine = vm.Fine_or_Alternatives_To_Fine;
newCase.Fine_Alternatives_Fine_Comments = vm.Fine_Alternatives_Fine_Comments;
newCase.Suspended_Postponed_Sentence_Id = vm.Suspended_Postponed_Sentence_Id;
newCase.Commital_Treatment_Centre = vm.Commital_Treatment_Centre;
newCase.Center_Name = vm.Center_Name;
newCase.Center_Name_CYCC = vm.CYCCCenter_Name;
newCase.Period_Commital_Treatment_Centre_From = vm.Period_Commital_Treatment_Centre_From;
newCase.Period_Commital_Treatment_Centre_To = vm.Period_Commital_Treatment_Centre_To;
newCase.Compulsory_esidence_CYCC = vm.Compulsory_esidence_CYCC;
newCase.Compulsory_esidence_CYCC_From = vm.Compulsory_esidence_CYCC_From;
newCase.Compulsory_esidence_CYCC_To = vm.Compulsory_esidence_CYCC_To;
newCase.Imprisoment = vm.Imprisoment;
newCase.Imprisoment_Id = vm.Imprisoment_Id;
newCase.Imprisomen_From = vm.Imprisomen_From;
newCase.Imprisomen_To = vm.Imprisomen_To;
newCase.Department_Id = vm.Department_Id;
newCase.PCM_Case_Status_Id = vm.PCM_Case_Status_Id;
newCase.Modified_By = userId;
newCase.Date_Modified = DateTime.Now;
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
public JsonResult SaveSentenseInDatabase(PCMPresentenceDetailsViewModel vm)
{
int Id = Convert.ToInt32(vm.Sentence_Id);// pass the right
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
var result = false;
int caseid = Convert.ToInt32(Session["IntakeassId"]);
PCMPresentenceModel Model = new PCMPresentenceModel();
try
{
if (vm.Sentence_Id > 0)
{
Model.UpdateSentenseDetails(vm, Id, userId);
result = true;
}
else
{
Model.CreateSentenseDeatils(vm, caseid, userId);
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdatePresentenceSummaries(PCMPresentenceDetailsViewModel caseVM)
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
int id = Convert.ToInt32(Session["IntakeassId"]);
int idcreate = Convert.ToInt32(Session["NewId"]);
int Idupdate = Convert.ToInt32(Session["Idc1"]);
int Id;
if (Idupdate != 0)
{
Id = Idupdate;
}
else
{
Id = idcreate;
}
//instanciate model repositry
PCMPresentenceModel Model = new PCMPresentenceModel();
if (ModelState.IsValid)
{
// Call Update Function
Model.UpdatePresentenceSummaries(caseVM, userId, Id);
ViewBag.Message = "Updated successfully";
}
else
{
ViewBag.Message = "not updated ";
}
//return View("UpdatePCMCase", caseVM);
return(RedirectToAction("IndexPre", "Assessment", new { Id = id }));
}
public List <PCMPresentenceDetailsViewModel> GetSentenseList(int IntakeassId)
{
// initialising view model
List <PCMPresentenceDetailsViewModel> avm = new List <PCMPresentenceDetailsViewModel>();
// initialise connection
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
// get work list for user logged in
var ListP = (
from p in db.Persons
join c in db.Clients on p.Person_Id equals c.Person_Id
join i in db.Intake_Assessments on c.Client_Id equals i.Client_Id
join Case in db.PCM_Presentence_OutCome on i.Intake_Assessment_Id equals Case.Intake_Assessment_Id
join status in db.apl_PCM_Case_Status on Case.PCM_Case_Status_Id equals status.PCM_Case_Status_Id
where i.Intake_Assessment_Id.Equals(IntakeassId)
select new
{
i.Intake_Assessment_Id,
Case.Sentence_Id,
Case.Court_Date,
Case.NextCourtDate,
Case.PCM_Case_Status_Id,
Case.Court_Outcome
}).ToList();
foreach (var item in ListP)
{
// initialising view model
PCMPresentenceDetailsViewModel obj = new PCMPresentenceDetailsViewModel();
obj.Intake_Assessment_Id = item.Intake_Assessment_Id;
obj.Sentence_Id = item.Sentence_Id;
obj.Court_Date = item.Court_Date;
obj.NextCourtDate = item.NextCourtDate;
obj.Court_Outcome = item.Court_Outcome;
obj.SelectCaseStatusDetails = db.apl_PCM_Case_Status.Find(item.PCM_Case_Status_Id).Description;
avm.Add(obj);
}
return(avm);
}
public JsonResult GetSentenseById(int Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
PCMPresentenceModel Model = new PCMPresentenceModel();
//initialise view model
PCMPresentenceDetailsViewModel vm = new PCMPresentenceDetailsViewModel();
vm.CommunityBasedOptions_List = Model.GetCommunityBasedOption();
vm.SupendedPostponedSentence_List = Model.GetSupendedPostponedSentence();
vm.CaseStatus_List = Model.GetCaseStatus();//..................?
vm.RestorectiveJustice_List = Model.GetRestorectiveJustice();
vm.ProgrammeType_List = Model.GetProgrammeType();
vm.Programme_List = Model.GetProgramme();
vm.Imprisoment_List = Model.GetImprisoment();//..................?
vm.Department_List = Model.GetDepartment();
vm.Court_List = Model.GetAllCourt();
vm.Province_List = Model.GetAllProvinces();
vm.District_List = Model.GetAllDistrict();
ViewBag.CommunityBasedOptions = new SelectList(db.apl_PCM_Community_Based_Options.ToList(), "Community_Based_Options_Id", "Description");
ViewBag.SupendedPostponedSentence = new SelectList(db.apl_PCM_Supended_Postponed_Sentence.ToList(), "Suspended_Postponed_Sentence_Id", "Description");
ViewBag.CaseStatus = new SelectList(db.apl_PCM_Case_Status.ToList(), "PCM_Case_Status_Id", "Description");
ViewBag.RestorectiveJustice = new SelectList(db.apl_Restorective_Justice_Types.ToList(), "Restorective_Justice_Option_Id", "Description");
ViewBag.ProgrammeType = new SelectList(db.apl_Programme_Type.ToList(), "Programme_Type_Id", "Description");
ViewBag.Programme = new SelectList(db.apl_Programmes.ToList(), "Programme_Type_Id", "Programme_Name");
ViewBag.Imprisoment = new SelectList(db.apl_PCM_Imprisoment.ToList(), "Imprisoment_Id", "Description");
ViewBag.Department = new SelectList(db.apl_Department.ToList(), "Department_Id", "Description");
ViewBag.Province = new SelectList(db.Provinces.ToList(), "Province_Id", "Description");
ViewBag.District = new SelectList(db.Districts.ToList(), "District_Id", "Description");
ViewBag.Court = new SelectList(db.Courts.ToList(), "Court_Id", "Description");
vm = Model.GetPCMSentenseOnEditDetails(Id);
string value = string.Empty;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
}
public void CreateSentenseDeatils(PCMPresentenceDetailsViewModel vm, int caseid, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_OutCome newCase = new PCM_Presentence_OutCome();
newCase.Court_Date = vm.Court_Date;
newCase.Reason_for_Remand = vm.Reason_for_Remand;
newCase.NextCourtDate = vm.NextCourtDate;
newCase.Court_Outcome = vm.Court_Outcome;
newCase.Community_Based_Options_Id = vm.Community_Based_Options_Id;
newCase.Restorective_Justice_Option_Id = vm.Restorective_Justice_Option_Id;
newCase.Programme_Type_Id = vm.Programme_Type_Id;
newCase.Programme_Id = vm.Programme_Id;
newCase.Fine_or_Alternatives_To_Fine = vm.Fine_or_Alternatives_To_Fine;
newCase.Fine_Alternatives_Fine_Comments = vm.Fine_Alternatives_Fine_Comments;
newCase.Suspended_Postponed_Sentence_Id = vm.Suspended_Postponed_Sentence_Id;
newCase.Commital_Treatment_Centre = vm.Commital_Treatment_Centre;
newCase.Center_Name = vm.Center_Name;
newCase.Center_Name_CYCC = vm.CYCCCenter_Name;
newCase.Period_Commital_Treatment_Centre_From = vm.Period_Commital_Treatment_Centre_From;
newCase.Period_Commital_Treatment_Centre_To = vm.Period_Commital_Treatment_Centre_To;
newCase.Compulsory_esidence_CYCC = vm.Compulsory_esidence_CYCC;
newCase.Compulsory_esidence_CYCC_From = vm.Compulsory_esidence_CYCC_From;
newCase.Compulsory_esidence_CYCC_To = vm.Compulsory_esidence_CYCC_To;
newCase.Imprisoment = vm.Imprisoment;
newCase.Imprisoment_Id = vm.Imprisoment_Id;
newCase.Imprisomen_From = vm.Imprisomen_From;
newCase.Imprisomen_To = vm.Imprisomen_To;
newCase.Department_Id = vm.Department_Id;
newCase.PCM_Case_Status_Id = vm.PCM_Case_Status_Id;
newCase.Created_By = userId;
newCase.Date_Created = DateTime.Now;
newCase.Intake_Assessment_Id = caseid;
db.PCM_Presentence_OutCome.Add(newCase);
db.SaveChanges();
}
catch
{
}
}
}
public JsonResult ListSentense()
{
int caseid = Convert.ToInt32(Session["IntakeassId"]);
PCMPresentenceModel Model = new PCMPresentenceModel();
//initialise view model
PCMPresentenceDetailsViewModel VM = new PCMPresentenceDetailsViewModel();
List <PCMPresentenceDetailsViewModel> List = Model.GetSentenseList(caseid).Select(x => new PCMPresentenceDetailsViewModel
{
Intake_Assessment_Id = x.Intake_Assessment_Id,
Sentence_Id = x.Sentence_Id,
Court_Date = x.Court_Date,
NextCourtDate = x.NextCourtDate,
SelectCaseStatusDetails = x.SelectCaseStatusDetails
}).ToList();
return(Json(List, JsonRequestBehavior.AllowGet));
}
public void UpdatePresentenceSummaries(PCMPresentenceDetailsViewModel cases, int userId, int Summary_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_Summaries editCase = db.PCM_Presentence_Summaries.Find(Summary_Id);
if (Summary_Id > 0)
{
/****** Script for SelectTopNRows command from SSMS ******/
editCase.Education_Sammary = cases.Education_Sammary;
editCase.IsAssessed = cases.IsAssessed;
editCase.Offence_Sammary = cases.Offence_Sammary;
editCase.Victim_Sammary = cases.Victim_Sammary;
editCase.Date_Modified = DateTime.Now;
editCase.Modified_By = userId;
}
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
public PCMPresentenceDetailsViewModel GetPresentenseSummaryList(int Summary_Id)
{
PCMPresentenceDetailsViewModel fvm = new PCMPresentenceDetailsViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_Summaries act = db.PCM_Presentence_Summaries.Find(Summary_Id);
fvm.Presentence_Summary_Id = act.Presentence_Summary_Id;
fvm.Education_Sammary = act.Education_Sammary;
fvm.Offence_Sammary = act.Offence_Sammary;
fvm.Victim_Sammary = act.Victim_Sammary;
fvm.IsAssessed = act.IsAssessed;
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(fvm);
}
}
public void InsertPresentenceSummaries(PCMPresentenceDetailsViewModel cases, int intassid, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_Summaries newCase = new PCM_Presentence_Summaries();
newCase.Intake_Assessment_Id = intassid;
newCase.Education_Sammary = cases.Education_Sammary;
newCase.Offence_Sammary = cases.Offence_Sammary;
newCase.Victim_Sammary = cases.Victim_Sammary;
newCase.Created_By = userId;
newCase.Date_Created = DateTime.Now;
db.PCM_Presentence_Summaries.Add(newCase);
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
public ActionResult checkAssessmentId(int assID)
{
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
////instanciate model
PCMPresentenceModel pcmcasemodel = new PCMPresentenceModel();
////instanciate viewmodel
PCMPresentenceDetailsViewModel pcmcasevm = new PCMPresentenceDetailsViewModel();
int SummId = pcmcasemodel.GetPCMPresentenseSummaryByassId(assID);
if (SummId != 0)
{
return(PartialView(pcmcasevm));
}
else
{
return(PartialView(pcmcasevm));
}
}
public ActionResult GetPCMPresentense()
{
int intassid = Convert.ToInt32(Session["IntakeassId"]);
// get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
PCMCaseModel caseModelC = new PCMCaseModel();
string ClientRef = Convert.ToString(Session["ClientRef"]);
ViewBag.ModuleRef = ClientRef;
PCMPresentenceModel Model = new PCMPresentenceModel();
//initialise view model
PCMPresentenceDetailsViewModel VM = new PCMPresentenceDetailsViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
int Presentenseid = Model.GetPCMPresentenseByassId(intassid);
if (Presentenseid != 0)
{
VM = Model.GetPresentenseList(Presentenseid);
//populate dropdown lists
VM.CommunityBasedOptions_List = Model.GetCommunityBasedOption();
VM.SupendedPostponedSentence_List = Model.GetSupendedPostponedSentence();
VM.CaseStatus_List = Model.GetCaseStatus();//..................?
VM.RestorectiveJustice_List = Model.GetRestorectiveJustice();
VM.ProgrammeType_List = Model.GetProgrammeType();
VM.Programme_List = Model.GetProgramme();
VM.Imprisoment_List = Model.GetImprisoment();//..................?
VM.Department_List = Model.GetDepartment();
VM.Court_List = Model.GetAllCourt();
VM.Province_List = Model.GetAllProvinces();
VM.District_List = Model.GetAllDistrict();
if (Convert.ToInt32(Model.GetPresentenseList(Presentenseid).Court_id) != 0)
{
int Courtid = Convert.ToInt32(Model.GetPresentenseList(Presentenseid).Court_id);
ViewBag.Court = db.Courts.Find(Courtid).Description;
//Get District using the court..........................................
int DistrictId = (from k in db.Districts
join k1 in db.Courts on k.District_Id equals k1.District_Id
where k1.Court_Id == Courtid
select k.District_Id).FirstOrDefault();
ViewData["district"] = new SelectList(db.Districts, "District_Id", "Description", DistrictId).ToList();
//Get Province using the District..........................................
int ProvinceId = (from a in db.Districts
join b in db.Provinces on a.Province_Id equals b.Province_Id
where a.District_Id.Equals(DistrictId)
select b.Province_Id).FirstOrDefault();
ViewData["province"] = new SelectList(db.Provinces, "Province_Id", "Description", ProvinceId).ToList();
}
Session["presentdate"] = Presentenseid;
return(PartialView(VM));
}
else
{
PCMPresentenceModel Model1 = new PCMPresentenceModel();
PCMPresentenceDetailsViewModel VM1 = new PCMPresentenceDetailsViewModel();
//initialise view model
VM1.CommunityBasedOptions_List = Model.GetCommunityBasedOption();
VM1.SupendedPostponedSentence_List = Model.GetSupendedPostponedSentence();
VM1.CaseStatus_List = Model.GetCaseStatus();//..................?
VM1.RestorectiveJustice_List = Model.GetRestorectiveJustice();
VM1.ProgrammeType_List = Model.GetProgrammeType();
VM1.Programme_List = Model.GetProgramme();
VM1.Imprisoment_List = Model.GetImprisoment();//..................?
VM1.Department_List = Model.GetDepartment();
VM1.Court_List = Model.GetAllCourt();
VM1.Province_List = Model.GetAllProvinces();
VM1.District_List = Model.GetAllDistrict();
//funtion that calls insert Socio Economy
Model1.InsertPresentence(VM1, intassid, userId);
PCMPresentenceDetailsViewModel VM2 = new PCMPresentenceDetailsViewModel();
int Presentenceidadd = Model.GetPCMPresentenseByassId(intassid);
VM2 = Model1.GetPresentenseList(Presentenceidadd);
VM2.CommunityBasedOptions_List = Model.GetCommunityBasedOption();
VM2.SupendedPostponedSentence_List = Model.GetSupendedPostponedSentence();
VM2.CaseStatus_List = Model.GetCaseStatus();//..................?
VM2.RestorectiveJustice_List = Model.GetRestorectiveJustice();
VM2.ProgrammeType_List = Model.GetProgrammeType();
VM2.Programme_List = Model.GetProgramme();
VM2.Imprisoment_List = Model.GetImprisoment();//..................?
VM2.Department_List = Model.GetDepartment();
VM2.Court_List = Model.GetAllCourt();
VM2.Province_List = Model.GetAllProvinces();
VM2.District_List = Model.GetAllDistrict();
Session["presentadd"] = Presentenceidadd;
return(PartialView("GetPCMPresentense", VM2));
}
}
}
public ActionResult GetPCMPresentenseSummaryDetails(int id)
{
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
//initialise model repositry
PCMPresentenceModel Model = new PCMPresentenceModel();
//initialise view model
PCMCaseModel caseModelC = new PCMCaseModel();
string ClientRef = Convert.ToString(Session["ClientRef"]);
ViewBag.ModuleRef = ClientRef;
int PreSummaryID = Model.GetPCMPresentenseSummaryByassId(id);
if (PreSummaryID != 0)
{
PCMPresentenceDetailsViewModel VM1 = new PCMPresentenceDetailsViewModel();
VM1 = Model.GetPresentenseSummaryList(PreSummaryID);//.............................?
Session["Idc1"] = PreSummaryID;
Session["IntakeassId"] = id;
return(PartialView(VM1));
}
else
{
PCMPresentenceModel Model1 = new PCMPresentenceModel();
PCMPresentenceDetailsViewModel VM = new PCMPresentenceDetailsViewModel();
//initialise view model
PCMPresentenceDetailsViewModel VMC = new PCMPresentenceDetailsViewModel();
Model.InsertPresentenceSummaries(VM, id, userId);
int PreSummaryID1 = Model1.GetPCMPresentenseSummaryByassId(id);
VMC = Model1.GetPresentenseSummaryList(PreSummaryID1);
Session["NewId"] = id;
Session["IntakeassId"] = id;
return(PartialView(VMC));
}
}
public PCMPresentenceDetailsViewModel GetPCMSentenseOnEditDetails(int Sentence_Id)
{
PCMPresentenceDetailsViewModel vm = new PCMPresentenceDetailsViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Presentence_OutCome act = db.PCM_Presentence_OutCome.Find(Sentence_Id);
if (act != null)
{
vm.Sentence_Id = act.Sentence_Id;
vm.Court_Date = act.Court_Date;
vm.Reason_for_Remand = act.Reason_for_Remand;
vm.NextCourtDate = act.NextCourtDate;
vm.Court_Outcome = act.Court_Outcome;
vm.Community_Based_Options_Id = act.Community_Based_Options_Id;
if (act.Community_Based_Options_Id != null)
{
vm.SelectCommunityBasedOptionsDetails = db.apl_PCM_Community_Based_Options.Find(act.Community_Based_Options_Id).Description;
}
vm.Restorective_Justice_Option_Id = act.Restorective_Justice_Option_Id;
if (act.Restorective_Justice_Option_Id != null)
{
vm.SelectRestorectiveJusticeDetails = db.apl_Restorective_Justice_Types.Find(act.Restorective_Justice_Option_Id).Description;
}
vm.Programme_Type_Id = act.Programme_Type_Id;
if (act.Programme_Type_Id != null)
{
vm.SelectProgrammeTypeDetails = db.apl_Programme_Type.Find(act.Programme_Type_Id).Description;
}
vm.Programme_Id = act.Programme_Id;
if (act.Programme_Id != null)
{
vm.SelectProgrammeDetails = db.apl_Programmes.Find(act.Programme_Id).Programme_Name;
}
vm.Fine_or_Alternatives_To_Fine = act.Fine_or_Alternatives_To_Fine ?? false;
vm.Fine_Alternatives_Fine_Comments = act.Fine_Alternatives_Fine_Comments;
vm.Suspended_Postponed_Sentence_Id = act.Suspended_Postponed_Sentence_Id;
if (act.Suspended_Postponed_Sentence_Id != null)
{
vm.SelectSupendedPostponedSentenceDetails = db.apl_PCM_Supended_Postponed_Sentence.Find(act.Suspended_Postponed_Sentence_Id).Description;
}
vm.Commital_Treatment_Centre = act.Commital_Treatment_Centre ?? false;;
vm.Center_Name = act.Center_Name;
vm.CYCCCenter_Name = act.Center_Name_CYCC;
vm.Period_Commital_Treatment_Centre_From = act.Period_Commital_Treatment_Centre_From;
vm.Period_Commital_Treatment_Centre_To = act.Period_Commital_Treatment_Centre_To;
vm.Compulsory_esidence_CYCC = act.Compulsory_esidence_CYCC ?? false;
vm.Compulsory_esidence_CYCC_From = act.Compulsory_esidence_CYCC_From;
vm.Compulsory_esidence_CYCC_To = act.Compulsory_esidence_CYCC_To;
vm.Imprisoment = act.Imprisoment ?? false;
vm.Imprisoment_Id = act.Imprisoment_Id;
if (act.Imprisoment_Id != null)
{
vm.SelectImprisomentDetails = db.apl_PCM_Imprisoment.Find(act.Imprisoment_Id).Description;
}
vm.Imprisomen_From = act.Imprisomen_From;
vm.Imprisomen_To = act.Imprisomen_To;
vm.Department_Id = act.Department_Id;
if (act.Department_Id != null)
{
vm.SelectDepartmentDetails = db.apl_Department.Find(act.Department_Id).Description;
}
vm.PCM_Case_Status_Id = act.PCM_Case_Status_Id;
if (act.PCM_Case_Status_Id != null)
{
vm.SelectCaseStatusDetails = db.apl_PCM_Case_Status.Find(act.PCM_Case_Status_Id).Description;
}
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(vm);
}
}
public ActionResult SentenseList()
{
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
int caseid = Convert.ToInt32(Session["IntakeassId"]);
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
string ClientRef = Convert.ToString(Session["ClientRef"]);
ViewBag.ModuleRef = ClientRef;
PCMPresentenceModel Model = new PCMPresentenceModel();
//initialise view model
PCMPresentenceDetailsViewModel VM = new PCMPresentenceDetailsViewModel();
VM.CommunityBasedOptions_List = Model.GetCommunityBasedOption();
VM.SupendedPostponedSentence_List = Model.GetSupendedPostponedSentence();
VM.CaseStatus_List = Model.GetCaseStatus();//..................?
VM.RestorectiveJustice_List = Model.GetRestorectiveJustice();
VM.ProgrammeType_List = Model.GetProgrammeType();
VM.Programme_List = Model.GetProgramme();
VM.Imprisoment_List = Model.GetImprisoment();//..................?
VM.Department_List = Model.GetDepartment();
VM.Court_List = Model.GetAllCourt();
VM.Province_List = Model.GetAllProvinces();
VM.District_List = Model.GetAllDistrict();
ViewBag.CommunityBasedOptions = new SelectList(db.apl_PCM_Community_Based_Options.ToList(), "Community_Based_Options_Id", "Description");
ViewBag.SupendedPostponedSentence = new SelectList(db.apl_PCM_Supended_Postponed_Sentence.ToList(), "Suspended_Postponed_Sentence_Id", "Description");
ViewBag.CaseStatus = new SelectList(db.apl_PCM_Case_Status.ToList(), "PCM_Case_Status_Id", "Description");
ViewBag.RestorectiveJustice = new SelectList(db.apl_Restorective_Justice_Types.ToList(), "Restorective_Justice_Option_Id", "Description");
ViewBag.ProgrammeType = new SelectList(db.apl_Programme_Type.ToList(), "Programme_Type_Id", "Description");
ViewBag.Programme = new SelectList(db.apl_Programmes.ToList(), "Programme_Type_Id", "Programme_Name");
ViewBag.Imprisoment = new SelectList(db.apl_PCM_Imprisoment.ToList(), "Imprisoment_Id", "Description");
ViewBag.Department = new SelectList(db.apl_Department.ToList(), "Department_Id", "Description");
ViewBag.Province = new SelectList(db.Provinces.ToList(), "Province_Id", "Description");
ViewBag.District = new SelectList(db.Districts.ToList(), "District_Id", "Description");
ViewBag.Court = new SelectList(db.Courts.ToList(), "Court_Id", "Description");
return(PartialView(VM));
}
