public List <PCMDiversionViewModel> getProgramme()
{
List <PCMDiversionViewModel> vm = new List <PCMDiversionViewModel>();
var p = (from p1 in db.PCM_Diversion_P
join p2 in db.PCM_D_Programme
on p1.Programme_Id equals p2.Programme_Id
join p3 in db.PCM_Diversion_SP
on p1.S_P_Id equals p3.S_P_Id
select new { p1.P_Id,
p1.S_P_Id,
p1.Programme_Id,
p2.Programme_name,
p2.Programme_Status,
p2.Programme_Expiry_Date,
p2.Services_Provider_Id }).ToList();
foreach (var item in p)
{
PCMDiversionViewModel obj = new PCMDiversionViewModel();
obj.P_Id = item.P_Id;
//obj.S_P_Id = item.S_P_Id;
obj.Programme_Id = item.Programme_Id;
obj.Programme_name = item.Programme_name;
obj.Programme_Expiry_Date = item.Programme_Expiry_Date;
obj.Services_Provider_Id = item.Services_Provider_Id;
vm.Add(obj);
}
return(vm);
}
public JsonResult GetPCMDivesionDetails()
{
//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;
}
}
int assID = Convert.ToInt32(Session["IntakeassId"]);
PCMDiversionViewModel VM = new PCMDiversionViewModel();
PCMDiversionModel Model = new PCMDiversionModel();
VM.ProgrammeAgeGroup_List = Model.GetProgrammeAgeGroup();
VM.ProgrammeLevel_List = Model.GetProgrammeLevel();
return(Json(m.GetSelectedDivesionFromDBDiv(assID), JsonRequestBehavior.AllowGet));
}
public ActionResult DiversionAdd(PCMDiversionViewModel vm)
{
var m = new PCMDiversionModel();
m.DiversionAdd(vm, 6, 28377);
ViewBag.Message = "Saved successfully";
return(PartialView());
}
public PCMDiversionViewModel GetDivesionFromDBDivbyId(int Diversion_Id)
{
PCMDiversionViewModel vm = new PCMDiversionViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Diversion act = db.PCM_Diversion.Find(Diversion_Id);
if (act != null)
{
vm.Diversion_Id = act.Diversion_Id;
vm.Source_Referral_Id = act.Source_Referral_Id;
if (act.Source_Referral_Id > 0)
{
vm.RefSourcedesrciption = db.apl_PCM_Referral_Source.Find(act.Source_Referral_Id).Description;
}
vm.Programme_Id = act.Programme_id;
if (act.Programme_id > 0)
{
vm.DesrciptionDivesionPrograme = db.apl_Programmes.Find(act.Programme_id).Programme_Name;
}
vm.No_Modules = act.No_Modules;
vm.Programme_Level_Id = act.Programme_Level_Id;
vm.Modified_By = act.Modified_By;
vm.Date_Modified = act.Date_Modified;
vm.Court_Type_Id = act.Court_Type_Id;
vm.PCM_Preliminary_Id = act.PCM_Preliminary_Id;
vm.Formal_Courtcome_Id = act.Formal_Courtcome_Id;
vm.Childrens_Court_Outcome_Id = act.Childrens_Court_Outcome_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(vm);
}
}
public PCMDiversionViewModel GetUpdateDiversion_M(int mId)
{
PCMDiversionViewModel vm = new PCMDiversionViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from m in db.PCM_Diversion_M
where (m.M_Id == mId)
select m.M_Id).FirstOrDefault();
PCM_Diversion_M mm = db.PCM_Diversion_M.Find(id);
if (mm != null)
{
vm.M_Id = db.PCM_Diversion_M.Find(mm.M_Id).M_Id;
vm.P_Id = mm.P_Id;
vm.Modules_Id = mm.Modules_Id;
vm.No_Module = mm.No_Module;
vm.Sessions = mm.Sessions;
vm.No_Sessions = mm.No_Sessions;
vm.Session_StartDate = mm.Session_StartDate;
vm.Session_EndDate = mm.Session_EndDate;
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;
}
return(vm);
}
}
public JsonResult SaveDiversionProgram(PCMDiversionViewModel prVM)
{
//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 AddEditValue = Convert.ToInt32(Session["AddEditValue"]);
int assID = Convert.ToInt32(Session["IntakeassId"]);
try
{
if (AddEditValue == 0)
{
m.UpdatePCMDivesionsDeatils(prVM, prVM.Diversion_Id, userId);
result = true;
}
else
{
m.PCM_Diversion_SPAddnew(prVM, assID, userId);
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void DiversionAdd(PCMDiversionViewModel vm, int userid, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Diversion DiversionNew = db.PCM_Diversion.Find(Intake_Assessment_Id);
if (DiversionNew != null)
{
DiversionNew.Intake_Assessment_Id = vm.Intake_Assessment_Id;
DiversionNew.Source_Referral_Id = vm.Source_Referral;
DiversionNew.Province_Id = vm.Province_Id;
DiversionNew.Service_Provider_Category = vm.Service_Provider_Category;
DiversionNew.Services_Provider_Id = vm.Services_Provider_Id;
DiversionNew.Programme_id = vm.Programme_Id;
DiversionNew.No_Modules = vm.No_Modules;
DiversionNew.Programme_Level_Id = vm.Programme_Level_Id;
DiversionNew.Created_By = userid;
DiversionNew.Date_Created = DateTime.Now;
DiversionNew.Modified_By = userid;
DiversionNew.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 void PCM_Diversion_SPAddnew(PCMDiversionViewModel vm, int Intake_Assessment_Id, int userid)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Diversion _SP = new PCM_Diversion();
_SP.Intake_Assessment_Id = Intake_Assessment_Id;
_SP.Source_Referral_Id = vm.Source_Referral;
_SP.Programme_Level_Id = vm.Programme_Level_Id;
_SP.Programme_AgeGroup_Id = vm.Programme_AgeGroup_Id;
_SP.Programme_id = vm.Programme_Id;
_SP.Created_By = userid;
_SP.Childrens_Court_Outcome_Id = vm.Childrens_Court_Outcome_Id;
_SP.PCM_Preliminary_Id = vm.PCM_Preliminary_Id;
_SP.Formal_Courtcome_Id = vm.Formal_Courtcome_Id;
_SP.Court_Type_Id = vm.Court_Type_Id;
_SP.Diversion_Id = vm.Diversion_Id;
_SP.Date_Created = DateTime.Now;
_SP.Created_By = userid;
db.PCM_Diversion.Add(_SP);
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 AddUpdate(PCMDiversionViewModel dvm)
{
var result = false;
try
{
if (dvm.M_Id > 0)
{
}
else
{
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public List <PCMDiversionViewModel> GetDiversion_M()
{
List <PCMDiversionViewModel> vm = new List <PCMDiversionViewModel>();
var mList = (from m1 in db.PCM_Diversion_M
join d1 in db.PCM_Diversion_P
on m1.P_Id equals d1.P_Id
join sp1 in db.PCM_Diversion_SP
on d1.S_P_Id equals sp1.S_P_Id
join sp2 in db.PCM_D_ServicesProvider
on sp1.Services_Provider_Id equals sp2.Services_Provider_Id
join p in db.Provinces
on sp2.Province_Id equals p.Province_Id
join pr1 in db.PCM_D_Programme
on d1.Programme_Id equals pr1.Programme_Id
select new {
m1.M_Id,
//m1.Module,
m1.Sessions,
m1.Session_StartDate,
m1.Session_EndDate,
pr1.Programme_name,
pr1.Programme_Status
}).ToList();
foreach (var item in mList)
{
PCMDiversionViewModel obj = new PCMDiversionViewModel();
obj.M_Id = item.M_Id;
//obj.Module = item.Module;
obj.Sessions = item.Sessions;
obj.Session_StartDate = item.Session_StartDate;
obj.Session_EndDate = item.Session_EndDate;
obj.Programme_name = item.Programme_name;
obj.Programme_Status = item.Programme_Status;
vm.Add(obj);
}
return(vm);
}
public void UpdateDiversion_M(PCMDiversionViewModel vm, int mId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Diversion_M mm = db.PCM_Diversion_M.Find(mId);
mm.P_Id = vm.P_Id;
mm.Modules_Id = vm.Modules_Id;
mm.No_Module = vm.No_Module;
mm.Sessions = vm.Sessions;
mm.No_Sessions = vm.No_Sessions;
mm.Session_StartDate = vm.Session_StartDate;
mm.Session_EndDate = vm.Session_EndDate;
db.SaveChanges();
}
catch
{
}
}
}
public void CreateDiversion_M(PCMDiversionViewModel vm)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Diversion_M m = new PCM_Diversion_M();
m.P_Id = vm.P_Id;
m.Modules_Id = vm.Modules_Id;
m.No_Module = vm.No_Module;
m.Sessions = vm.Sessions;
m.No_Sessions = vm.No_Sessions;
m.Session_StartDate = vm.Session_StartDate;
m.Session_EndDate = vm.Session_EndDate;
db.PCM_Diversion_M.Add(m);
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 List <PCMDiversionViewModel> GetSelectedDivesionFromDBDiv(int Intake_Assessment_Id)
{
List <PCMDiversionViewModel> avm = new List <PCMDiversionViewModel>();
// initialise connection
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
// get work list for user logged in
var orderList =
(from r in db.PCM_Diversion
join rt in db.Intake_Assessments on r.Intake_Assessment_Id equals rt.Intake_Assessment_Id
join ot in db.apl_Programmes on r.Programme_id equals ot.Programme_Id into empty1
from ed in empty1.DefaultIfEmpty()
join so in db.apl_PCM_Referral_Source on r.Source_Referral_Id equals so.Source_Referral_Id into empty2
from ed1 in empty2.DefaultIfEmpty()
join co in db.apl_PCM_Court_Type on r.Court_Type_Id equals co.Court_Type_Id into empty3
from ed3 in empty3.DefaultIfEmpty()
join le in db.apl_Programme_Level on r.Programme_Level_Id equals le.Programme_Level_Id into empty4
from ed4 in empty4.DefaultIfEmpty()
where (r.Intake_Assessment_Id == Intake_Assessment_Id)
select new
{
r.Intake_Assessment_Id,
Programme_Id = ed == null ? 0 : ed.Programme_Id,
Source_Referral_Id = ed1 == null?0 : ed1.Source_Referral_Id,
r.Diversion_Id,
Court_Type_Id = ed3 == null? 0: ed3.Court_Type_Id,
r.Childrens_Court_Outcome_Id,
r.Formal_Courtcome_Id,
r.PCM_Preliminary_Id,
Programme_Level_Id = ed4 == null? 0: ed4.Programme_Level_Id
}).ToList();
;
foreach (var item in orderList)
{
// initialising view model
PCMDiversionViewModel obj = new PCMDiversionViewModel();
obj.Diversion_Id = item.Diversion_Id;
if (item.Programme_Id != 0)
{
obj.DesrciptionDivesionPrograme = db.apl_Programmes.Find(item.Programme_Id).Programme_Name;
}
else
{
obj.DesrciptionDivesionPrograme = "None";
}
obj.Court_Type_Id = item.Court_Type_Id;
obj.DesrciptionCourttype = db.apl_PCM_Court_Type.Find(item.Court_Type_Id).Description;
obj.PCM_Preliminary_Id = item.PCM_Preliminary_Id;
obj.Formal_Courtcome_Id = item.Formal_Courtcome_Id;
obj.Childrens_Court_Outcome_Id = item.Childrens_Court_Outcome_Id;
if (item.Source_Referral_Id != 0)
{
obj.RefSourcedesrciption = db.apl_PCM_Referral_Source.Find(item.Source_Referral_Id).Description;
}
else
{
obj.RefSourcedesrciption = "None";
}
if (item.Programme_Level_Id != 0)
{
obj.Levels = db.apl_Programme_Level.Find(item.Programme_Level_Id).Description;
}
else
{
obj.Levels = 0;
}
if (item.Childrens_Court_Outcome_Id > 0 || item.Childrens_Court_Outcome_Id != null)
{
obj.CourtDate = db.PCM_Childrens_Court_Outcome.Find(item.Childrens_Court_Outcome_Id).Court_Date;
}
else if (item.PCM_Preliminary_Id > 0 || item.PCM_Preliminary_Id != null)
{
obj.CourtDate = db.PCM_Preliminary_Details.Find(item.PCM_Preliminary_Id).PCM_Preliminary_Date;
}
else if (item.Formal_Courtcome_Id > 0 || item.Formal_Courtcome_Id != null)
{
if (db.PCM_FCR_Outcome.Find(item.Formal_Courtcome_Id).CourtDate != null)
{
obj.CourtDate = db.PCM_FCR_Outcome.Find(item.Formal_Courtcome_Id).CourtDate;
}
}
else
{
obj.CourtDate = null;
}
avm.Add(obj);
}
return(avm);
}
public JsonResult GetDiversionProgrameById(int Diversion_Id, int AddEditValue)
{
//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;
}
}
Session["AddEditValue"] = AddEditValue;
int assID = Convert.ToInt32(Session["IntakeassId"]);
PCMDiversionModel Model = new PCMDiversionModel();
PCMDiversionViewModel vm = new PCMDiversionViewModel();
vm.Province_List = Model.GetAllProvinces();
vm.District_List = Model.GetAllDistrict();
vm.OrganisationType_List = Model.GetAllOrganisationType();
vm.PCMOrganisation_List = Model.GetAllPCMOrganisation();
vm.LocalMunicipality_List = Model.GetAllLocalMunicipality();
vm.ProgrammeLevel_List = Model.GetAllPCMProgrammeLevels();
vm.RecomendationOrder_List = Model.GetAllPCMOrders();
vm.DiversionProgrammes_List = Model.GetAllDiversion_Programmes();
vm.SourceReferral_List = Model.GetReferralSource();
vm.Programme_List = Model.GetAllPrograms();
vm.ProgrammeLevel_List = Model.GetProgrammeLevel();
vm.ProgrammeAgeGroup_List = Model.GetProgrammeAgeGroup();
ViewBag.ProgrammeLevel_List = new SelectList(db.apl_Programme_Level.ToList(), "Programme_Level_Id", "Description");
ViewBag.ProgrammeAgeGroup_List = new SelectList(db.apl_Programme_AgeGroup.ToList(), "Programme_AgeGroup_Id", "Description");
ViewBag.Province_List = new SelectList(db.Provinces.ToList(), "Province_Id", "Description");
ViewBag.District_List = new SelectList(db.Districts.ToList(), "District_Id", "Description");
ViewBag.Local_Municipality_List = new SelectList(db.Local_Municipalities.ToList(), "Local_Municipality_Id", "Description");
ViewBag.OrganisationType_List = new SelectList(db.apl_Organisation_Type.ToList(), "IdType", "Description");
ViewBag.PCMOrganisation_List = new SelectList(db.Organizations.ToList(), "Organization_Id", "Description");
ViewBag.ProgrammeLevel_List = new SelectList(db.apl_Programme_Level.ToList(), "Programme_Level_Id", "Description");
ViewBag.RecomendationOrder_List = new SelectList(db.apl_PCM_Orders.ToList(), "Recomendation_Order_Id", "Description");
ViewBag.DiversionProgrammes_List = new SelectList(db.apl_Programmes.ToList(), "Programme_Id", "Programme_Name");
ViewBag.SourceReferral_List = new SelectList(db.apl_PCM_Referral_Source.ToList(), "Source_Referral_Id", "Description");
if (Convert.ToInt32(Model.GetDivesionFromDBDivbyId(Diversion_Id).Programme_Id) != 0)
{
vm = Model.GetDivesionFromDBDivbyId(Diversion_Id);
int Programid = Convert.ToInt32(Model.GetDivesionFromDBDivbyId(Diversion_Id).Programme_Id);
ViewBag.Programme_Name = db.apl_Programmes.Find(Programid).Programme_Name;
//Get Town using the SAPS..........................................
int organisationid = (from k in db.Organizations
join k1 in db.apl_Programmes on k.Organization_Id equals k1.Organization_Id
where k1.Programme_Id == Programid
select k.Organization_Id).FirstOrDefault();
ViewBag.organisationD = new SelectList(db.Organizations.ToList(), "Organization_Id", "Description", organisationid);
int organisationtypeid = (from k in db.apl_Organisation_Type
join k1 in db.Organizations on k.IdType equals k1.Organisation_Type_Id
where k1.Organization_Id == organisationid
select k.IdType).FirstOrDefault();
ViewBag.OrganisationType_List = new SelectList(db.apl_Organisation_Type.ToList(), "IdType", "Description", organisationtypeid);
int?LocalMuniId = (from a in db.Local_Municipalities
join b in db.Organizations on a.Local_Municipality_Id equals b.Local_Municipality_Id
where b.Organization_Id.Equals(organisationid)
select b.Local_Municipality_Id).FirstOrDefault();
ViewBag.Local_Municipality_List = new SelectList(db.Local_Municipalities.ToList(), "Local_Municipality_Id", "Description", LocalMuniId);
int DistrictIdOrg = (from k in db.Districts
join k1 in db.Local_Municipalities on k.District_Id equals k1.District_Municipality_Id
where k1.Local_Municipality_Id == LocalMuniId
select k.District_Id).FirstOrDefault();
ViewBag.District_List = new SelectList(db.Districts.ToList(), "District_Id", "Description", DistrictIdOrg);
int ProvinceIdorg = (from a in db.Districts
join b in db.Provinces on a.Province_Id equals b.Province_Id
where a.District_Id.Equals(DistrictIdOrg)
select b.Province_Id).FirstOrDefault();
ViewBag.Province_List = new SelectList(db.Provinces.ToList(), "Province_Id", "Description", ProvinceIdorg);
string value = string.Empty;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
else
{
vm = Model.GetDivesionFromDBDivbyId(Diversion_Id);
string value = string.Empty;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
}
public PCMPreliminaryViewModel Update(PCMPreliminaryViewModel pre, int userId, int PcmPreliID, int AssID)
{
PCMPreliminaryViewModel vm = new PCMPreliminaryViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Preliminary_Details fc = db.PCM_Preliminary_Details.Find(PcmPreliID);
if (fc != null)
{
fc.PCM_Recommendation_Id = pre.PCM_Recommendation_Id;
fc.PCM_Preliminary_Status_Id = pre.Preliminary_Status_Id;
fc.Placement_Pre_Recommended_Id = pre.Placement_Type_Id;
fc.PCM_Preliminary_Date = pre.PCM_Preliminary_Date;
fc.PCM_Outcome_Reason = pre.PCM_Outcome_Reason;
fc.Date_Modified = pre.Date_Modified;
fc.Modified_By = pre.Modified_By;
fc.Date_Created = pre.Date_Created;
db.SaveChanges();
PCM_HB_Supervision exist1 = db.PCM_HB_Supervision.OrderByDescending(x => x.HomeBasedSupervision_Id).FirstOrDefault(x => x.PCM_Preliminary_Id == PcmPreliID);
//PCM_HB_Supervision exist1 = db.PCM_HB_Supervision.Where(x => x.PCM_Preliminary_Id == PcmPreliID).SingleOrDefault();
if (fc.Placement_Pre_Recommended_Id == 187 && exist1 == null)
{
PCM_HB_Supervision add = new PCM_HB_Supervision();
PCMHBSViewModel vmhb = new PCMHBSViewModel();
add.HomeBasedSupervision_Id = vmhb.HomeBasedSupervision_Id;
add.PCM_Preliminary_Id = PcmPreliID;
add.Intake_Assessment_Id = AssID;
add.Court_Type_Id = 1;
db.PCM_HB_Supervision.Add(add);
db.SaveChanges();
}
PCM_Diversion exist12 = db.PCM_Diversion.OrderByDescending(x => x.Diversion_Id).FirstOrDefault(x => x.PCM_Preliminary_Id == PcmPreliID);
if (fc.PCM_Recommendation_Id == 1 && exist12 == null)
{
PCM_Diversion newhomebase = new PCM_Diversion();
PCMDiversionViewModel mdiv = new PCMDiversionViewModel();
newhomebase.Diversion_Id = mdiv.Diversion_Id;
newhomebase.PCM_Preliminary_Id = fc.PCM_Preliminary_Id;
newhomebase.Intake_Assessment_Id = AssID;
newhomebase.Court_Type_Id = 1;
db.PCM_Diversion.Add(newhomebase);
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;
}
return(vm);
}
}
