private static int GetPOSLastReceiptNo()
{
object lcResult;
EServiceQueryClass lcQuery;
lcQuery = new EServiceQueryClass(EServiceQueryClass.QueryType.GetPOSLastReceiptNo);
if ((lcResult = lcQuery.Query.GetResult()) != null)
{
return(Convert.ToInt32(lcResult));
}
else
{
return(0);
}
}
private static POSStakeHolderRow GetPOSStakeHolderRow(String paCodeNo)
{
DataTable lcDataTable;
EServiceQueryClass lcQuery;
lcQuery = new EServiceQueryClass(EServiceQueryClass.QueryType.GetPOSStakeHolderRowByCodeNo);
lcQuery.Query.ReplacePlaceHolder("$CODENO", paCodeNo.ToString(), false);
if (((lcDataTable = lcQuery.Query.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new POSStakeHolderRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
private static int GetPOSLastReceiptNo(ReceiptType paReceiptType)
{
object lcResult;
EServiceQueryClass lcQuery;
lcQuery = new EServiceQueryClass(EServiceQueryClass.QueryType.GetPOSLastReceiptNo);
lcQuery.Query.ReplacePlaceHolder("$RECEIPTTYPE", paReceiptType.ToString(), true);
if ((lcResult = lcQuery.Query.GetResult()) != null)
{
return(Convert.ToInt32(lcResult));
}
else
{
return(0);
}
}
private static POSStakeHolderRow GetPOSStakeHolderRow(int paStakeHolderID)
{
DataTable lcDataTable;
EServiceQueryClass lcQuery;
lcQuery = new EServiceQueryClass(EServiceQueryClass.QueryType.GetPOSStakeHolderRowByStakeHolderID);
lcQuery.Query.ReplacePlaceHolder("$STAKEHOLDERID", paStakeHolderID.ToString(), false);
if (((lcDataTable = lcQuery.Query.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new POSStakeHolderRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
private static POSReceiptRow GetPOSReceiptRow(int paReceiptID)
{
DataTable lcDataTable;
EServiceQueryClass lcQuery;
lcQuery = new EServiceQueryClass(EServiceQueryClass.QueryType.GetPOSReceiptRow);
lcQuery.Query.ReplacePlaceHolder("$RECEIPTID", paReceiptID.ToString(), false);
if (((lcDataTable = lcQuery.Query.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new POSReceiptRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}