/// <summary>
/// Save the comment entered by the userid.
/// </summary>
/// <param name="commentId">The comment id.</param>
/// <param name="formId">The form id.</param>
/// <param name="keyId">The key id.</param>
/// <param name="commentDate">The comment date.</param>
/// <param name="userId">The user id.</param>
/// <param name="comments">The comment to be saved.</param>
/// <param name="printOnReceipt">The print on receipt.</param>
/// <param name="publicComment">The public comment.</param>
/// <param name="ispriority">The ispriority.</param>
/// <param name="isroll">The isroll.</param>
/// <param name="CommentPriorityId">The Comment PriorityId</param>
public static void SaveComments(int commentId, int formId, int keyId, DateTime commentDate, int userId, string comments, int printOnReceipt, int publicComment, int ispriority, int isroll, int commentPriorityId)
{
Hashtable ht = new Hashtable();
if (commentId == 0)
{
ht.Add("@CommentID", DBNull.Value);
}
else
{
ht.Add("@CommentID", commentId);
}
ht.Add("@Form", formId);
ht.Add("@KeyID", keyId);
ht.Add("@CommentDate", commentDate);
ht.Add("@UserID", userId);
ht.Add("@Comment", comments);
ht.Add("@IsPublic", publicComment);
ht.Add("@IsPrint", printOnReceipt);
ht.Add("@IsHighPriority", ispriority);
ht.Add("@IsRoll", isroll);
ht.Add("@CommentPriorityID", commentPriorityId);
DataProxy.ExecuteSP("f9075_pcins_Comment", ht);
}
/// <summary>
/// Clears the temporary records.
/// </summary>
/// <param name="userId">The user id.</param>
public static void ClearTemporaryRecords(int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f1200_pcdel_PostingTempRecords", ht);
}
/// <summary>
/// To Delete MID in Misc Improvements OverView.
/// </summary>
/// <param name="miscId">The misc id.</param>
/// <param name="userId">userId</param>
public static void F36011_DeleteMICode(int miscId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@MID", miscId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f36011_pcdel_MI_Catalog", ht);
}
/// <summary>
/// F9015_s the delete query.
/// </summary>
/// <param name="sqlId">The SQL id.</param>
/// <param name="userId">userId</param>
/// <returns>The integer Value</returns>
public static int F9015_DeleteQuery(int sqlId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@SQLID", sqlId);
ht.Add("@UserID", userId);
return(DataProxy.ExecuteSP("f9015_pcdel_Sql", ht));
}
/// <summary>
/// F28210_s the execute check for errors.
/// </summary>
/// <param name="importId">The import id.</param>
/// <param name="userId">The user id.</param>
public static void F28510_ExecuteCheckForErrors(int importId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@ImportID", importId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f23510_pcexe_SnapshotImportErrorCheck", ht);
}
/// <summary>
/// F1557_s the delete Payment.
/// </summary>
/// <param name="PaymentIDs">The PaymentIDs id.</param>
/// <param name="userId">The user id.</param>
public static void F1557_DeletePaymentIds(string PaymentIDs, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@PaymentIDs", PaymentIDs);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f1557_pcdel_PaymentManagement", ht);
}
/// <summary>
/// F1203_s the save due date management.
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="dueDateXML">The due date XML.</param>
public static void F1203_SaveDueDateManagement(int userId, string dueDateXML)
{
Hashtable ht = new Hashtable();
ht.Add("@UserID", userId);
ht.Add("@PostTypeData", dueDateXML);
DataProxy.ExecuteSP("f1203_pcins_PostTypeDueDate", ht);
}
/// <summary>
/// Deletes the Material Item
/// </summary>
/// <param name="materialId">The material id.</param>
/// <param name="userId">userId</param>
/// <returns>The return value specifying status of the delete action.</returns>
public static int F8044_DeleteMaterialItem(int materialId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@MaterialID", materialId);
ht.Add("@UserID", userId);
return(DataProxy.ExecuteSP("f8044_pcdel_Materials", ht));
}
/// <summary>
/// F16071_s the deletejournal header details.
/// </summary>
/// <param name="templateId">The template id.</param>
/// <param name="userId">The user id.</param>
public static void F16071_DeleteJournalHeaderDetails(int templateId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@TemplateID", templateId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f11071_pcdel_JETemplate", ht);
}
/// <summary>
/// F35085_s the deletetemplate details.
/// </summary>
/// <param name="importId">The import id.</param>
/// <param name="userId">The user id.</param>
public static void F35085_DeletetemplateDetails(int importId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@ImportID", importId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f35080_pcdel_CAImport", ht);
}
/// <summary>
/// F35085_s the execute check for errors.
/// </summary>
/// <param name="importId">The import id.</param>
/// <param name="userId">The user id.</param>
public static void F35085_ExecuteCheckForErrors(int importId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@ImportID", importId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f35085_pcexe_CAImportErrorCheck", ht);
}
/// <summary>
/// F29636_s the delete BOE details.
/// </summary>
/// <param name="boeId">The boe id.</param>
/// <param name="userId">The user id.</param>
public static void F29636_DeleteBOEDetails(int boeId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@BOEID", boeId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f29636_pcdel_BOE_NE", ht);
}
/// <summary>
/// Deletes the District Assessment
/// </summary>
/// <param name="statementId">The statement id.</param>
/// <param name="userId">The userId.</param>
/// <returns>The return value specifying status of the delete action.</returns>
public static int F1031_DeleteDistrictAssessment(int statementId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@StatementID", statementId);
ht.Add("@UserID", userId);
return(DataProxy.ExecuteSP("f1031_pcdel_DistrictAssessment", ht));
}
/// <summary>
/// Deletes the excise tax rate.
/// </summary>
/// <param name="detailId">The detail id.</param>
/// <param name="userId">userId</param>
/// <returns>The return value specifying status of the delete action.</returns>
public static int DeleteEventEngineTVDetails(int detailId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@DetailID", detailId);
ht.Add("@UserID", userId);
return(DataProxy.ExecuteSP("f8104_pcdel_FSSanPipeInspectionDetails", ht));
}
/// <summary>
/// Deletes the attachments.
/// </summary>
/// <param name="fileId">The file id.</param>
/// <param name="userId">The userId.</param>
public static void DeleteAttachments(int fileId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@FileID", fileId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f9005_pcdel_Attachment", ht);
}
/// <summary>
/// F29531_s the delete association link.
/// </summary>
/// <param name="associationId">The association id.</param>
/// <param name="userId">The user id.</param>
public static void F29531_DeleteAssociationLink(int associationId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@AssociationID", associationId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f29531_pcdel_AssociationLink", ht);
}
/// <summary>
/// Updates the association link details.
/// </summary>
/// <param name="associationDetails">The association details.</param>
/// <param name="userId">The user id.</param>
/// <returns></returns>
public static void UpdateAssociationLinkDetails(string associationDetails, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@AssociationXML", associationDetails);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f29531_pcupd_AssociationLink", ht);
}
/// <summary>
/// Deletes the snap snot.
/// </summary>
/// <param name="snapShotId">The snap shot id.</param>
/// <param name="userId">userId</param>
public static void DeleteSnapSnot(int snapShotId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@SnapshotID", snapShotId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f9051_pcdel_Snapshot", ht);
}
/// <summary>
/// F36091_s the delete income approach.
/// </summary>
/// <param name="cropId">The income Ids.</param>
/// <param name="userId">The user id.</param>
public static void F36091_DeleteIncomeSource(string incomeIds, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@IncomeApproachItemIDs", incomeIds);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f31091_pcdel_IncomeApproachItem", ht);
}
/// <summary>
/// F1025_s the delete auto fund transfer details.
/// </summary>
/// <param name="autoTransferId">The auto transfer ID.</param>
/// <param name="userId">The userId.</param>
/// <returns>integer value</returns>
public static int F1025_DeleteAutoFundTransferDetails(int autoTransferId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@AutoTransferID", autoTransferId);
ht.Add("@UserID", userId);
return(DataProxy.ExecuteSP("f1025_pcdel_AutoFund", ht));
}
/// <summary>
/// F9075_DeleteCommentIds the delete comment.
/// </summary>
/// <param name="commentId">The comment id.</param>
/// <param name="userId">The user id.</param>
public static void F9075_DeleteCommentIds(string commentIds, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@CommentIDs", commentIds);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f9075_pcdel_MassCommentDelete", ht);
}
/// <summary>
/// F36041_s the delete crop.
/// </summary>
/// <param name="cropId">The crop id.</param>
/// <param name="userId">The user id.</param>
public static void F36041_DeleteCropIds(string cropIds, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@CropIDs", cropIds);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f36041_pcdel_Crop", ht);
}
/// <summary>
/// F35080_s the delete owner details.
/// </summary>
/// <param name="centralId">The central id.</param>
/// <param name="userId">The user id.</param>
/// <returns></returns>
public static void F35080_DeleteOwnerDetails(int centralId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@CentralID", centralId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f35080_pcdel_CentrallyAssessedOwner", ht);
}
/// <summary>
/// Reverses the GL post.
/// </summary>
/// <param name="postId">The post id.</param>
/// <param name="userId">The user id.</param>
public static void InsertReverseGLPost(int postId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@PostID", postId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f1202_pcins_ReverseGLPost", ht);
}
/// <summary>
/// Deletes the query utility.
/// </summary>
/// <param name="queryId">The query id.</param>
/// <param name="userId">userId</param>
public static void DeleteQueryUtility(int queryId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@QueryID", queryId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f9050_pcdel_Query", ht);
}
/// <summary>
/// To delete Depreciation Tables.
/// </summary>
/// <param name="deprTableId">The depr table id.</param>
/// <param name="userId">The user id.</param>
public static void F36060_DeleteDepreciationTables(int deprTableId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@DeprTableID", deprTableId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f36060_pcdel_DepreciationTable", ht);
}
/// <summary>
/// F28210_s the delete Snapshot Import details.
/// </summary>
/// <param name="importId">The import id.</param>
/// <param name="userId">The user id.</param>
public static void F28510_DeleteSnapshotImportDetails(int importId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@ImportID", importId);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f23510_pcdel_SnapshotImport", ht);
}
/// <summary>
/// Inserts the account.
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="errorTypeId">The error type id.</param>
public static void InsertAccount(int userId, int errorTypeId)
{
Hashtable ht = new Hashtable();
ht.Add("@UserID", userId);
ht.Add("@ErrorTypeID", errorTypeId);
DataProxy.ExecuteSP("f1206_pcins_PostingErrorAccount", ht);
}
/// <summary>
/// Deletes the Inspection Item
/// </summary>
/// <param name="inspectionId">The inspection id.</param>
/// <param name="userId">userId</param>
/// <returns>The return value specifying status of the delete action.</returns>
public static int F8056_DeleteInspectionDetails(int inspectionId, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@InspectionID", inspectionId);
ht.Add("@UserID", userId);
return(DataProxy.ExecuteSP("f8056_pcdel_FS_EventTypeInspection", ht));
}
/// <summary>
/// To Delete LandDetails.
/// </summary>
/// <param name="luid">The lUID.</param>
/// <param name="userId">userId</param>
public static void F36035_DeleteLandDetails(int luid, int userId)
{
Hashtable ht = new Hashtable();
ht.Add("@LUID", luid);
ht.Add("@UserID", userId);
DataProxy.ExecuteSP("f36035_pcdel_LandValuesSlice", ht);
}