//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; } } }
//Add Child on transfer table public void AddChildTransferToDatabase(CYCAChildMovementTransfer vm, int userId) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { CYCA_Child_Transfer add = new CYCA_Child_Transfer(); add.Person_Id = vm.Person_Id; add.Tansfer_Status_Id = 1; add.Date_Transferred = DateTime.Now; add.Time_Transferred = DateTime.Now; add.Transferred_By = userId; add.Tranferred_To = vm.TransferredTo_Id; add.Created_By = userId.ToString(); add.Date_Created = DateTime.Now; add.Is_Active = true; add.Is_Deleted = false; add.Admission_Id = vm.Admission_Id; db.CYCA_Child_Transfer.Add(add); 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; } } }
//Populate Transfer modal public CYCAChildAllocationViewModel GetTransferById(int TransferId) { CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { CYCA_Child_Transfer act = db.CYCA_Child_Transfer.Find(TransferId); if (act != null) { //Get Request Details vm.Transfer_Id = TransferId; vm.Transfer_Status_Id = act.Tansfer_Status_Id; vm.Child_First_Name = db.Persons.Find(act.Person_Id).First_Name + " " + db.Persons.Find(act.Person_Id).Last_Name; vm.transferredbyName = db.Users.Find(act.Transferred_By).First_Name + " " + db.Users.Find(act.Transferred_By).Last_Name; vm.Person_Id = db.Persons.Find(act.Person_Id).Person_Id; } } 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); } }