/// <summary>
/// Get the permission for a specific UserID on a specific TaskID ON A SPECIFIC UserOrganizationID
/// </summary>
/// <param name="userID"></param>
/// <param name="taskID"></param>
/// <param name="userOrganizationID"></param>
/// <returns></returns>
public static bool GetUserEditable(int userID, GlobalEnum.TaskID taskID, int userOrganizationID)
{
//Need to check the lasted version
//Set lRec = ADORECNEW(): Call lRec.Open("SELECT MAX(VersionID) AS VersionID FROM VersionMaster ", ClassConn)
//If Not lRec.BOF And Not lRec.EOF Then
// If lNMVNVersionID <> lRec.Fields("VersionID") Then
// MsgBox "The program ERmgr on this computer is not the lasted version." & Chr(13) & "Please contact your admin for more information. Thank you!", vbExclamation + vbDefaultButton1, "ERmgr"
// End
// End If
//End If
SqlParameter[] sqlParameter = new SqlParameter[3];
sqlParameter[0] = new SqlParameter("UserID", userID); sqlParameter[0].SqlDbType = SqlDbType.Int; sqlParameter[0].Direction = ParameterDirection.Input;
sqlParameter[1] = new SqlParameter("TaskID", (int)taskID); sqlParameter[1].SqlDbType = SqlDbType.Int; sqlParameter[1].Direction = ParameterDirection.Input;
sqlParameter[2] = new SqlParameter("UserOrganizationID", userOrganizationID); sqlParameter[0].SqlDbType = SqlDbType.Int; sqlParameter[0].Direction = ParameterDirection.Input;
int aclEditable = SQLDatabase.GetScalarValue("SPUserACLEditable", CommandType.StoredProcedure, sqlParameter);
return((ACLLevel)aclEditable == ACLLevel.ACLEditable);
}
public static int GetScalarValue(string queryString)
{
return(SQLDatabase.GetScalarValue(queryString, CommandType.Text, null));
}