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