public CYCAChildAllocationViewModel GetChildByAllocationId(int AllocationId) { CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { CYCAChildAllocationModel model = new CYCAChildAllocationModel(); var person = model.GetAlloIdByPersId(AllocationId); CYCA_Child_Allocation act = db.CYCA_Child_Allocation.Find(person); if (act != null) { vm.Child_Allocation_Id = person; vm.Person_Id = act.Person_Id; vm.Moved_By = act.User_Id; vm.Date_Moved = DateTime.Now.ToString("yyy/MM/dd"); vm.Time_Moved = DateTime.Now.ToString("HH:mm"); vm.Transferred_By = act.User_Id ?? 0; vm.Date_Transferred = DateTime.Now; vm.Time_Transferred = DateTime.Now; } } 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); }
//Update Transfer and Child Allocation public void UpdateTransferAndAllocation(CYCAChildAllocationViewModel vm, int Transfer_Id, int userId, int reid, int Allocation_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { CYCA_Child_Transfer edit = db.CYCA_Child_Transfer.Find(Transfer_Id); edit.Tansfer_Status_Id = Convert.ToInt32(reid); edit.Date_Last_Modified = DateTime.Today; CYCA_Child_Allocation assign = db.CYCA_Child_Allocation.Find(Allocation_Id); if (reid == 2) { assign.User_Id = userId; } 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 removeChild(CYCA_Child_Allocation child) { db.CYCA_Child_Allocation.Remove(child); }
public void saveChldToAllocation(CYCA_Child_Allocation child) { db.CYCA_Child_Allocation.Add(child); db.SaveChanges(); }