public A_Area GetArea(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
A_Area entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_A_Area_Repository_GetArea, parms)) {
if (rdr.Read())
{
entity = new A_Area();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new Kv <int, string>()
{
Key = SqlTypeConverter.DBNullInt32Handler(rdr["NodeLevel"]), Value = ""
};
entity.ParentId = SqlTypeConverter.DBNullStringHandler(rdr["ParentId"]);
entity.Vendor = SqlTypeConverter.DBNullStringHandler(rdr["Vendor"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
private void GetParents(List <A_Area> areas, List <A_Area> parents, A_Area area)
{
var parent = areas.Find(a => a.Id == area.ParentId);
if (parent != null)
{
GetParents(areas, parents, parent);
if (!parents.Contains(parent))
{
parents.Add(parent);
}
}
}
public List <A_Area> GetAreas()
{
var entities = new List <A_Area>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_A_Area_Repository_GetAreas, null)) {
while (rdr.Read())
{
var entity = new A_Area();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new Kv <int, string>()
{
Key = SqlTypeConverter.DBNullInt32Handler(rdr["NodeLevel"]), Value = ""
};
entity.ParentId = SqlTypeConverter.DBNullStringHandler(rdr["ParentId"]);
entity.Vendor = SqlTypeConverter.DBNullStringHandler(rdr["Vendor"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
