public static DataView Run(string query)
{
var customSqlClient = new SqlClient();
customSqlClient.LoadFromRawSql(query);
return customSqlClient.DefaultView;
}
public static DataView GetTreeByItem(int ItemID, int UserID)
{
return(SqlClient.Run(HCMIS.Repository.Queries.Activity.SelectTreeByItem(ItemID, UserID)));
}
public static DataView GetActivitiesForItem(int itemID, int unitID, int userID)
{
return(SqlClient.Run(HCMIS.Repository.Queries.Activity.SelectByItemAndUnit(itemID, unitID, userID)));
}
/// <summary>
/// Gets the account tree.
/// </summary>
/// <param name="userID">The user ID.</param>
/// <returns></returns>
public static DataView GetAccountTree(int userID)
{
var query = HCMIS.Repository.Queries.Activity.SelectGetAccountTree(userID);
return(SqlClient.Run(query));
}
