public List <ProjectMasterViewModel> GetAssignedProjects(int userId)
{
var _context = new DatabaseContext();
var queryResult = (from registration in _context.Registration
join A in _context.AssignedRoles on registration.RegistrationID equals A.RegistrationID into A_join
from A in A_join.DefaultIfEmpty()
join AA in _context.Registration on A.AssignToAdmin equals AA.RegistrationID into AA_join
from AA in AA_join.DefaultIfEmpty()
join _assignedProjects in _context.AssignedProjects on registration.RegistrationID equals _assignedProjects.ManagerId into RL_join
from _assignedProjects in RL_join.DefaultIfEmpty()
join projectmaster in _context.ProjectMaster on _assignedProjects.ProjectId equals projectmaster.ProjectID into D_join
from Proj in D_join.DefaultIfEmpty()
where registration.RegistrationID == userId
select new ProjectMasterViewModel()
{
ProjectID = Proj.ProjectID,
ProjectCode = Proj.ProjectCode,
ProjectName = Proj.ProjectName,
FirstName = AA.FirstName,
LastName = AA.LastName,
MiddleName = AA.MiddleName,
IsActive = Proj.IsActive
}).ToList();
return(queryResult);
}
public ActionResult PopulateAccessRight(string userID)
{
var model = (from b in (from AD_Menu in db.AD_Menu
where
AD_Menu.URLAction != null &&
AD_Menu.URLAction != "" &&
AD_Menu.URLAction != "#"
select new
{
AD_Menu
})
join a in (from AD_User_Menu in db.AD_User_Menu
where
AD_User_Menu.UserID == userID
select new
{
AD_User_Menu
}) on b.AD_Menu.MenuID equals a.AD_User_Menu.MenuID into A_join
from a in A_join.DefaultIfEmpty()
select new AccessMatrixViewModel
{
MenuID = b.AD_Menu.MenuID,
UserID = userID,
View = a.AD_User_Menu.Read ?? false,
Edit = a.AD_User_Menu.Edit ?? false,
Add = a.AD_User_Menu.Add ?? false,
Delete = a.AD_User_Menu.Delete ?? false,
Excel = a.AD_User_Menu.Excel_CSV ?? false,
PDF = a.AD_User_Menu.PDF ?? false,
Print = a.AD_User_Menu.Print ?? false,
MenuText = b.AD_Menu.MenuText
}).ToList();
return(PartialView("_Matrix", model));
}
public Indicators IndicatorByPacient(string patientId)
{
try
{
var serviceData = (from E in ctx.Person
join A in ctx.Service on E.v_PersonId equals A.v_PersonId into A_join
from A in A_join.DefaultIfEmpty()
//join F in ctx.OrganizationPerson on E.v_PersonId equals F.v_PersonId
//join G in ctx.Organization on F.v_OrganizationId equals G.v_OrganizationId
where E.v_PersonId == patientId && A.i_IsDeleted == 0
select new
{
FullName = E.v_FirstName + " " + E.v_FirstLastName + " " + E.v_SecondLastName,
Puesto = E.v_CurrentOccupation,
Empresa = "",
FechaServicio = A.d_ServiceDate
}).ToList();
if (serviceData.Count == 0)
{
return(null);
}
var serviceDataTemp = (from a in serviceData
select new
{
FullName = a.FullName,
Puesto = a.Puesto,
Empresa = a.Empresa,
FechaServicio = a.FechaServicio.Value.Date
}).ToList();
serviceDataTemp = serviceDataTemp.GroupBy(g => g.FechaServicio).Select(s => s.First()).ToList();
var serviceComponentFieldValues = (from A in ctx.Service
join B in ctx.ServiceComponent on A.v_ServiceId equals B.v_ServiceId
join C in ctx.ServiceComponentFields on B.v_ServiceComponentId equals C.v_ServiceComponentId
join D in ctx.ServiceComponentFieldValues on C.v_ServiceComponentFieldsId equals D.v_ServiceComponentFieldsId
where A.v_PersonId == patientId &&
(C.v_ComponentFieldId == Constants.COLESTEROL_TOTAL_Colesterol_Total_Id || C.v_ComponentFieldId == Constants.PERFIL_LIPIDICO_Colesterol_Total_Id || C.v_ComponentFieldId == Constants.GLUCOSA_Glucosa_Id || C.v_ComponentFieldId == Constants.HEMOGLOBINA_Hemoglobina_Id || C.v_ComponentFieldId == Constants.HEMOGRAMA_Hemoglobina_Id || C.v_ComponentFieldId == Constants.FUNCIONES_VITALES_Presion_Sistolica_Id || C.v_ComponentFieldId == Constants.FUNCIONES_VITALES_Presion_Distolica_Id || C.v_ComponentFieldId == Constants.ANTROPOMETRIA_Imc_Id || C.v_ComponentFieldId == Constants.ESPIROMETRIA_Cvf_Id) &&
B.i_IsDeleted == 0 &&
C.i_IsDeleted == 0
select new
{
ServiceDate = A.d_ServiceDate,
ComponentFieldId = C.v_ComponentFieldId,
ServiceComponentFieldsId = C.v_ServiceComponentFieldsId,
Value1 = D.v_Value1,
}).ToList();
var serviceComponentFieldValuesTemp = (from a in serviceComponentFieldValues
select new
{
ServiceDate = a.ServiceDate.Value.Date,
ComponentFieldId = a.ComponentFieldId,
ServiceComponentFieldsId = a.ServiceComponentFieldsId,
Value1 = a.Value1
}).ToList();
serviceComponentFieldValuesTemp = serviceComponentFieldValuesTemp.GroupBy(g => new { g.ServiceDate, g.ComponentFieldId }).Select(s => s.First()).ToList();
Indicators oIndicators = new Indicators();
oIndicators.PersonId = patientId;
#region Data
List <DataPatient> Data = new List <DataPatient>();
var oDataPatient = new DataPatient();
oDataPatient.Name = serviceDataTemp[0].FullName;
oDataPatient.Empresa = serviceDataTemp[0].Empresa;
oDataPatient.Puesto = serviceDataTemp[0].Puesto;
Data.Add(oDataPatient);
oIndicators.DataPatient = Data;
#endregion
#region IMC
List <Weight> Weights = new List <Weight>();
var ListWeights = serviceComponentFieldValuesTemp.FindAll(p => p.ComponentFieldId == Constants.ANTROPOMETRIA_Imc_Id).ToList();
var ListWeightsSort = ListWeights.OrderByDescending(o1 => o1.ServiceDate).ToList();
foreach (var item in ListWeightsSort)
{
var oWeight = new Weight();
oWeight.Date = item.ServiceDate.ToString("dd-MM-yyyy");
oWeight.y = item.Value1;
Weights.Add(oWeight);
}
oIndicators.Weights = Weights;
#endregion
#region BloodPressureSis
var BloodPressureSis = new List <BloodPressureSis>();
var ListBloodPressureSis = serviceComponentFieldValuesTemp.FindAll(p => p.ComponentFieldId == Constants.FUNCIONES_VITALES_Presion_Sistolica_Id).OrderBy(p => p.ServiceDate);
foreach (var item in ListBloodPressureSis)
{
var oBloodPressureSis = new BloodPressureSis();
oBloodPressureSis.Date = item.ServiceDate.ToString("dd-MM-yyyy");
oBloodPressureSis.y = item.Value1;
BloodPressureSis.Add(oBloodPressureSis);
}
oIndicators.BloodPressureSis = BloodPressureSis;
#endregion
#region BloodPressureDia
var BloodPressureDia = new List <BloodPressureDia>();
var ListBloodPressureDia = serviceComponentFieldValuesTemp.FindAll(p => p.ComponentFieldId == Constants.FUNCIONES_VITALES_Presion_Distolica_Id).OrderBy(p => p.ServiceDate);
foreach (var item in ListBloodPressureDia)
{
var oBloodPressureDia = new BloodPressureDia();
oBloodPressureDia.Date = item.ServiceDate.ToString("dd-MM-yyyy");
oBloodPressureDia.y = item.Value1;
BloodPressureDia.Add(oBloodPressureDia);
}
oIndicators.BloodPressureDia = BloodPressureDia;
#endregion
#region Cholesterol
var Cholesterol = new List <Cholesterol>();
var ListCholesterol = serviceComponentFieldValuesTemp.FindAll(p => p.ComponentFieldId == Constants.COLESTEROL_TOTAL_Colesterol_Total_Id || p.ComponentFieldId == Constants.PERFIL_LIPIDICO_Colesterol_Total_Id).OrderBy(p => p.ServiceDate);
foreach (var item in ListCholesterol)
{
var oCholesterol = new Cholesterol();
oCholesterol.Date = item.ServiceDate.ToString("dd-MM-yyyy");
oCholesterol.y = item.Value1;
Cholesterol.Add(oCholesterol);
}
oIndicators.Cholesterols = Cholesterol;
#endregion
#region Glucoses
var Glucoses = new List <Glucose>();
var ListGlucoses = serviceComponentFieldValuesTemp.FindAll(p => p.ComponentFieldId == Constants.GLUCOSA_Glucosa_Id).OrderBy(p => p.ServiceDate);
foreach (var item in ListGlucoses)
{
var oGlucoses = new Glucose();
oGlucoses.Date = item.ServiceDate.ToString("dd-MM-yyyy");
oGlucoses.y = item.Value1;
Glucoses.Add(oGlucoses);
}
oIndicators.Glucoses = Glucoses;
#endregion
#region Haemoglobin
var Haemoglobins = new List <Haemoglobin>();
var ListHaemoglobins = serviceComponentFieldValuesTemp.FindAll(p => p.ComponentFieldId == Constants.HEMOGLOBINA_Hemoglobina_Id || p.ComponentFieldId == Constants.HEMOGRAMA_Hemoglobina_Id).OrderBy(p => p.ServiceDate);
foreach (var item in ListHaemoglobins)
{
var oHaemoglobin = new Haemoglobin();
oHaemoglobin.Date = item.ServiceDate.ToString("dd-MM-yyyy");
oHaemoglobin.y = item.Value1;
Haemoglobins.Add(oHaemoglobin);
}
oIndicators.Haemoglobins = Haemoglobins;
#endregion
#region Espiro
var Espiros = new List <Espiro>();
var ListEspiros = serviceComponentFieldValuesTemp.FindAll(p => p.ComponentFieldId == Constants.ESPIROMETRIA_Cvf_Id).OrderBy(p => p.ServiceDate);
foreach (var item in ListEspiros)
{
var oEspiro = new Espiro();
oEspiro.Date = item.ServiceDate.ToString("dd-MM-yyyy");
oEspiro.y = item.Value1;
Espiros.Add(oEspiro);
}
oIndicators.Espiros = Espiros;
#endregion
return(oIndicators);
}
catch (Exception ex)
{
throw;
}
}
public RegistrationViewDetailsModel GetUserDetailsByRegistrationID(int?RegistrationID)
{
try
{
using (var _context = new DatabaseContext())
{
//string[] RoleCodes = new string[] { "SuperAdmin", "Manager" };
var queryResult = (from registration in _context.Registration
join A in _context.AssignedRoles on registration.RegistrationID equals A.RegistrationID into A_join
from A in A_join.DefaultIfEmpty()
join AA in _context.Registration on A.AssignToAdmin equals AA.RegistrationID into AA_join
from AA in AA_join.DefaultIfEmpty()
join role in _context.Role on registration.RoleID equals role.RoleID into RL_join
from role in RL_join.DefaultIfEmpty()
join department in _context.Departments on registration.DeptId equals department.DeptId into D_join
from department in D_join.DefaultIfEmpty()
join job in _context.Jobs on registration.JobId equals job.JobId into J_join
from job in J_join.DefaultIfEmpty()
where registration.RegistrationID == RegistrationID
select new RegistrationViewModel()
{
registration = registration,
roles = role,
departments = department,
jobs = job,
ManagerFirstName = AA.FirstName,
ManagerLastName = AA.LastName,
ManagerMiddleName = AA.MiddleName
}).FirstOrDefault();
if (queryResult != null)
{
var objRegistrationViewDetailsModel = new RegistrationViewDetailsModel()
{
Birthdate = string.IsNullOrEmpty(queryResult.registration.Birthdate.ToString()) ? "" : Convert.ToDateTime(queryResult.registration.Birthdate, new CultureInfo("es-US", true)).ToString("MM/dd/yyyy"),
DateofJoining = string.IsNullOrEmpty(queryResult.registration.DateofJoining.ToString()) ? "" : Convert.ToDateTime(queryResult.registration.DateofJoining, new CultureInfo("es-US", true)).ToString("MM/dd/yyyy"),
DateofLeaving = string.IsNullOrEmpty(queryResult.registration.DateofLeaving.ToString()) ? "" : Convert.ToDateTime(queryResult.registration.DateofLeaving, new CultureInfo("es-US", true)).ToString("MM/dd/yyyy"),
EmailID = queryResult.registration.EmailID,
EmployeeID = queryResult.registration.EmployeeID,
Gender = queryResult.registration.Gender,
IsActive = Convert.ToBoolean(queryResult.registration.IsActive),
Mobileno = queryResult.registration.Mobileno,
FirstName = queryResult.registration.FirstName,
MiddleName = queryResult.registration.MiddleName,
LastName = queryResult.registration.LastName,
RegistrationID = queryResult.registration.RegistrationID,
RoleID = Convert.ToInt32(queryResult.registration.RoleID),
Username = queryResult.registration.Username,
WorkEmail = queryResult.registration.WorkEmail,
EmergencyContact = queryResult.registration.EmergencyContact,
EmergencyContactNumber = queryResult.registration.EmergencyContactNumber,
DeptId = Convert.ToInt32(queryResult.registration.DeptId),
ManagerId = Convert.ToInt32(queryResult.registration.ManagerId),
JobId = Convert.ToInt32(queryResult.registration.JobId),
JobTitle = queryResult.jobs == null ? "" : queryResult.jobs.JobTitle,
RoleName = queryResult.roles == null ? "" : queryResult.roles.Rolename,
DepartmentName = queryResult.departments == null ? "" : queryResult.departments.DepartmentName,
ManagerFirstName = queryResult.ManagerFirstName == null ? "" : queryResult.ManagerFirstName,
ManagerMiddleName = queryResult.ManagerMiddleName == null ? "" : queryResult.ManagerMiddleName,
ManagerLastName = queryResult.ManagerLastName == null ? "" : queryResult.ManagerLastName
};
return(objRegistrationViewDetailsModel);
}
return(new RegistrationViewDetailsModel());
}
}
catch (Exception ex)
{
throw ex;
}
}
