public ActionResult GetDataPacient(BoardPacients data)
{
Api API = new Api();
Dictionary <string, string> arg = new Dictionary <string, string>()
{
{ "String1", JsonConvert.SerializeObject(data) },
};
ViewBag.Pacients = API.Post <BoardPacients>("Pacient/GetAllPacient", arg);
return(PartialView("_BoardPacientPartial"));
}
public BoardPacients GetAllPacient(BoardPacients data)
{
return(new PacientDal().GetAllPacient(data));
}
public BoardPacients GetAllPacient(BoardPacients data)
{
try
{
DatabaseContext ctx = new DatabaseContext();
var isDeleted = (int)Enumeratores.SiNo.No;
//int groupDocTypeId = (int)Enumeratores.DataHierarchy.TypeDoc;
int skip = (data.Index - 1) * data.Take;
//filters
string filterPacient = string.IsNullOrWhiteSpace(data.Pacient) ? "" : data.Pacient;
//string filterDocNumber = string.IsNullOrWhiteSpace(data.DocNumber) ? "" : data.DocNumber;
var list = (from per in ctx.Person
//join dhy in ctx.DataHierarchy on new { a = per.i_DocTypeId.Value, b = groupDocTypeId } equals new { a = dhy.i_ItemId, b = dhy.i_GroupId }
join sys in ctx.SystemParameter on new { a = per.i_BloodGroupId.Value, b = 154 } equals new { a = sys.i_ParameterId, b = sys.i_GroupId } into sys_join from sys in sys_join.DefaultIfEmpty()
join sys2 in ctx.SystemParameter on new { a = per.i_BloodFactorId.Value, b = 155 } equals new { a = sys2.i_ParameterId, b = sys2.i_GroupId } into sys2_join from sys2 in sys2_join.DefaultIfEmpty()
where per.i_IsDeleted == isDeleted &&
(per.v_FirstName.Contains(filterPacient) || per.v_FirstLastName.Contains(filterPacient) || per.v_SecondLastName.Contains(filterPacient) || filterPacient == "" || per.v_DocNumber.Contains(filterPacient))
select new PacientCustom
{
v_PersonId = per.v_PersonId,
v_FirstName = per.v_FirstName,
v_FirstLastName = per.v_FirstLastName,
v_SecondLastName = per.v_SecondLastName,
//i_DocTypeId = per.i_DocTypeId,
v_DocNumber = per.v_DocNumber,
d_Birthdate = per.d_Birthdate,
//v_BirthPlace = per.v_BirthPlace,
//i_SexTypeId = per.i_SexTypeId,
//i_MaritalStatusId = per.i_MaritalStatusId,
//i_LevelOfId = per.i_LevelOfId,
v_TelephoneNumber = per.v_TelephoneNumber,
v_AdressLocation = per.v_AdressLocation,
// v_GeografyLocationId = per.v_GeografyLocationId,
//v_ContactName = per.v_ContactName,
//v_EmergencyPhone = per.v_EmergencyPhone,
b_PersonImage = per.b_PersonImage,
v_Mail = per.v_Mail,
//i_BloodGroupId = per.i_BloodGroupId,
//i_BloodFactorId = per.i_BloodFactorId,
// b_FingerPrintTemplate = per.b_FingerPrintTemplate,
//b_RubricImage = per.b_RubricImage,
//b_FingerPrintImage = per.b_FingerPrintImage,
//t_RubricImageText = per.t_RubricImageText,
v_CurrentOccupation = per.v_CurrentOccupation,
//i_DepartmentId = per.i_DepartmentId,
// i_ProvinceId = per.i_ProvinceId,
//i_DistrictId = per.i_DistrictId,
// i_ResidenceInWorkplaceId = per.i_ResidenceInWorkplaceId,
// v_ResidenceTimeInWorkplace = per.v_ResidenceTimeInWorkplace,
// i_TypeOfInsuranceId = per.i_TypeOfInsuranceId,
// i_NumberLivingChildren = per.i_NumberLivingChildren,
// i_NumberDependentChildren = per.i_NumberDependentChildren,
// i_OccupationTypeId = per.i_OccupationTypeId,
//v_OwnerName = per.v_OwnerName,
//i_NumberLiveChildren = per.i_NumberLiveChildren,
//i_NumberDeadChildren = per.i_NumberDeadChildren,
//i_IsDeleted = per.i_IsDeleted,
// i_InsertNodeId = per.i_InsertNodeId,
//i_UpdateNodeId = per.i_UpdateNodeId,
//i_Relationship = per.i_Relationship,
//v_ExploitedMineral = per.v_ExploitedMineral,
//i_AltitudeWorkId = per.i_AltitudeWorkId,
//i_PlaceWorkId = per.i_PlaceWorkId,
//v_NroPoliza = per.v_NroPoliza,
//v_Deducible = per.v_Deducible,
//i_NroHermanos = per.i_NroHermanos,
//v_Password = per.v_Password,
//v_Procedencia = per.v_Procedencia,
//v_CentroEducativo = per.v_CentroEducativo,
//v_Religion = per.v_Religion,
//v_Nacionalidad = per.v_Nacionalidad,
//v_ResidenciaAnterior = per.v_ResidenciaAnterior,
//v_Subs = per.v_Subs,
//v_ComentaryUpdate = per.v_ComentaryUpdate,
v_BloodGroupId = sys.v_Value1,
v_BloodFactorId = sys2.v_Value1,
}).OrderBy(x => x.v_FirstLastName).ToList();
int totalRecords = list.Count;
if (data.Take > 0)
{
list = list.Skip(skip).Take(data.Take).ToList();
}
data.TotalRecords = totalRecords;
foreach (var item in list)
{
item.PersonImage = item.b_PersonImage == null ? null : Convert.ToBase64String(item.b_PersonImage);
}
data.List = list;
return(data);
}
catch (Exception ex)
{
return(null);
}
}
