/// <summary>
/// Method Will Check the Error Records for given parameters
/// </summary>
/// <param name="importId">importId</param>
/// <param name="templateId">templateId</param>
/// <param name="templateName">templateName</param>
/// <param name="typeId">typeId</param>
/// <param name="filePath">filePath</param>
/// <param name="recieptDate">recieptDate</param>
/// <param name="interestDate">interestDate</param>
/// <param name="payCode">payCode</param>
/// <param name="userId">userId</param>
/// <param name="rollYear">rollYear</param>
/// <param name="ppaymentId">The ppaymentId</param>
/// <returns>
/// the DataSet Containing the Error Records Information
/// </returns>
public static MortageImportData MortgageImportCheckErrors(int importId, int templateId, string templateName, int typeId, string filePath, DateTime recieptDate, DateTime interestDate, bool allowPartialPmts, int userId, int rollYear, int firstHalfpaycode, int ppaymentId)
{
MortageImportData mortageImportData = new MortageImportData();
Hashtable ht = new Hashtable();
ht.Add("@ImportID", importId);
ht.Add("@TemplateID", templateId);
ht.Add("@TemplateName", templateName);
ht.Add("@TypeID", typeId);
ht.Add("@FilePath", filePath);
ht.Add("@ReceiptDate", recieptDate);
ht.Add("@InterestDate", interestDate);
ht.Add("@AllowPartialPmts", allowPartialPmts);
ht.Add("@UserID", userId);
ht.Add("@PayCode", firstHalfpaycode);
if (ppaymentId > 0)
{
ht.Add("@PPaymentID", ppaymentId);
}
ht.Add("@RollYear", rollYear);
string[] optionalParameter = new string[] { mortageImportData.CheckMortgageImportCheckErrors.TableName, mortageImportData.GetMortgageImportError.TableName, mortageImportData.CheckMortgageImportErrorDetails.TableName };
Utility.LoadDataSet(mortageImportData, "f1010_pcchk_MortgageImportCheckErrors", ht, optionalParameter);
return(mortageImportData);
}
/// <summary>
/// Saves the payment.
/// </summary>
/// <param name="importId">The import id.</param>
/// <param name="templateId">The template ID.</param>
/// <param name="templateName">Name of the template.</param>
/// <param name="filePath">The file path.</param>
/// <param name="typeId">The type id.</param>
/// <param name="receiptDate">The receipt date.</param>
/// <param name="interestDate">The interest date.</param>
/// <param name="payCode">The pay code.</param>
/// <param name="userId">The user id.</param>
/// <param name="rollYear">The roll year.</param>
/// <param name="ppaymentId">The ppayment ID.</param>
/// <param name="resetErrorCheck">if set to <c>true</c> [reset error check].</param>
/// <returns>The dataset</returns>
public static MortageImportData CreateReceipt(int importId, int templateId, string templateName, string filePath, int typeId, DateTime receiptDate, DateTime interestDate, bool payCode, int firstHalfPaycode, int userId, int rollYear, int?ppaymentId, bool resetErrorCheck)
{
MortageImportData mortageImportData = new MortageImportData();
Hashtable ht = new Hashtable();
if (importId > 0)
{
ht.Add("@ImportID", importId);
}
ht.Add("@TemplateID", templateId);
ht.Add("@TemplateName", templateName);
ht.Add("@FilePath", filePath);
ht.Add("@TypeID", typeId);
ht.Add("@ReceiptDate", receiptDate);
ht.Add("@InterestDate", interestDate);
ht.Add("@AllowPartialPmts", payCode);
ht.Add("@PayCode", firstHalfPaycode);
ht.Add("@UserID", userId);
ht.Add("@RollYear", rollYear);
if (ppaymentId > 0)
{
ht.Add("@PPaymentID", ppaymentId);
}
else
{
ht.Add("@PPaymentID", 0);
}
ht.Add("@ResetErrorCheck", resetErrorCheck);
string[] optionalParameter = new string[] { mortageImportData.CreateRecieptError.TableName, mortageImportData.CreateRecieptDetails.TableName };
Utility.LoadDataSet(mortageImportData, "f1010_pcins_MortgageImportReceipt", ht, optionalParameter);
return(mortageImportData);
}
/// <summary>
/// Saves Mortgage Import
/// </summary>
/// <param name="importId">The import id</param>
/// <param name="templateId">The template id</param>
/// <param name="templateName">The template name</param>
/// <param name="typeId">The type id</param>
/// <param name="filePath">The file path</param>
/// <param name="receiptDate">The receipt date</param>
/// <param name="interestDate">The interest date</param>
/// <param name="payCode">The pay code</param>
/// <param name="userId">The user id</param>
/// <param name="rollYear">The roll year</param>
/// <param name="ppaymentId">The ppaymentId</param>
/// <param name="resetErrorCheck">resetErrorCheck</param>
/// <returns>The DataSet containg inserted entries import id</returns>
public static MortageImportData SaveMortgageImport(int importId, int templateId, string templateName, int typeId, string filePath, DateTime receiptDate, DateTime interestDate, bool payCode, int userId, int rollYear, int ppaymentId, int firstHalfPayCode, bool resetErrorCheck)
{
MortageImportData mortageImportData = new MortageImportData();
Hashtable ht = new Hashtable();
if (importId > 0)
{
ht.Add("@ImportID", importId);
}
ht.Add("@TemplateID", templateId);
ht.Add("@TemplateName", templateName);
ht.Add("@TypeID", typeId);
ht.Add("@FilePath", filePath);
ht.Add("@ReceiptDate", receiptDate);
ht.Add("@InterestDate", interestDate);
ht.Add("@AllowPartialPmts", payCode);
ht.Add("@UserID", userId);
ht.Add("@RollYear", rollYear);
ht.Add("@PayCode", firstHalfPayCode);
if (ppaymentId > 0)
{
ht.Add("@PPaymentID", ppaymentId);
}
ht.Add("@ResetErrorCheck", resetErrorCheck);
Utility.LoadDataSet(mortageImportData.SaveMortgageImport, "f1010_pcins_MortgageImport", ht);
return(mortageImportData);
}
/// <summary>
/// Lists the type of the mortgage import file.
/// </summary>
/// <returns>The dataset containing the Mortgage Import FileType</returns>
public static MortageImportData ListMortgageImportFileType()
{
MortageImportData mortageImportData = new MortageImportData();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(mortageImportData.ListMortgageImportFileType, "f1010_pclst_MortgageImportFileType", ht);
return(mortageImportData);
}
/// <summary>
/// Delete Mortgage import file entries
/// </summary>
/// <param name="importId">The import id</param>
/// <param name="userId">userId</param>
/// <returns>The DataSet</returns>
public static MortageImportData DeleteMortgageImportFileEntries(int importId, int userId)
{
MortageImportData mortageImportData = new MortageImportData();
Hashtable ht = new Hashtable();
ht.Add("@ImportID", importId);
ht.Add("@UserID", userId);
Utility.LoadDataSet(mortageImportData.DeleteMortgageImportEntry, "f1010_pcdel_MortgageImportEntry", ht);
return(mortageImportData);
}
/// <summary>
/// Check For Valid Receipt
/// </summary>
/// <param name="importId">The import id</param>
/// <param name="receiptDate">The receipt date</param>
/// <returns>The DataSet containg valid receipt details</returns>
public static MortageImportData CheckMortgageImportValidReceipt(int importId, DateTime receiptDate)
{
MortageImportData mortageImportData = new MortageImportData();
Hashtable ht = new Hashtable();
ht.Add("@ImportID", importId);
ht.Add("@ReceiptDate", receiptDate);
Utility.LoadDataSet(mortageImportData.CheckMortgageImportValidReceiptTest, "f1010_pcchk_MortgageImportValidReceiptTest", ht);
return(mortageImportData);
}
/// <summary>
/// Gets the Mortgage Import statement based on the import id
/// </summary>
/// <param name="importId"> The importId of the statement to be fetched.</param>
/// <param name="nextAvailableRecord">true fetch next available record if current record deleted,false previoud record</param>
/// <returns> The dataset containing the statement information of the importId.</returns>
public static MortageImportData GetMortgageImportStatement(int importId, bool nextAvailableRecord)
{
MortageImportData mortageImportData = new MortageImportData();
Hashtable ht = new Hashtable();
if (importId > 0)
{
ht.Add("@ImportID", importId);
}
ht.Add("@MoveNext", nextAvailableRecord);
string[] optionalParameter = new string[] { mortageImportData.GetMortgageImportIds.TableName, mortageImportData.GetMortgageImportDetails.TableName, mortageImportData.GetMortgageImportError.TableName, mortageImportData.PayListTable.TableName };
Utility.LoadDataSet(mortageImportData, "f1010_pcget_MortgageImport", ht, optionalParameter);
return(mortageImportData);
}
