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