//string cs = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; #region PCM_Referrals public List <PCMReferralsViewModel> GetPCMReferralsList(int Intake_Assessment_Id) { List <PCMReferralsViewModel> rVM = new List <PCMReferralsViewModel>(); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var rList = (from pf in db.PCM_Referrals join rt in db.apl_Referral_Type on pf.Type_Referral_Id equals rt.Type_Referral_Id where pf.Intake_Assessment_Id == Intake_Assessment_Id select new { pf.Referrals_Id, pf.Intake_Assessment_Id, pf.theClerk, pf.theParticular, pf.Type_Referral_Id, rt.Type_Referral }).ToList(); foreach (var item in rList) { PCMReferralsViewModel objR = new PCMReferralsViewModel(); objR.Referrals_Id = item.Referrals_Id; objR.Intake_Assessment_Id = item.Intake_Assessment_Id; objR.theClerk = item.theClerk; objR.theParticular = item.theParticular; objR.Type_Referral_Id = item.Type_Referral_Id; objR.Type_Referral = item.Type_Referral; rVM.Add(objR); } return(rVM); }
public void UpdateReferalToCouncelling(PCMReferralsViewModel vm, int userId, int Referrals_Councelling_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Referral_Counselling ass = db.PCM_Referral_Counselling.Find(Referrals_Councelling_Id); //cases.PCM_Case_Id = cas ass.Referrals_Id = vm.Referrals_Id; ass.Type_Referral_Id = vm.Type_Referral_Id; ass.Referral_of_Child_To_Counselling = vm.Referral_of_Child_To_Counselling; ass.Period_From = vm.Period_From; ass.Period = vm.Period_To; ass.Child_Progress = vm.Progress_Report; ass.Modified_By = userId; ass.Date_Modified = DateTime.Now; db.SaveChanges(); } catch { } } }
public void UpdateReferalToSocialWorker(PCMReferralsViewModel vm, int userId, int Referrals_SocilaWorker_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Referral_SocilaWorker ass = db.PCM_Referral_SocilaWorker.Find(Referrals_SocilaWorker_Id); //cases.PCM_Case_Id = cas ass.Referrals_Id = vm.Referrals_Id; ass.Type_Referral_Id = vm.Type_Referral_Id; ass.Programme_Period_From = vm.Period_From; ass.Programme_Period = vm.Period_To; ass.Child_Progress = vm.Progress_Report; ass.Modified_By = userId; ass.Date_Modified = DateTime.Now; db.SaveChanges(); } catch { } } }
public List <PCMReferralsViewModel> GetPCMReferralsList() { List <PCMReferralsViewModel> rVM = new List <PCMReferralsViewModel>(); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var rList = (from pf in db.PCM_Referrals join pcd in db.PCM_Case_Details on pf.PCM_Case_Id equals pcd.PCM_Case_Id select new { pf.Referrals_Id, pf.PCM_Case_Id, pf.Client_Employee_Details_ID, pf.theClerk, pf.theParticular, pf.Type_Referral_Id }).ToList(); foreach (var item in rList) { PCMReferralsViewModel objR = new PCMReferralsViewModel(); objR.Referrals_Id = item.Referrals_Id; objR.PCM_Case_Id = item.PCM_Case_Id; objR.Client_Employee_Details_ID = item.Client_Employee_Details_ID; objR.theClerk = item.theClerk; objR.theParticular = item.theParticular; //objR.Type_Referral_Id = item.Type_Referral_Id; rVM.Add(objR); } return(rVM); }
public int?GetTypeReferralId(int IntakeAssessmentId) { PCMReferralsViewModel vm = new PCMReferralsViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { return((from p in db.PCM_Referrals where p.Intake_Assessment_Id.Equals(IntakeAssessmentId) select p.Type_Referral_Id).FirstOrDefault()); } }
public PCMReferralsViewModel GetCAPSW(int Category_Referrals_Id) { PCMReferralsViewModel vm = new PCMReferralsViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { int?id = (from c in db.PCM_Referral_Types where (c.Referrals_Id != null && c.Category_Referrals_Id == Category_Referrals_Id) select c.Category_Referrals_Id).FirstOrDefault(); PCM_Referral_Types ass = db.PCM_Referral_Types.Find(id); if (ass != null) { vm.Category_Referrals_Id = db.PCM_Referral_Types.Find(ass.Category_Referrals_Id).Category_Referrals_Id; //vm.Referrals_Id = ass.Referrals_Id; //vm.Type_Referral_Id = ass.Type_Referral_Id; vm.Client_Employee_Details_ID = ass.Client_Employee_Details_ID; vm.Refferal_Date = ass.Refferal_Date; vm.Period_From = ass.Period_From; vm.Period_To = ass.Period_To; vm.Progress_Report = ass.Progress_Report; vm.Employee_Id_Copy_To = ass.Employee_Id_Copy_To; 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 SaveReferralsData(PCMReferralsViewModel prVM) { var result = false; //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 Intake_Assessment_Id = Convert.ToInt32(Session["IntakeassId"]); try { if (prVM.Referrals_Id > 0) { rm.UpdateReferralsData(prVM, prVM.Referrals_Id, userId, Intake_Assessment_Id); rm.ViewReferralData(prVM.Referrals_Id); result = true; } else { rm.SaveReferralsData(prVM, userId, Intake_Assessment_Id); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public List <PCMReferralsViewModel> GetPCMReferralCAPSW() { List <PCMReferralsViewModel> rVM = new List <PCMReferralsViewModel>(); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var rList = (from pf in db.PCM_Referrals join prt in db.PCM_Referral_Types on pf.Referrals_Id equals prt.Referrals_Id join rt in db.apl_Referral_Type on pf.Type_Referral_Id equals rt.Type_Referral_Id //where pf.Referrals_Id == Referrals_Id select new { prt.Category_Referrals_Id, pf.Referrals_Id, pf.PCM_Case_Id, pf.Client_Employee_Details_ID, pf.theClerk, pf.theParticular, pf.Type_Referral_Id, rt.Type_Referral, prt.Refferal_Date, prt.Period_From, prt.Period_To }).ToList(); foreach (var item in rList) { PCMReferralsViewModel objR = new PCMReferralsViewModel(); objR.Category_Referrals_Id = item.Category_Referrals_Id; objR.Referrals_Id = item.Referrals_Id; objR.PCM_Case_Id = item.PCM_Case_Id; objR.Client_Employee_Details_ID = item.Client_Employee_Details_ID; objR.theClerk = item.theClerk; objR.theParticular = item.theParticular; //objR.Type_Referral_Id = item.Type_Referral_Id; objR.Type_Referral = item.Type_Referral; objR.Refferal_Date = item.Refferal_Date; objR.Period_From = item.Period_From; objR.Period_To = item.Period_To; rVM.Add(objR); } return(rVM); }
public JsonResult SaveReferalToProgramme(PCMReferralsViewModel vm) { //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 Referrals_Id = Convert.ToInt32(Session["Referrals_Id"]); try { if (Referrals_Id > 0) { int Referrals_Programme_Id = rm.GetProgrammeIdByReferalId(Referrals_Id); rm.UpdateReferalToProgramme(vm, userId, Referrals_Programme_Id); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public void SaveReferalToCouncelling(PCMReferralsViewModel vm, int Referrals_Id, int Type_Referral_Id, int userId) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Referral_Types newRefType = new PCM_Referral_Types(); newRefType.Referrals_Id = Referrals_Id; newRefType.Type_Referral_Id = Type_Referral_Id; //newRefType.Client_Employee_Details_ID = Type_Referral_Id; newRefType.Refferal_Date = vm.Refferal_Date; newRefType.Period_From = vm.Period_From; newRefType.Period_To = vm.Period_To; newRefType.Progress_Report = vm.Progress_Report; newRefType.Employee_Id_Copy_To = vm.Employee_Id_Copy_To; newRefType.Modified_By = userId; newRefType.Date_Modified = DateTime.Now; newRefType.Modified_By = userId; newRefType.Date_Created = DateTime.Now; db.PCM_Referral_Types.Add(newRefType); 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 PCMReferralsViewModel ViewReferralData(int Referrals_Id = 1011) { PCMReferralsViewModel vm = new PCMReferralsViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { var gd = db.PCM_Referrals.Find(Referrals_Id); vm.theClerk = gd.theClerk; vm.theParticular = gd.theParticular; //if (r != null) //{ //vm.Referrals_Id = db.PCM_Referrals.Find(r.Referrals_Id).Referrals_Id; //vm.theClerk = vm.theClerk; // //vm.Prelim_Enquiry_Date = cc.Prelim_Enquiry_Date; //vm.Child_Need_Care = cc.Child_Need_Care; //vm.Substance_Abuse_Treat = cc.Substance_Abuse_Treat; //vm.Referral_Date = cc.Referral_Date; return(vm); //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 <PCMReferralsViewModel> GetPCMCourtReferralsList() { List <PCMReferralsViewModel> rVM = new List <PCMReferralsViewModel>(); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var cList = (from cf in db.PCM_Referral_To_Court select new { cf.Court_Referrals_Id, cf.Referrals_Id, cf.Child_Need_Care_Protection, cf.Stay_At_Parents_Home, cf.Comitted_Minor_Offence }).ToList(); foreach (var item in cList) { PCMReferralsViewModel objC = new PCMReferralsViewModel(); objC.Court_Referrals_Id = item.Court_Referrals_Id; //objC.Referrals_Id = item.Referrals_Id; //objC.Child_Need_Care_Protection = item.Child_Need_Care_Protection; //objC.Stay_At_Parents_Home = item.Stay_At_Parents_Home; rVM.Add(objC); } return(rVM); }
public void SaveCourtData(PCMReferralsViewModel prVM, int Court_Referrals_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Referral_To_Court nu = db.PCM_Referral_To_Court.Find(Court_Referrals_Id); nu.Child_Need_Care_Protection = prVM.Child_Need_Care_Protection; nu.Stay_At_Parents_Home = prVM.Stay_At_Parents_Home; nu.Comitted_Minor_Offence = prVM.Comitted_Minor_Offence; nu.Referrals_Id = prVM.Referrals_Id; nu.Refferal_Date = prVM.Refferal_Date; nu.Created_By = prVM.Created_By; nu.Date_Created = DateTime.Now; nu.Modified_By = prVM.Modified_By; nu.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 ActionResult PCM_Referrals(int id) { if (id > 0) { vm = rm.ViewReferralData(id); //pVM.Recommendation_Type = preModel.GetRecommendationType(); } else { //clear all the fields } var typerefferal = (from c in db.PCM_Referrals where c.Referrals_Id == 1011 select c.Type_Referral_Id).FirstOrDefault(); ViewBag.typerefferal = typerefferal; List <apl_Referral_Type> RefList = db.apl_Referral_Type.ToList(); ViewBag.ListofReferrals = new SelectList(RefList, "Type_Referral_Id", "Type_Referral"); return(View()); }
public void UpdateReferralsData(PCMReferralsViewModel prVM, int id, int userid) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Referrals rr = db.PCM_Referrals.Find(id); rr.PCM_Case_Id = prVM.PCM_Case_Id; rr.Client_Employee_Details_ID = prVM.Client_Employee_Details_ID; rr.theClerk = prVM.theClerk; rr.theParticular = prVM.theParticular; rr.Type_Referral_Id = prVM.Type_Referral_Id; rr.Modified_By = userid; rr.Date_Modified = DateTime.Now; db.SaveChanges(); } catch (Exception ex) { throw ex; } } }
public void SaveReferralsData(PCMReferralsViewModel vM, int userid, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Referrals ReferralNew = new PCM_Referrals(); ReferralNew.Client_Employee_Details_ID = vM.Client_Employee_Details_ID; ReferralNew.Intake_Assessment_Id = Intake_Assessment_Id; ReferralNew.Type_Referral_Id = vM.Type_Referral_Id; ReferralNew.theClerk = vM.theClerk; ReferralNew.theParticular = vM.theParticular; ReferralNew.Created_By = userid; ReferralNew.Date_Created = DateTime.Now; db.PCM_Referrals.Add(ReferralNew); db.SaveChanges(); if (ReferralNew.Type_Referral_Id == 1) { PCM_Referral_To_Court nu = new PCM_Referral_To_Court(); nu.Referrals_Id = ReferralNew.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = vM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_To_Court.Add(nu); db.SaveChanges(); } else if (ReferralNew.Type_Referral_Id == 2) { PCM_Referral_To_Programme nu = new PCM_Referral_To_Programme(); nu.Referrals_Id = ReferralNew.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = vM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_To_Programme.Add(nu); db.SaveChanges(); } else if (ReferralNew.Type_Referral_Id == 3) { PCM_Referral_Counselling nu = new PCM_Referral_Counselling(); nu.Referrals_Id = ReferralNew.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = vM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_Counselling.Add(nu); db.SaveChanges(); } else if (ReferralNew.Type_Referral_Id == 4) { PCM_Referral_SocilaWorker nu = new PCM_Referral_SocilaWorker(); nu.Referrals_Id = ReferralNew.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = vM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_SocilaWorker.Add(nu); 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 UpdateReferralsData(PCMReferralsViewModel prVM, int id, int userid, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Referrals rr = db.PCM_Referrals.Find(id); rr.PCM_Case_Id = prVM.PCM_Case_Id; rr.Client_Employee_Details_ID = prVM.Client_Employee_Details_ID; rr.theClerk = prVM.theClerk; rr.theParticular = prVM.theParticular; rr.Type_Referral_Id = prVM.Type_Referral_Id; rr.Modified_By = userid; rr.Date_Modified = DateTime.Now; db.SaveChanges(); if (rr.Type_Referral_Id == 1) { PCM_Referral_To_Court c = db.PCM_Referral_To_Court.Where(x => x.Referrals_Id == id && x.Type_Referral_Id == rr.Type_Referral_Id).SingleOrDefault(); if (c == null) { PCM_Referral_To_Court nu = new PCM_Referral_To_Court(); nu.Referrals_Id = rr.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = prVM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_To_Court.Add(nu); db.SaveChanges(); } } else if (rr.Type_Referral_Id == 2) { PCM_Referral_To_Programme c = db.PCM_Referral_To_Programme.Where(x => x.Referrals_Id == id && x.Type_Referral_Id == rr.Type_Referral_Id).SingleOrDefault(); if (c == null) { PCM_Referral_To_Programme nu = new PCM_Referral_To_Programme(); nu.Referrals_Id = rr.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = prVM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_To_Programme.Add(nu); db.SaveChanges(); } } else if (rr.Type_Referral_Id == 3) { PCM_Referral_Counselling c = db.PCM_Referral_Counselling.Where(x => x.Referrals_Id == id && x.Type_Referral_Id == rr.Type_Referral_Id).SingleOrDefault(); if (c == null) { PCM_Referral_Counselling nu = new PCM_Referral_Counselling(); nu.Referrals_Id = rr.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = prVM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_Counselling.Add(nu); db.SaveChanges(); } } else if (rr.Type_Referral_Id == 4) { PCM_Referral_SocilaWorker c = db.PCM_Referral_SocilaWorker.Where(x => x.Referrals_Id == id && x.Type_Referral_Id == rr.Type_Referral_Id).SingleOrDefault(); if (c == null) { PCM_Referral_SocilaWorker nu = new PCM_Referral_SocilaWorker(); nu.Referrals_Id = rr.Referrals_Id; nu.Intake_Assessment_Id = Intake_Assessment_Id; nu.Type_Referral_Id = prVM.Type_Referral_Id; nu.Created_By = userid; nu.Date_Created = DateTime.Now; db.PCM_Referral_SocilaWorker.Add(nu); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } } }