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