/// <summary> /// /// </summary> /// <returns></returns> public OperationCategoryCollection GetAllOperationCategories() { try { OperationCategoryCollection collection = new OperationCategoryCollection(); collection.Clear(); using (IDataReader dr = Database.ExecuteReader("UspGetAllOperationCategories", CommandType.StoredProcedure)) { while (dr.Read()) { OperationCategory category = Populate(dr); collection.Add(category); } } return(collection); } catch (Exception ex) { throw ex; } }
private void LoadOperations(string resourceTypeCode) { try { OperationCategoryManager opCatMan = new OperationCategoryManager(); OperationCategoryCollection opCats = opCatMan.GetAllOperationCategories(); OperationManager opMan = new OperationManager(); OperationCollection ops = opMan.FindOperationsByResourceType(resourceTypeCode); cbxListOperations.Items.Clear(); foreach (OperationCategory opCat in opCats) { ListItem cbxOperation = new ListItem(opCat.Name, opCat.OperationCode.ToString()); foreach (Operation op in ops) { if (op.OperationCode == opCat.OperationCode) { cbxOperation.Selected = true; } } cbxListOperations.Items.Add(cbxOperation); } } catch (Exception ex) { ucErrorBox.Message = ex.Message; CurrentFormState = FormState.ErrorState; this.SaveErrorLog(ex); } }
public OperationCategoryCollection GetOperationCategoriesByResourceTypeCode(string ResourceTypeCode) { try { OperationCategoryCollection collection = new OperationCategoryCollection(); // create sql parameters SqlParameter prmResourceTypeCode = new SqlParameter("@ResourceTypeCode", SqlDbType.VarChar, 10); prmResourceTypeCode.Direction = ParameterDirection.Input; prmResourceTypeCode.Value = ResourceTypeCode; using (IDataReader dr = Database.ExecuteReader("UspGetOperationCatByResourceType", CommandType.StoredProcedure, prmResourceTypeCode)) { while (dr.Read()) { OperationCategory operationCat = Populate(dr); collection.Add(operationCat); } } return(collection); } catch (Exception ex) { throw ex; } }
private void LoadOperationCatList() { OperationCategoryCollection operationCats = new OperationCategoryCollection(); OperationCategoryManager operationManager = new OperationCategoryManager(); operationCats = operationManager.GetAllOperationCategories(); dgridOperationCatList.DataSource = operationCats; dgridOperationCatList.DataBind(); if (dgridOperationCatList.Rows.Count <= 0) { uctErrorBox.Visible = true; uctErrorBox.Message = "Không có dữ liệu"; } }