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