public static List <MPerson> fnListPerson(int?idPerson, int?PersonType, int?Department = null, bool?PersonStatus = null, int?IdUser = null)
{
List <MPerson> ListPerson = new List <MPerson>();
MMEnterprisesEntities db = new MMEnterprisesEntities();
MUser objUser = new MUser();
ListPerson = (from result in db.GNListPerson(idPerson, PersonType, PersonStatus, Department, IdUser).ToList()
select new MPerson
{
IdPerson = result.IdPerson,
IdPersonType = result.IdPersonType,
PersonType = result.PersonType,
IdIdentificationType = result.IdIdentificationType,
IdentificationType = result.IdentificationType,
NumIdentification = objUser.Desencriptar(result.NumIdentification),
Name = result.Name,
LastName = result.LastName,
Birthday = result.Birthday,
Address = objUser.Desencriptar(result.Address),
Email = result.Email,
IdContactType = result.IdContactType,
ContactType = result.ContactType,
IdPosition = result.IdPosition,
Position = result.Position,
ClientPermission = result.ClientPermission,
Status = result.Status,
StatusDesc = result.Status == true ? "Activo" : "Inactivo",
IdDepartment = result.IdDepartment,
Department = result.Department,
listPersonContact = (List <MPersonContact>)(from result2 in db.GNListPersonContact(result.IdPerson, result.IdPersonType, null).ToList()
select new MPersonContact
{
IdContact = result2.IdContact,
IdPerson = result2.IdPerson,
IdPhoneNumberType = result2.IdPhoneNumberType,
PhoneNumberType = result2.PhoneNumberType,
IdIsoCountry = result2.IdIsoCountry,
CountryAreaCode = result2.CountryAreaCode,
PhoneNumber = objUser.Desencriptar(result2.PhoneNumber),
Status = result2.Status
}).ToList()
}).ToList();
return(ListPerson);
}
/// <summary>
/// Filtrar por "IdUserOnBehalfOf" para la pantalla "ListConfigTkOnBehalfOf" , la tabla se llena con IdConfig,IdUser,NumIdentification,Name,LastName.
/// Filtrar por "IdUser" para la pantalla "AddTask" y para llenar el combobox usar IdUserOnBehalfOf,NumIdentificationOnBehalfOf,NameOnBehalfOf,LastNameOnBehalfOf.
/// </summary>
public static List <MConfigTkOnBehalfOf> fnListMConfigTkOnBehalfOf(int?IdUser = null, int?IdUserOnBehalfOf = null, int?IdConfig = null)
{
List <MConfigTkOnBehalfOf> ListConfigTkOnBehalfOf = new List <MConfigTkOnBehalfOf>();
MMEnterprisesEntities db = new MMEnterprisesEntities();
MUser objUser = new MUser();
ListConfigTkOnBehalfOf = (from result in db.GNListConfigTkOnBehalfOf(IdUser, IdUserOnBehalfOf, IdConfig).ToList()
select new MConfigTkOnBehalfOf
{
IdConfig = result.IdConfig,
IdUserOnBehalfOf = result.IdUserOnBehalfOf,
NumIdentificationOnBehalfOf = objUser.Desencriptar(result.NumIdentificationOnBehalfOf),
NameOnBehalfOf = result.NameOnBehalfOf,
LastNameOnBehalfOf = result.LastNameOnBehalfOf,
IdUser = result.IdUser,
NumIdentification = objUser.Desencriptar(result.NumIdentification),
Name = result.Name,
LastName = result.LastName
}).ToList();
return(ListConfigTkOnBehalfOf);
}
/// <summary>
/// Lista usuarios con informacion basica Sin accesos.
/// Se puede Filtrar por IdUser, Status, IdPerson.
/// </summary>
/// <param optional name="IdUser"></param> <param optional name="Status"></param> <param optional name="IdPerson"></param>
/// <returns>Lista de tipo MUser</returns>
public List <MUser> fnListUser(int?IdUser = null, bool?Status = null, int?IdPerson = null)
{
List <MUser> ListUser = new List <MUser>();
MMEnterprisesEntities db = new MMEnterprisesEntities();
MUser ObjUser = new MUser();
ListUser = (from result in db.GNListUser(IdUser, Status, IdPerson).ToList()
select new MUser
{
IdUser = result.IdUser,
IdPerson = result.IdPerson,
Login = result.Login,
Status = result.Status,
StatusDesc = result.Status == true ? "Activo" : "Inactivo",
PersonEmployee = (MPerson)(from result2 in db.GNListPerson(result.IdPerson, 2, null, null, null).ToList()
select new MPerson
{
//IdPerson = result2.IdPerson,
//IdPersonType = result2.IdPersonType,
//PersonType = result2.PersonType,
//IdIdentificationType = result2.IdIdentificationType,
//IdentificationType = result2.IdentificationType,
NumIdentification = ObjUser.Desencriptar(result2.NumIdentification),
Name = result2.Name,
LastName = result2.LastName,
//Birthday = result2.Birthday,
//Address = ObjUser.Desencriptar(result2.Address),
//Email = result2.Email,
//IdContactType = result2.IdContactType,
//ContactType = result2.ContactType,
//IdPosition = result2.IdPosition,
Position = result2.Position //,
//ClientPermission = result2.ClientPermission,
//Status = result2.Status
}).ToList().FirstOrDefault(),
UserRolesNames = String.Join(",", db.GNListUserRole(null, result.IdUser).Select(c => c.NameRole).ToList())
}).ToList();
return(ListUser);
}
public static List <MTask> fnListTask(int?IdTask = null, DateTime?dttDateIni = null, DateTime?dttDateEnd = null, int?IdResponsable = null, string strTittle = "", int?IdPriority = null, int?IdStatus = null, int?IdTypeTask = null, int?IdServiceRequest = null, int?IdUser = null, int?IdFatherTask = null, int?IdColaborator = null, int?IdFollower = null)
{
List <MTask> listTask = new List <MTask>();
MMEnterprisesEntities db = new MMEnterprisesEntities();
MUser objUser = new MUser();
listTask = (List <MTask>)(from tsk in db.GNListTask(IdTask, dttDateIni, dttDateEnd, IdResponsable, strTittle, IdPriority, IdStatus, IdTypeTask, IdServiceRequest, IdUser, IdFatherTask, IdColaborator, IdFollower).ToList()
select new MTask
{
IdTask = tsk.IdTask,
IdUser = tsk.IdUser,
UserName = tsk.UserName,
UserLastName = tsk.UserLastName,
DateIni = tsk.DateIni,
DateEnd = tsk.DateEnd,
HourIni = tsk.HourIni,
HourEnd = tsk.HourEnd,
Place = tsk.Place,
Status = tsk.Status,
IdStatus = tsk.IdStatus,
IdFatherTask = tsk.IdFatherTask,
Tittle = tsk.Tittle,
IdServiceRequest = tsk.IdServiceRequest,
IdTypeTask = tsk.IdTypeTask,
TypeTask = tsk.TypeTask,
IdPriority = tsk.IdPriority,
PriorityTask = tsk.PriorityTask,
IdPersonEmployee = tsk.IdResponsable,
PersonEmployeeName = tsk.Name,
PersonEmployeeLastName = tsk.LastName,
Activity = tsk.Activity,
Confidential = tsk.confidential == null ? false : (bool)tsk.confidential,
listTaskPerson = (List <MTaskPerson>)(from tp in db.GNListPersonTask(tsk.IdTask, null).ToList()
select new MTaskPerson
{
IdPersonEmployee = tp.IdPersonEmployee,
PersonEmployeeName = tp.PersonEmployeeName,
PersonEmployeeLastName = tp.PersonEmployeeLastName,
NumIdentification = objUser.Desencriptar(tp.NumIdentification),
Iscolaborator = tp.Iscolaborator
}).ToList()
,
listMTaskComment = (List <MTaskComment>)(from tp in db.GNListBitacora(tsk.IdTask).ToList()
select new MTaskComment
{
IdComment = tp.IdComment,
IdTask = tp.IdTask,
Comment = tp.Comment,
IdUser = tp.IdUser,
UserName = tp.UserName,
DateOperation = tp.DateOperation,
Date = tp.Date,
New = 0,
}).ToList(),
Creator = (string)(from tt in db.GNListPerson(null, null, null, null, tsk.IdUser).ToList()
select tt.LastName + " " + tt.Name).FirstOrDefault(),
Colaborator = tsk.Colaborator,
Follower = tsk.Seguidor,
OperationDate = tsk.OperationDate,
CreationDate = tsk.CreationDate,
IdCreatedBy = tsk.IdCreatedBy,
}).ToList();
return(listTask);
//ListUserCreate = (from result in db.GNListConfigTkOnBehalfOf(IdUser, null, null).ToList()
// select new MConfigTkOnBehalfOf
// {
// IdUserOnBehalfOf = result.IdUserOnBehalfOf,
// Name = objUser.Desencriptar(result.NumIdentificationOnBehalfOf) + " - " + result.LastNameOnBehalfOf + (result.NameOnBehalfOf != "" ? " " + result.NameOnBehalfOf : ""),
// }).ToList()
}
/// <summary>
/// Busca informacion completa de un usuario Con sus accesos.
/// Se puede buscar Usuario por IdUser o por IdPerson
/// </summary>
/// <param optional name="IdUser"></param> <param optional name="Status"></param> <param optional name="IdPerson"></param>
/// <returns>Objeto de tipo MUser</returns>
public MUser fnSearchUser(int?IdUser = null, bool?Status = null, int?IdPerson = null)
{
MUser objMUser = new MUser();
MMEnterprisesEntities db = new MMEnterprisesEntities();
string listIdRoles = String.Join(",", db.GNListUserRole(null, IdUser).Select(c => c.IdRole).ToList());
objMUser = (from result in db.GNListUser(IdUser, Status, IdPerson).ToList()
select new MUser
{
IdUser = result.IdUser,
IdPerson = result.IdPerson,
Login = result.Login,
Password = objMUser.Desencriptar(result.Password),
Status = result.Status,
StatusDesc = result.Status == true ? "Activo" : "Inactivo",
PersonEmployee = (MPerson)(from result2 in db.GNListPerson(result.IdPerson, 2, null, null, null).ToList()
select new MPerson
{
IdPerson = result2.IdPerson,
IdPersonType = result2.IdPersonType,
PersonType = result2.PersonType,
IdIdentificationType = result2.IdIdentificationType,
IdentificationType = result2.IdentificationType,
NumIdentification = objMUser.Desencriptar(result2.NumIdentification),
Name = result2.Name,
LastName = result2.LastName,
Birthday = result2.Birthday,
Address = objMUser.Desencriptar(result2.Address),
Email = result2.Email,
IdContactType = result2.IdContactType,
ContactType = result2.ContactType,
IdPosition = result2.IdPosition,
Position = result2.Position,
ClientPermission = result2.ClientPermission,
Status = result2.Status
}).ToList().First(),
Roles = (from resultRoles in db.GNListUserRole(null, result.IdUser).ToList()
select new MRole
{
IdRole = resultRoles.IdRole,
NameRole = resultRoles.NameRole
}).ToList(),
UserAcces = (from result3 in db.GNListUserAcces(result.IdUser, null, listIdRoles).ToList()
select new MUserAcces
{
IdOption = result3.IdOption,
OptionName = result3.OptionName,
Visible = result3.Visible == null ? false : (bool)result3.Visible,
Create = result3.Create == null ? false : (bool)result3.Create,
Search = result3.Search == null ? false : (bool)result3.Search,
Edit = result3.Edit == null ? false : (bool)result3.Edit,
Delete = result3.Edit == null ? false : (bool)result3.Delete,
IdAssociated = result3.IdAssociated,
Action = result3.Action,
Controller = result3.Controller
}).ToList(),
UserAccesPadre = (from result3 in db.GNListUserAcces(null, null, null).ToList()
select new MUserAcces
{
IdOption = result3.IdOption,
OptionName = result3.OptionName,
Visible = result3.Visible == null ? false : (bool)result3.Visible,
Create = result3.Create == null ? false : (bool)result3.Create,
Search = result3.Search == null ? false : (bool)result3.Search,
Edit = result3.Edit == null ? false : (bool)result3.Edit,
Delete = result3.Edit == null ? false : (bool)result3.Delete,
IdAssociated = result3.IdAssociated,
Action = result3.Action,
Controller = result3.Controller
}).ToList()
}).First();
return(objMUser);
}
