/// <summary> /// Lists the snap shot. /// </summary> /// <param name="formId">The form id.</param> /// <returns> The datset containing the list of the snapshots.</returns> public static DataSet ListSnapShot(int formId) { Hashtable ht = new Hashtable(); ht.Add("@FormID", formId); return(DataProxy.FetchDataSet("f9051_pclst_Snapshot", ht)); }
/// <summary> /// Used To get the Net_Name for a particular User /// </summary> /// <param name="userFullName">User FullName</param> /// <returns>NetName for a particular fullname</returns> public static DataSet GetUserNetName(string userFullName) { Hashtable ht = new Hashtable(); ht.Add("@UserFullName", userFullName); return(DataProxy.FetchDataSet("f9002_pcget_NetName", ht)); }
/// <summary> /// Gets the query result. /// </summary> /// <param name="sqlQuery">The SQL query.</param> /// <returns>returns dataset</returns> public static DataSet GetSQLQueryResult(string sqlQuery) { Hashtable ht = new Hashtable(); ht.Add("@QueryString", sqlQuery); return(DataProxy.FetchDataSet("f9015_pcexe_Sql", ht)); }
/// <summary> /// Gets the Reports details /// </summary> /// <param name="reportId">The report id.</param> /// <param name="userId">The user id.</param> /// <returns>DataSet With Details Path Of report</returns> public static DataSet GetReportDetails(int reportId, int userId) { Hashtable ht = new Hashtable(); ht.Add("@Report", reportId); ht.Add("@UserID", userId); return(DataProxy.FetchDataSet("f9007_pcget_ReportDetails", ht)); }
/// <summary> /// F36035_s the execute V formula. /// </summary> /// <param name="vformula">The vformula.</param> /// <param name="units">The units.</param> /// <returns></returns> public static DataSet F36035_ExecuteVFormula(string vformula, decimal units) { Hashtable ht = new Hashtable(); ht.Add("@VFormula", vformula); ht.Add("@Units", units); return(DataProxy.FetchDataSet("f36035_pcexe_VFormula", ht)); }
/// <summary> /// Get the result of the snapshot. /// </summary> /// <param name="snapshotId"> The snapshot ID of the snapshot to be exceuted.</param> /// <param name="orderByCondn">The orderBy condition.</param> /// <returns> The datset containing the snapshot results.</returns> public static DataSet GetSnapShotResult(int snapshotId, string orderByCondn) { Hashtable ht = new Hashtable(); ht.Add("@SnapshotID", snapshotId); ht.Add("@OrderByCondn", orderByCondn); return(DataProxy.FetchDataSet("f9051_pcget_Snapshot", ht)); }
/// <summary> /// Lists the query. /// </summary> /// <param name="formId">The form id.</param> /// <param name="userId">The user id.</param> /// <returns>Dataset</returns> public static DataSet ListQuery(int formId, int userId) { Hashtable ht = new Hashtable(); ht.Add("@UserID", userId); ht.Add("@Form", formId); return(DataProxy.FetchDataSet("f9050_pclst_Query", ht)); }
/// <summary> /// Gets the user. /// </summary> /// <param name="userName">Name of the user.</param> /// <param name="applicationId">The application id.</param> /// <returns>The dataset containing the user information.</returns> public static DataSet GetUserInformation(string userName, int applicationId) { Hashtable ht = new Hashtable(); ht.Add("@UserName", userName); ht.Add("@ApplicationID", applicationId); return(DataProxy.FetchDataSet("f9002_pcget_User", ht)); }
/// <summary> /// Gets the snap shot. /// </summary> /// <param name="queryId">The query Id.</param> /// <param name="orderByCondn">The orderBy condition.</param> /// <returns>All Statement Ids</returns> public static DataSet GetQueryResult(int queryId, string orderByCondn) { Hashtable ht = new Hashtable(); ht.Add("@QueryID", queryId); ht.Add("@OrderByCondn", orderByCondn); return(DataProxy.FetchDataSet("f9050_pcget_Query", ht)); }
/// <summary> /// get the Form Permissions depends on the userid. /// </summary> /// <param name="userId">The user id.</param> /// <param name="applicationId">applicationID.</param> /// <returns>MenuItems DataSet</returns> public static DataSet GetFormPermissions(int userId, int applicationId) { Hashtable ht = new Hashtable(); ht.Add("@UserId", userId); ht.Add("@ApplicationID", applicationId); return(DataProxy.FetchDataSet("f9002_pcget_FormPermission", ht)); }
/// <summary> /// Gets the County Configuration /// </summary> /// <param name="applicationId">The application id</param> /// <param name="userId">The User id</param> /// <returns>The dataset containing the County Configuration.</returns> public static DataSet GetCountyConfiguration(int applicationId, int userId) { Hashtable ht = new Hashtable(); ht.Add("@ApplicationID", applicationId); ht.Add("@UserID", userId); return(DataProxy.FetchDataSet("f9020_pclst_Configuration", ht)); }
/// <summary> /// Check For Valid Next Number /// </summary> /// <param name="rollYear">The roll year.</param> /// <param name="nextNum">The next num.</param> /// <param name="formula">The formula.</param> /// <returns>The DataSet containg valid Next Number details</returns> public static DataSet F9013_CheckNextNumber(int rollYear, int nextNum, string formula) { Hashtable ht = new Hashtable(); ht.Add("@RollYear", rollYear); ht.Add("@NextNumber", nextNum); ht.Add("@Formula", formula); return(DataProxy.FetchDataSet("f9013_pcchk_NextNumberConfiguration", ht)); }
/// <summary> /// method to execute query /// </summary> /// <param name="whereCondition"> The condition used to execute query</param> /// <param name="orderByCondition">The order by condition.</param> /// <param name="formId"> The form Id</param> /// <returns>Dataset</returns> public static DataSet ExecuteQuery(string whereCondition, string orderByCondition, int formId) { Hashtable ht = new Hashtable(); ht.Add("@WhereCondnSql", whereCondition); ht.Add("@FormID", formId); ht.Add("@OrderByCondn", orderByCondition); return(DataProxy.FetchDataSet("f9050_pcexe_Query", ht)); }
/// <summary> /// Lists the Sorted query. /// </summary> /// <param name="savedQueryId">The savedquery Id .</param> /// <param name="orderByCondition">The order by condition.</param> /// <param name="formId">The form Id.</param> /// <returns> The dataset containing sorted order of the query result.</returns> public static DataSet ListSortQuery(int savedQueryId, string orderByCondition, int formId) { Hashtable ht = new Hashtable(); ht.Add("@SavedQueryID", savedQueryId); ht.Add("@OrderByCondition", orderByCondition); ht.Add("@FormID", formId); return(DataProxy.FetchDataSet("pclst_SortSavedQuery", ht)); }
/// <summary> /// Lists the Sorted Sanpshot. /// </summary> /// <param name="snapShotId">The snapshot id .</param> /// <param name="orderByCondition">The order by condition.</param> /// <param name="formId">The form Id.</param> /// <returns> The dataset containing sorted order of the snapshot result.</returns> public static DataSet ListSortSnapShot(int snapShotId, string orderByCondition, int formId) { Hashtable ht = new Hashtable(); ht.Add("@SnapShotID", snapShotId); ht.Add("@OrderByCondition", orderByCondition); ht.Add("@FormID", formId); return(DataProxy.FetchDataSet("pclst_SortSnapshot", ht)); }
/// <summary> /// method to execute snapshot /// </summary> /// <param name="snapshotId"> The id used to retrieve snapshotitems to which filter applied</param> /// <param name="whereCondition">wherecondition used to query snapshotitems</param> /// <param name="orderByCondition">The order by condition.</param> /// <param name="formId"> The form Id</param> /// <returns>Dataset</returns> public static DataSet ExecuteSnapshot(int snapshotId, string whereCondition, string orderByCondition, int formId) { Hashtable ht = new Hashtable(); ht.Add("@SnapShotID", snapshotId); ht.Add("@WhereCondn", whereCondition); ht.Add("@FormID", formId); ht.Add("@OrderByCondn", orderByCondition); return(DataProxy.FetchDataSet("f9051_pcexe_Snapshot", ht)); }
/// <summary> /// Saves the Query. /// </summary> /// <param name="savedQueryName">Name of the saved query.</param> /// <param name="formId">The form Id.</param> /// <param name="savedQueryNote">The saved query note.</param> /// <param name="userId">The user Id.</param> /// <param name="savedQueryDate">The saved query date.</param> /// <param name="savedQuery">The saved query.</param> /// <param name="whereCondn">The where condn.</param> /// <param name="canOverride">if set to <c>true</c> [is override].</param> /// <returns>DataSet</returns> public static DataSet SaveQuery(string savedQueryName, int formId, string savedQueryNote, int userId, DateTime savedQueryDate, string savedQuery, string whereCondn, bool canOverride) { Hashtable ht = new Hashtable(); ht.Add("@SavedQueryName", savedQueryName); ht.Add("@FormID", formId); ht.Add("@SavedQueryNote", savedQueryNote); ht.Add("@UserID", userId); ht.Add("@SavedQueryDate", savedQueryDate); ht.Add("@SavedQuery", savedQuery); ht.Add("@WhereCondn", whereCondn); ht.Add("@IsOverride", canOverride); return(DataProxy.FetchDataSet("f9050_pcins_Query", ht)); }
/// <summary> /// Saves the snap shot. /// </summary> /// <param name="snapshotName">Name of the snapshot.</param> /// <param name="formId">The form ID.</param> /// <param name="snapshotNote">The snapshot note.</param> /// <param name="userId">The user ID.</param> /// <param name="snapshotDate">The snapshot date.</param> /// <param name="snapshotQuery">The snapshot query.</param> /// <param name="whereCondn">The where condn.</param> /// <param name="keyIDs">The key I ds.</param> /// <param name="canOverride">if set to <c>true</c> [is override].</param> /// <returns>first column will return true/false </returns> public static DataSet SaveSnapShot(string snapshotName, int formId, string snapshotNote, int userId, DateTime snapshotDate, string snapshotQuery, string whereCondn, string keyIDs, bool canOverride) { Hashtable ht = new Hashtable(); ht.Add("@SnapshotName", snapshotName); ht.Add("@FormID", formId); ht.Add("@SnapshotNote", snapshotNote); ht.Add("@UserID", userId); ht.Add("@SnapshotDate", snapshotDate); ht.Add("@SnapshotQuery", snapshotQuery); ht.Add("@WhereCondn", whereCondn); ht.Add("@KeyIDs", keyIDs); ht.Add("@IsOverride", canOverride); return(DataProxy.FetchDataSet("f9051_pcins_Snapshot", ht)); }
/// <summary> /// Gets the form items. /// </summary> /// <returns>returns dataset</returns> public static DataSet GetFormItems() { return(DataProxy.FetchDataSet("f9002_pclst_Form")); }
/// <summary> /// Gets the state of the authentication. /// </summary> /// <returns>The Dataset</returns> public static DataSet GetAuthenticationState() { return(DataProxy.FetchDataSet("f9001_pcget_GetAuthenticationState")); }
/// <summary> /// Gets the config information. /// </summary> /// <returns>returns Dataset</returns> public static DataSet GetConfigInformation() { return(DataProxy.FetchDataSet("f9001_pcget_ApplicationConfiguration")); }
/// <summary> /// Gets the Mortgage Import statement Id's /// </summary> /// <returns> The dataset containing the list of Mortgage Import statementids.</returns> public static DataSet GetMortgageImportStatementIds() { return(DataProxy.FetchDataSet("pclst_MortgageImportID")); }