public static List <AreaContract> GetAreasByCode(int code, RecordTypesEnum recordType)
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var areasQuery = from t in db.CD_Areas
let areaType = t.AreaType
where areaType.Code == code
select t;
switch (recordType)
{
case RecordTypesEnum.Active:
{
areasQuery = from n in areasQuery
where n.DateDeleted == null
select n;
}
break;
case RecordTypesEnum.Inactive:
{
areasQuery = from n in areasQuery
where n.DateDeleted != null
select n;
}
break;
}
var areas = areasQuery.ToList();
return(areas.ToContracts());
}
}
public static List <AreaContract> GetAreas(AreaTypesEnum type, RecordTypesEnum recordType)
{
switch (type)
{
case AreaTypesEnum.Region:
return(GetAreasByCode((int)AreaTypesEnum.Region, recordType));
case AreaTypesEnum.Municipality:
return(GetAreasByCode((int)AreaTypesEnum.Municipality, recordType));
case AreaTypesEnum.MunicipalCenter:
return(GetAreasByCode((int)AreaTypesEnum.MunicipalCenter, recordType));
case AreaTypesEnum.Town:
return(GetAreasByCode((int)AreaTypesEnum.Town, recordType));
case AreaTypesEnum.Village:
return(GetAreasByCode((int)AreaTypesEnum.Village, recordType));
case AreaTypesEnum.Country:
return(GetAreasByCode((int)AreaTypesEnum.Country, recordType));
}
return(null);
}
public static List <AreaContract> GetAreasByCode(int code, RecordTypesEnum recordType)
{
var session = Hb8Factory.InitSession();
var areasQuery = from n in session.Query <CD_Area>()
where n.AreaType.Code == code
select n;
switch (recordType)
{
case RecordTypesEnum.Active:
{
areasQuery = from n in areasQuery
where n.DateDeleted == null
select n;
}
break;
case RecordTypesEnum.Inactive:
{
areasQuery = from n in areasQuery
where n.DateDeleted != null
select n;
}
break;
}
var areas = areasQuery.ToList();
return(areas.ToContracts());
}
public static List <AreaContract> GetAreas(AreaTypesEnum type, RecordTypesEnum recordType)
{
return(CommonDataManager.GetAreas(type, recordType));
}
public static List <AreaContract> GetAreas(AreaTypesEnum type, RecordTypesEnum recordType)
{
return(RpcInvoker.InvokeMethod <List <AreaContract> >(type, recordType));
}
