public ActionResult AcceptPCMEndPointCase(PCMSocialWorkerEndpointCasesVM update, string 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;
}
}
// Accetp Case Allocated
int End_Point_POD_Id = Convert.ToInt32(id);
var _db = new SDIIS_DatabaseEntities();
var list = new PCMSocialWorkerEndpointCasesVM();
PCMWorkListModel model = new PCMWorkListModel();
//Call update function..................................................................................................................
model.UpdatePCMEndpointWorkListCase(update, End_Point_POD_Id, userId);
return(RedirectToAction("Index", "Home", new { End_Point_POD_Id = End_Point_POD_Id }));
}
public List <PCMSocialWorkerEndpointCasesVM> GetNewEndpointAlloctedCasesList(int useridlogged)
{
// initialising view model
List <PCMSocialWorkerEndpointCasesVM> avm = new List <PCMSocialWorkerEndpointCasesVM>();
// initialise connection
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
// get problem category for adoption
// get work list for user logged in
var newworkList =
(from list in db.PCM_EndPoint_PO_Inbox
join status in db.apl_PCM_Endpoint_Record_Status on list.Endpoint_Record_Status_Id equals
status.Endpoint_Record_Status_Id
join person in db.Persons on list.Person_Id equals person.Person_Id
where (list.Case_Allocated_To == useridlogged && status.Endpoint_Record_Status_Id == 1)
select new
{
list.End_Point_POD_Id,
list.Case_Allocated_To,
list.Date_Recieved,
list.Endpoint_Record_Status_Id,
list.Allocated_ByS,
person.First_Name,
person.Last_Name,
person.Identification_Number
}).ToList();
;
foreach (var item in newworkList)
{
// initialising view model
PCMSocialWorkerEndpointCasesVM obj = new PCMSocialWorkerEndpointCasesVM();
obj.End_Point_POD_Id = item.End_Point_POD_Id;
obj.Allocated_By = item.Allocated_ByS;
obj.POAllocate_To = item.Case_Allocated_To;
obj.Date_Recieved = item.Date_Recieved;
obj.EndpointRecordStatusDescription = db.apl_PCM_Endpoint_Record_Status.Find(item.Endpoint_Record_Status_Id).Description;
obj.FirstNameE = item.First_Name;
obj.LastNameE = item.Last_Name;
obj.IDNumberE = item.Identification_Number;
obj.PONmae_To = db.Users.Find(item.Case_Allocated_To).Last_Name;
obj.Allocated_ByName = db.Users.Find(item.Allocated_ByS).Last_Name;
avm.Add(obj);
}
return(avm);
}
public void UpdatePCMEndpointWorkListCase(PCMSocialWorkerEndpointCasesVM list, int End_Point_POD_Id, int userId)
{
// initialise connection
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
// Accept New case on work list
var editlist = (from i in db.PCM_EndPoint_PO_Inbox
where i.End_Point_POD_Id == (End_Point_POD_Id)
select i.End_Point_POD_Id).FirstOrDefault();
PCM_EndPoint_PO_Inbox edit = db.PCM_EndPoint_PO_Inbox.Find(editlist);
edit.End_Point_POD_Id = End_Point_POD_Id;
edit.Endpoint_Record_Status_Id = 4;
edit.Modified_By = userId;
edit.Date_Modified = DateTime.Now;
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 = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
