/// <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";
}
}
