/// <summary>
/// Returns a datatable with the following column layout.
/// (GRV,AccountName,ID,PrintedDate, IsVoid)
/// </summary>
/// <param name="IDPrinted"></param>
/// <returns></returns>
public static DataTable GetListOfGRVPrinted(int idPrinted)
{
var query = HCMIS.Repository.Queries.ReceiptConfirmationPrintout.SelectGetListOfGRVPrinted(idPrinted);
var receiptConfirmationPrintout = new ReceiptConfirmationPrintout();
receiptConfirmationPrintout.LoadFromRawSql(query);
return receiptConfirmationPrintout.DefaultView.Table;
}
/// <summary>
/// Returns a datatable with the following column layout.
/// (GRV,AccountName,ID,PrintedDate, IsVoid)
/// </summary>
/// <param name="IDPrinted"></param>
/// <returns></returns>
public static DataTable GetListOfSRMPrinted(int idPrinted)
{
var query = HCMIS.Repository.Queries.ReceiptConfirmationPrintout.SelectGetListOfSRMPrinted(idPrinted);
var receiptConfirmationPrintout = new ReceiptConfirmationPrintout();
receiptConfirmationPrintout.LoadFromRawSql(query);
return(receiptConfirmationPrintout.DefaultView.Table);
}
/// <summary>
/// Gets the GRNF no.
/// </summary>
/// <param name="ReceiptID">The receipt ID.</param>
/// <returns></returns>
public static int GetGRNFNo(int ReceiptID)
{
BLL.ReceiptConfirmationPrintout rc = new ReceiptConfirmationPrintout();
var query = HCMIS.Repository.Queries.ReceiptConfirmationPrintout.SelectGetGRNFNo(ReceiptID);
rc.LoadFromRawSql(query);
int printedID;
try
{
printedID = int.Parse(rc.GetColumn("IDPrinted").ToString());
}
catch
{
printedID = 0;
}
return printedID;
}
/// <summary>
/// Gets the GRNF no.
/// </summary>
/// <param name="ReceiptID">The receipt ID.</param>
/// <returns></returns>
public static int GetGRNFNo(int ReceiptID)
{
BLL.ReceiptConfirmationPrintout rc = new ReceiptConfirmationPrintout();
var query = HCMIS.Repository.Queries.ReceiptConfirmationPrintout.SelectGetGRNFNo(ReceiptID);
rc.LoadFromRawSql(query);
int printedID;
try
{
printedID = int.Parse(rc.GetColumn("IDPrinted").ToString());
}
catch
{
printedID = 0;
}
return(printedID);
}