public List <VD_AREAS> getListAreas() { List <VD_AREAS> lstAreas = new List <VD_AREAS>(); _DBAccess = new DBController(); DataSet ds = new DataSet(); ds = _DBAccess.GetEntityList("WEB_VD_GETLIST_AREAS"); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { lstAreas.Add(new VD_AREAS { ID = Convert.ToInt64(row["ID"]), Name = Convert.ToString(row["Name"]), Descriptions = Convert.ToString(row["Descriptions"]), Quantity = Convert.ToInt32(row["Quantity"]), PersonRegister = _DBAccess.countPersonOnAreas("WEB_VD_COUNT_PERSON_AREAS", Convert.ToInt64(row["ID"])), IsActive = Convert.ToBoolean(row["IsActive"]), zIndex = Convert.ToInt32(row["zIndex"]) }); } } } return(lstAreas); }
public VD_AREAS getDetailsAreas(string AreasID) { VD_AREAS areas = new VD_AREAS(); _DBAccess = new DBController(); DataSet ds = new DataSet(); ds = _DBAccess.GetEntityDetails("WEB_VD_GET_DETAILS_AREAS", AreasID); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { areas.ID = Convert.ToInt64(ds.Tables[0].Rows[0]["ID"]); areas.Name = Convert.ToString(ds.Tables[0].Rows[0]["Name"]); areas.Descriptions = Convert.ToString(ds.Tables[0].Rows[0]["Descriptions"]); areas.Quantity = Convert.ToInt32(ds.Tables[0].Rows[0]["Quantity"]); areas.PersonRegister = _DBAccess.countPersonOnAreas("WEB_VD_COUNT_PERSON_AREAS", Convert.ToInt64(ds.Tables[0].Rows[0]["ID"])); areas.IsActive = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsActive"]); areas.zIndex = Convert.ToInt32(ds.Tables[0].Rows[0]["zIndex"]); } } return(areas); }