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); }