public AdoptionWorkListVM CheckAssementExistance()
{
// initializing view model
AdoptionWorkListVM newCase = new AdoptionWorkListVM();
// initialise connection
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
//Check assessment from intake assessment not in Adoption work list
var List = (from List1 in db.Intake_Assessments
where !(from List2 in db.ADOPT_Case_WorkList
select List2.Intake_Assessment_Id).Contains(List1.Intake_Assessment_Id)
where List1.Problem_Sub_Category_Id == 18 && (List1.Case_Manager_Id >= 1)
select List1).ToList();
//ADOPT_Case_WorkList act = db.ADOPT_Case_WorkList.Find(worlistid);
foreach (var item in List)
{
if (List != null)
{
//insert values not in Work list for List
ADOPT_Case_WorkList act = new ADOPT_Case_WorkList();
act.Intake_Assessment_Id = item.Intake_Assessment_Id;
act.Allocated_By = item.Assessed_By_Id;
act.Adopt_Record_Status_Id = 1;
act.Manager = item.Case_Manager_Supervisor_Id;
act.Allocate_To = item.Case_Manager_Id;
act.Date_Allocated = item.Date_Allocated;
db.ADOPT_Case_WorkList.Add(act);
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(newCase);
}
}
public void UpdateWorkListCase(AdoptionWorkListVM list, int AssId)
{
// initialise connection
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
// Accept New case on work list
var editlist = (from i in db.ADOPT_Case_WorkList
where i.Intake_Assessment_Id == (AssId)
select i.Adopt_CaseWoklist_Id).FirstOrDefault();
ADOPT_Case_WorkList edit = db.ADOPT_Case_WorkList.Find(editlist);
edit.Intake_Assessment_Id = AssId;
edit.Adopt_Record_Status_Id = 2;
edit.Accepted_By = list.Case_Manager_Id;
edit.Date_Accepted = 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 = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
