public tbl_ChangePassword FindChangePwdUserName(string userName)
{
IGenericDataRepository <tbl_ChangePassword> repository = new GenericDataRepository <tbl_ChangePassword>();
tbl_ChangePassword tblChangePassword = repository.GetSingle(c => c.UserName.ToUpper() == userName.ToUpper());
return(tblChangePassword);
}
public TranslationDto GetSingle(Expression <Func <TranslationDto, bool> > where,
params Expression <Func <TranslationDto, object> >[] navigationProperties)
{
var where2 = _mapper.Map <Func <Translation, bool> >(where);
var navProp = _mapper.Map <Expression <Func <Translation, object> >[]>(navigationProperties);
return(_mapper.Map <TranslationDto>(_translationRepo.GetSingle(where2, navProp)));
}
public tbl_Region FindRegionName(string regionName)
{
try
{
IGenericDataRepository <tbl_Region> repository = new GenericDataRepository <tbl_Region>();
tbl_Region tblRegion = repository.GetSingle(c => c.Region.ToUpper() == regionName.ToUpper());
return(tblRegion);
}
catch (Exception)
{
throw;
}
}
public tbl_ChangePassword FindChangePwdDetails(int?changePwdId)
{
try
{
IGenericDataRepository <tbl_ChangePassword> repository = new GenericDataRepository <tbl_ChangePassword>();
tbl_ChangePassword changePwd = repository.GetSingle(c => c.UserID == changePwdId);
return(changePwd);
}
catch (Exception ex)
{
throw;
}
}
public tbl_Module FindModuleName(string modName, int applicationId)
{
try
{
IGenericDataRepository <tbl_Module> repository = new GenericDataRepository <tbl_Module>();
tbl_Module module = repository.GetSingle(m => m.ModuleName.ToUpper() == modName.ToUpper() && m.ApplicationId == applicationId);
return(module);
}
catch (Exception)
{
throw;
}
}
public tbl_Attribute FindAttribDesc(string attributeDesc, int daid)
{
try
{
IGenericDataRepository <tbl_Attribute> repository = new GenericDataRepository <tbl_Attribute>();
tbl_Attribute tblattribDesc = repository.GetSingle(b => b.AttributeDesc.ToUpper() == attributeDesc.ToUpper() && b.daId == daid);
return(tblattribDesc);
}
catch (Exception)
{
throw;
}
}
public tbl_DesignAccelerator FindDA(int?DAID)
{
try
{
IGenericDataRepository <tbl_DesignAccelerator> repository = new GenericDataRepository <tbl_DesignAccelerator>();
tbl_DesignAccelerator DA = repository.GetSingle(c => c.daid == DAID);
return(DA);
}
catch (Exception)
{
throw;
}
}
public tbl_FrequencyType FindFrequencyTypes(int?FreqTypeID)
{
try
{
IGenericDataRepository <tbl_FrequencyType> repository = new GenericDataRepository <tbl_FrequencyType>();
tbl_FrequencyType tblFrequencyTypes = repository.GetSingle(b => b.FreqTypeID == FreqTypeID);
return(tblFrequencyTypes);
}
catch (Exception)
{
throw;
}
}
public tbl_Roles FindRoleName(string roleName)
{
try
{
IGenericDataRepository <tbl_Roles> repository = new GenericDataRepository <tbl_Roles>();
tbl_Roles tblRole = repository.GetSingle(c => c.RoleName.ToUpper() == roleName.ToUpper());
return(tblRole);
}
catch (Exception)
{
throw;
}
}
public tbl_Applications FindApplication(int?applicationID)
{
try
{
IGenericDataRepository <tbl_Applications> repository = new GenericDataRepository <tbl_Applications>();
tbl_Applications application = repository.GetSingle(c => c.ApplicationID == applicationID);
return(application);
}
catch (Exception)
{
throw;
}
}
public tbl_Clients FindClientName(string clientName)
{
try
{
IGenericDataRepository <tbl_Clients> repository = new GenericDataRepository <tbl_Clients>();
tbl_Clients tblclientName = repository.GetSingle(c => c.ClientName.ToUpper() == clientName.ToUpper());
return(tblclientName);
}
catch (Exception)
{
throw;
}
}
public tbl_Clients FindClient(int?clientID)
{
try
{
IGenericDataRepository <tbl_Clients> repository = new GenericDataRepository <tbl_Clients>();
tbl_Clients client = repository.GetSingle(c => c.ClientID == clientID);
return(client);
}
catch (Exception)
{
throw;
}
}
public tbl_Transactions FindTransaction(int?TransactionSeq)
{
try
{
IGenericDataRepository <tbl_Transactions> repository = new GenericDataRepository <tbl_Transactions>();
tbl_Transactions tblTransactions = repository.GetSingle(b => b.TransactionSeq == TransactionSeq);
return(tblTransactions);
}
catch (Exception)
{
throw;
}
}
public tbl_Projects FindProjectName(string projectName, int clientId, int regionId)
{
try
{
IGenericDataRepository <tbl_Projects> repository = new GenericDataRepository <tbl_Projects>();
tbl_Projects Project = repository.GetSingle(c => c.ProjectName.ToUpper() == projectName.ToUpper() && c.ClientId == clientId && c.RegionId == regionId);
return(Project);
}
catch (Exception)
{
throw;
}
}
public tbl_Roles FindRoles(int?roleId)
{
try
{
IGenericDataRepository <tbl_Roles> repository = new GenericDataRepository <tbl_Roles>();
tbl_Roles roles = repository.GetSingle(c => c.RoleID == roleId);
return(roles);
}
catch (Exception)
{
throw;
}
}
public tbl_BuzProd FindBuzProd(int?buzProdID)
{
try
{
IGenericDataRepository <tbl_BuzProd> repository = new GenericDataRepository <tbl_BuzProd>();
tbl_BuzProd tblbuzprod = repository.GetSingle(b => b.BuzProdID == buzProdID);
return(tblbuzprod);
}
catch (Exception)
{
throw;
}
}
public tbl_LifeCycle FindLifeCycles(int?LifeCycleID)
{
try
{
IGenericDataRepository <tbl_LifeCycle> repository = new GenericDataRepository <tbl_LifeCycle>();
tbl_LifeCycle tblLifeCycles = repository.GetSingle(b => b.LifeCycleID == LifeCycleID);
return(tblLifeCycles);
}
catch (Exception)
{
throw;
}
}
public tbl_UserData FindUser(string userName)
{
try
{
IGenericDataRepository <tbl_UserData> repository = new GenericDataRepository <tbl_UserData>();
tbl_UserData UsrData = repository.GetSingle(c => c.UserName == userName);
return(UsrData);
}
catch (Exception)
{
throw;
}
}
//changed as per requirement for flow implementation on - 15/11/2016
public tbl_Products FindProduct(int?ProductID)
{
try
{
IGenericDataRepository <tbl_Products> repository = new GenericDataRepository <tbl_Products>();
tbl_Products tblProducts = repository.GetSingle(b => b.ProductID == ProductID);
return(tblProducts);
}
catch (Exception)
{
throw;
}
}
public tbl_FrequencyType FindFrequencyTypeDesc(string freqTypeDesc, int daid)
{
try
{
IGenericDataRepository <tbl_FrequencyType> repository = new GenericDataRepository <tbl_FrequencyType>();
tbl_FrequencyType tblFrequencyTypes = repository.GetSingle(b => b.FreqTypeDesc.ToUpper() == freqTypeDesc.ToUpper() && b.daId == daid);
return(tblFrequencyTypes);
}
catch (Exception)
{
throw;
}
}
public tbl_ModeType FindModeTypes(int?ModeTypeID)
{
try
{
IGenericDataRepository <tbl_ModeType> repository = new GenericDataRepository <tbl_ModeType>();
tbl_ModeType tblModeTypes = repository.GetSingle(b => b.ModeTypeID == ModeTypeID);
return(tblModeTypes);
}
catch (Exception)
{
throw;
}
}
public tbl_UserData FindUserData(int?userId)
{
try
{
IGenericDataRepository <tbl_UserData> repository = new GenericDataRepository <tbl_UserData>();
tbl_UserData userData = repository.GetSingle(c => c.UserID == userId);
return(userData);
}
catch (Exception)
{
throw;
}
}
public tbl_ModeType FindModeDesc(string modeTypedesc, int daid)
{
try
{
IGenericDataRepository <tbl_ModeType> repository = new GenericDataRepository <tbl_ModeType>();
tbl_ModeType tblModeTypes = repository.GetSingle(b => b.ModeTypeDesc.ToUpper() == modeTypedesc.ToUpper() && b.daId == daid);
return(tblModeTypes);
}
catch (Exception)
{
throw;
}
}
public tbl_AttributeType FindAttribType(int?attributeTypeID)
{
try
{
IGenericDataRepository <tbl_AttributeType> repository = new GenericDataRepository <tbl_AttributeType>();
tbl_AttributeType tblattribTypeID = repository.GetSingle(b => b.AttributeTypeID == attributeTypeID);
return(tblattribTypeID);
}
catch (Exception)
{
throw;
}
}
public void DeleteMappedScreenRole(tbl_RoleScreenMapping roleScreenMapping)
{
try
{
IGenericDataRepository <tbl_RoleScreenMapping> repository = new GenericDataRepository <tbl_RoleScreenMapping>();
var a = repository.GetSingle(q => q.RoleScreenMappingID == roleScreenMapping.RoleScreenMappingID);
repository.Remove(roleScreenMapping);
}
catch (Exception)
{
throw;
}
}
public tbl_Module FindModuleNameForRunPlan(int?moduleId)
{
try
{
IGenericDataRepository <tbl_Module> repository = new GenericDataRepository <tbl_Module>();
tbl_Module module = repository.GetSingle(m => m.ModuleID == moduleId);
return(module);
}
catch (Exception)
{
throw;
}
}
public tbl_AppVersion FindAppVersion(int?Id)
{
try
{
IGenericDataRepository <tbl_AppVersion> repository = new GenericDataRepository <tbl_AppVersion>();
tbl_AppVersion appVersion = repository.GetSingle(c => c.Id == Id);
return(appVersion);
}
catch (Exception)
{
throw;
}
}
public tbl_Projects FindProject(int?projectID)
{
try
{
IGenericDataRepository <tbl_Projects> repository = new GenericDataRepository <tbl_Projects>();
tbl_Projects Project = repository.GetSingle(c => c.ProjectID == projectID);
return(Project);
}
catch (Exception)
{
throw;
}
}
public ApiResponse <DTODerechohabiente> GetDerechohabienteByNoIssste(string noIssste)
{
ApiResponse <DTODerechohabiente> apiResponse = new ApiResponse <DTODerechohabiente>();
try
{
MapperConfiguration mapperConfiguration = new MapperConfiguration(x => { x.CreateMap <Derechohabiente, DTODerechohabiente>(); });
IMapper mapper = mapperConfiguration.CreateMapper();
Derechohabiente derechohabiente = _repository.GetSingle(x => x.NoIssste == noIssste);
if (derechohabiente != null)
{
GenericDataRepository <CatEstados> estadosRepository = new GenericDataRepository <CatEstados>();
DTODerechohabiente derechohabienteDto = mapper.Map <Derechohabiente, DTODerechohabiente>(derechohabiente);
if (derechohabienteDto != null)
{
derechohabienteDto.TipoDerechohabiente = derechohabienteDto.TipoDerechohabiente == "T" ? "TRABAJADOR" : "PENSIONADO";
derechohabienteDto.NombreCompleto = string.Join(" ", new[] { derechohabienteDto.Nombre, derechohabienteDto.ApellidoPaterno, derechohabienteDto.ApellidoMaterno });
derechohabienteDto.Genero = derechohabienteDto.IdGenero == 1 ? "MUJER" : "HOMBRE";
derechohabienteDto.Edad = DateTime.Now.Year - derechohabienteDto.FechaNacimiento.Year;
derechohabienteDto.Estado = estadosRepository.GetSingle(x => x.IdEstado == derechohabienteDto.IdEstado).Nombre.ToUpper();
apiResponse.Data = derechohabienteDto;
apiResponse.Result = (int)ApiResult.Success;
apiResponse.Message = Resources.ConsultaExitosa;
}
else
{
apiResponse.Result = (int)ApiResult.Failure;
apiResponse.Message = Resources.ConsultaFallida;
}
}
else if (derechohabiente == null)
{
apiResponse.Result = (int)ApiResult.Success;
}
}
catch (Exception ex)
{
apiResponse.Result = (int)ApiResult.Exception;
apiResponse.Message = ex.Message;
}
return(apiResponse);
}
public tbl_Destination FindDestinationDesc(string destDesc, int daid)
{
try
{
IGenericDataRepository <tbl_Destination> repository = new GenericDataRepository <tbl_Destination>();
tbl_Destination tblDestination = repository.GetSingle(d => d.DestDesc.ToUpper() == destDesc.ToUpper() && d.daId == daid);
return(tblDestination);
}
catch (Exception)
{
throw;
}
}