public static IEnumerable<SysAreaMansion> LoadCompanyMansions(int companyId)
{
var query = DB.Select(Utilities.GetTableColumns(SysAreaMansion.Schema)).From<SysAreaMansion>( )
.InnerJoin(SysCompanyMansion.MansionIDColumn, SysAreaMansion.IdColumn)
.Where(SysCompanyMansion.CompanyIDColumn).IsEqualTo(companyId);
using (var rdr = query.ExecuteReader( ))
{
while (rdr.Read( ))
{
SysAreaMansion companyMansion = new SysAreaMansion( );
companyMansion.Load(rdr);
yield return companyMansion;
}
}
}
public static SysAreaMansion GetAreaMansion(string areaName, string mansionName)
{
var areaDict = AreaBLL.AreaNameMapping;
if (!areaDict.ContainsKey(areaName))
return null;
var area = areaDict[areaName];
var query = DB.Select( ).Top("1").From<SysAreaMansion>( )
.Where(SysAreaMansion.AreaIDColumn).IsEqualTo(area.Id)
.And(SysAreaMansion.NameColumn).IsEqualTo(mansionName);
SysAreaMansion mansion = null;
using (var dr = query.ExecuteReader( ))
{
if (dr.Read( ))
{
mansion = new SysAreaMansion( );
mansion.Load(dr);
}
}
if (mansion == null)
{
mansion = new SysAreaMansion
{
AreaID = area.Id,
Name = mansionName,
Address = null,
Code = null,
AreaDepth = area.Depth,
};
mansion.Save( );
}
return mansion;
}
public static IEnumerable<SysAreaMansion> LoadAreaMansions( )
{
var rdr = DB.Select( ).From<SysAreaMansion>( ).ExecuteReader( );
using (rdr)
{
while (rdr.Read( ))
{
SysAreaMansion mansion = new SysAreaMansion( );
mansion.Load(rdr);
yield return mansion;
}
}
}
