public LookupsDTO GetLookupByLookupCode(string code, Enums.Culture culture)
{
using (UnitOfWork uow = new UnitOfWork())
{
var repo = uow.Lookups;
var lookup = repo.GetLookupValueAndIDByCode(code);
if (culture == Enums.Culture.Arabic)
{
lookup = new LookupsDTO()
{
Id = lookup.Id,
Value = lookup.ValueAr
};
}
else
{
lookup = new LookupsDTO()
{
Id = lookup.Id,
Value = lookup.ValueEn
};
}
if (lookup == null)
{
throw new BusinessException("Lookup does not exist", Constants.ErrorsCodes.LookupDoesNotExist);
}
return(lookup);
}
}
public List <UserDDLDTO> GetAccountDDL(Enums.Culture cul)
{
using (UnitOfWork uow = new UnitOfWork())
{
try
{
var Departments = uow.Users.GetAccountDDL();
if (Departments != null)
{
if (cul == Enums.Culture.Arabic)
{
foreach (var i in Departments)
{
i.Value = i.ValueAr;
i.ValueAr = i.ValueAr;
}
}
else
{
foreach (var i in Departments)
{
i.Value = i.Value;
i.ValueAr = i.Value;
}
}
return(Departments);
}
else
{
return(null);
}
}
catch (Exception ex)
{
ex.Data.Add("GetDepartments", "An error occurred while trying to create GetDepartments Record - BLL");
uow.Rollback();
return(null);
}
}
}
public IEnumerable <LookupsDTO> GetLookupsByLookupCategoryCode(string lookupCategoryCode, Enums.Culture cul)
{
if (cul == 0)
{
cul = Enums.Culture.Arabic;
}
int language = (int)Enums.CultureID.Ar;
if (cul == Enums.Culture.Arabic)
{
language = (int)Enums.CultureID.Ar;
}
else
{
language = (int)Enums.CultureID.En;
}
var repository = _uow.LookupCategory;
var data = (from cat in _db.LookupCategories
join look in _db.Lookups on cat.Id equals look.CategoryId
join looCul in _db.LookupCultures on look.Id equals looCul.LookupID
join culture in _db.Cultures on looCul.CultureID equals culture.CultureID
where culture.CultureID == language && cat.FixedCode == lookupCategoryCode
select new LookupsDTO
{
Value = looCul.Value,
Id = looCul.LookupID,
LookupCode = looCul.Lookup.LookupCode,
}).ToList();
if (data == null)
{
return(null);
}
return(data);
}
public IEnumerable <LookupsDTO> GetLookupsByLookupCategoryCode(string lookupCategoryCode, Enums.Culture cul)
{
using (UnitOfWork uow = new UnitOfWork())
{
var repo = uow.LookupCategory;
var lookup = repo.GetLookupsByLookupCategoryCode(lookupCategoryCode, cul);
if (lookup == null)
{
throw new BusinessException("Lookup does not exist", Constants.ErrorsCodes.LookupDoesNotExist);
}
else
{
return(lookup);
}
}
}
public IEnumerable <LookupsDTO> GetLookupsByLookupCategoryCode(string lookupCategoryCode, Enums.Culture cul)
{
using (UnitOfWork uow = new UnitOfWork())
{
var repo = uow.LookupCategory;
var lookup = repo.GetLookupsByLookupCategoryCode(lookupCategoryCode, cul);
if (lookup == null)
{
return(null);
}
else
{
return(lookup);
}
}
}