//Get Child Transferred to logged in User
public List <CYCAChildAllocationViewModel> GetTransferredPersonByTransferredTo(int userId)
{
List <CYCAChildAllocationViewModel> cvm = new List <CYCAChildAllocationViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var ListP =
(from p in db.Persons
join t in db.CYCA_Child_Transfer on p.Person_Id equals t.Person_Id
join u in db.Users on t.Transferred_By equals u.User_Id
join ts in db.apl_Cyca_Transfer_Status on t.Tansfer_Status_Id equals ts.Tansfer_Status_Id
where t.Tranferred_To == userId && t.Tansfer_Status_Id == 1
select new
{
p.Person_Id,
t.Transfer_Id,
ts.Tansfer_Status_Id,
u.User_Id
}).ToList();
foreach (var item in ListP)
{
CYCAChildAllocationViewModel obj = new CYCAChildAllocationViewModel();
obj.Transfer_Id = item.Transfer_Id;
obj.Child_First_Name = db.Persons.Find(item.Person_Id).First_Name + " " + db.Persons.Find(item.Person_Id).Last_Name;
obj.selectedTransferStatus = db.apl_Cyca_Transfer_Status.Find(item.Tansfer_Status_Id).Description;
cvm.Add(obj);
}
return(cvm);
}
//Get Child Transferred by logged in User
public JsonResult ChildTransferredToUser()
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
List <CYCAChildAllocationViewModel> lis = new List <CYCAChildAllocationViewModel>();
lis.AddRange(model.GetTransferredPersonByTransferredTo(userId).Select(x => new CYCAChildAllocationViewModel
{
Transfer_Id = x.Transfer_Id,
Child_First_Name = x.Child_First_Name,
Transferred_By = x.Transferred_By,
selectedTransferStatus = x.selectedTransferStatus,
Person_Id = x.Person_Id
}).ToList());
return(Json(lis, JsonRequestBehavior.AllowGet));
}
//List of Children Assigend to User
public List <CYCAChildAllocationViewModel> GetChildByUserId(int User_Id)
{
List <CYCAChildAllocationViewModel> cvm = new List <CYCAChildAllocationViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var ListP =
(from t in db.CYCA_Child_Transfer
join u in db.Users on t.Tranferred_To equals u.User_Id
join p in db.Persons on t.Person_Id equals p.Person_Id
where u.User_Id == User_Id
select new
{
t.Transfer_Id,
u.User_Id,
p.Person_Id
}).ToList();
foreach (var item in ListP)
{
CYCAChildAllocationViewModel obj = new CYCAChildAllocationViewModel();
obj.Transfer_Id = item.Transfer_Id;
obj.Child_Name = db.Persons.Find(item.Person_Id).First_Name + " " + db.Persons.Find(item.Person_Id).Last_Name;
obj.Date_Transferred = db.CYCA_Child_Transfer.Find(item.Transfer_Id).Date_Transferred;
cvm.Add(obj);
}
return(cvm);
}
//Get Care Worker in the Venue
public JsonResult GetChildByUserId(int User_Id)
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
//int Facility = model.employee.GetFacilityIdByUserID(userId);
//int venueId = model.GetVenueIdByFacilityId(Facility);
List <CYCAChildAllocationViewModel> lis = new List <CYCAChildAllocationViewModel>();
lis.AddRange(model.GetPersonListByUserId(User_Id).Select(x => new CYCAChildAllocationViewModel
{
Transfer_Id = x.Transfer_Id,
Child_Name = x.Child_Name,
Date_Transferred = x.Date_Transferred,
GangMembership = x.GangMembership
}).ToList());
return(Json(lis, JsonRequestBehavior.AllowGet));
}
public ActionResult CareWorker()
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
var venue_list = venues.GetAplCycaVenues();
ViewBag.VenueList = new SelectList(venue_list, "Venue_Id", "VenueName");
var userList = userModel.getUserCYCAList();
ViewBag.UsersList = new SelectList(userList, "User_Id", "fullname");
var status_list = children.GetTransferStatusList();
ViewBag.StatusList = new SelectList(status_list, "Tansfer_Status_Id", "Description");
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
return(View(vm));
}
public List <CYCAChildAllocationViewModel> GetUserByVenueId(int venueId)
{
List <CYCAChildAllocationViewModel> cvm = new List <CYCAChildAllocationViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var ListP =
(from t in db.CYCA_Child_Movement
join u in db.Users on t.Moved_By equals u.User_Id
//Active Admissions for Facility
join a in db.CYCA_Admissions_AdmissionDetails on new { admission = t.Admission_Id ?? 0, active = true } equals new { admission = a.Admission_Id, active = a.Is_Active }
join c in db.CYCA_Child_Allocation on new { careworker = t.Moved_By, child = t.Person_Id, admission = t.Admission_Id } equals new { careworker = c.User_Id, child = c.Person_Id, admission = c.Admission_Id }
join v in db.apl_Cyca_Venue on t.Venue_Id equals v.Venue_Id
join p in db.Persons on t.Person_Id equals p.Person_Id
where v.Venue_Id == venueId && t.Check_Out_Date == null
select new
{
t.Movement_Id,
t.Moved_By,
u.User_Id,
u.First_Name,
u.Last_Name,
t.Date_Moved,
v.Venue_Id,
p.Person_Id,
ChildName = p.First_Name + " " + p.Last_Name
}).OrderBy(c => c.User_Id).ToList();
int count = 0;
int lastUser = 0;
foreach (var item in ListP)
{
if (lastUser != item.User_Id)
{
count = 1;
CYCAChildAllocationViewModel obj = new CYCAChildAllocationViewModel();
obj.Movement_Id = item.Movement_Id;
obj.CareWorker_Name = item.First_Name + " " + item.Last_Name;
obj.Checked_In_Date = item.Date_Moved;
obj.Person_Id = count;;
obj.Child_Name = item.ChildName;
cvm.Add(obj);
}
else
{
count++;
cvm[cvm.Count - 1].Person_Id = count;
cvm[cvm.Count - 1].Child_Name = cvm[cvm.Count - 1].Child_Name + " " + item.ChildName;
}
lastUser = item.User_Id;
}
return(cvm);
}
//Populate Transfer Modal
public JsonResult GetTransferById(int TransferId)
{
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
vm = model.GetTransferById(TransferId);
string value = string.Empty;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
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);
}
public JsonResult UpdateTransferandAllocationInDatabase(CYCAChildAllocationViewModel vm)
{
int TransferId = Convert.ToInt32(vm.Transfer_Id);
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
}
var result = false;
try
{
var ca = children.getChildAllocation(TransferId);
var t = children.GetChildTranfer(TransferId);
switch (vm.selectedTransferStatus)
{
case "Accept":
t.Tansfer_Status_Id = 2;
ca.User_Id = userId;
ca.Date_Transferred = DateTime.Now;
ca.Sent_By = t.Transferred_By;
break;
case "Reject":
t.Tansfer_Status_Id = 3;
t.Decline_Reason = vm.Decline_Reason;
break;
}
children.SaveChildrenChanges();
result = true;
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//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;
}
}
}
//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);
}
}
//Get Care Worker in the Venue
public JsonResult GetUserVenueId(int venueId)
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
// get client list
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
//int Facility = model.employee.GetFacilityIdByUserID(userId);
//int venueId = model.GetVenueIdByFacilityId(Facility);
List <CYCAChildAllocationViewModel> lis = new List <CYCAChildAllocationViewModel>();
lis.AddRange(model.GetUserByVenueId(venueId).Select(x => new CYCAChildAllocationViewModel
{
Movement_Id = x.Movement_Id,
CareWorker_Name = x.CareWorker_Name,
Checked_In_Date = x.Checked_In_Date,
Person_Id = x.Person_Id,
Child_Name = x.Child_Name
}).ToList());
return(Json(lis, JsonRequestBehavior.AllowGet));
}
public JsonResult SearchChild()
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
// get client list
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
List <CYCAChildAllocationViewModel> lis = new List <CYCAChildAllocationViewModel>();
lis.AddRange(model.GetPersonListByUserId(userId).Select(x =>
new CYCAChildAllocationViewModel
{
Child_Allocation_Id = x.Child_Allocation_Id,
Child_First_Name = x.Child_First_Name,
Child_Last_First_Name = x.Child_Last_First_Name,
Child_ID_No = x.Child_ID_No,
LoggedInUserName = x.LoggedInUserName,
Person_Id = x.Person_Id
}).ToList());
return(Json(lis, JsonRequestBehavior.AllowGet));
}
//Populate Child Details Modal
public JsonResult GetChildByAllocationId(int AllocationId)
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
//int empid = model.GetBedSpaceRequestById(RequestId);
vm = model.GetChildByAllocationId(AllocationId);
string value = string.Empty;
ViewBag.ChildAllocationId = AllocationId;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
public CYCAChildAllocationViewModel GetCareWorkerByVenueId(int venueId)
{
CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
CYCA_Team_Allocation act = db.CYCA_Team_Allocation.Find(venueId);
if (act != null)
{
vm.Team_Allocation_Id = act.Team_Allocation_Id;
vm.Venue_Id = act.Venue_Id;
vm.CareWorker_Name = db.Users.Find(act.Reporting_User).First_Name + " " + db.Users.Find(act.Reporting_User).Last_Name;
vm.Start_Date = act.Start_Date.ToString("dd/MM/yyyy");
}
}
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);
}
