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