/// <summary>
/// Collecting the log record of the order
/// </summary>
/// <param name="p_orderID"></param>
/// <returns></returns>
public CResult GetOrderLogInformation(Int64 p_orderID)
{
try
{
OrderLogInformation tempOrderLogInfo = new OrderLogInformation();
m_oResult= Database.Instance.OrderInfo.GetOrderLogInformation(p_orderID);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Read Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at GetOrderLogInformation() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in GetOrderLogInformation()", LogLevel.Error, "CCustomerManager");
}
return m_oResult;
}
private OrderLogInformation ConvertLogInfo(IDataReader oReader, Int64 orderID)
{
OrderLogInformation tempOrderLogInfo = new OrderLogInformation();
tempOrderLogInfo.OrderID = orderID;
tempOrderLogInfo.FirstOrderTakenTime = Convert.ToInt64("0" + oReader["item_order_time"]);
tempOrderLogInfo.FirstOrderPrintTime = Convert.ToInt64("0" + oReader["send_kitchen_time"]);
tempOrderLogInfo.UserName = Convert.ToString(oReader["user_name"]);
tempOrderLogInfo.BillPrintStatus = Convert.ToInt32("0" + oReader["guest_bill_print_status"]);
tempOrderLogInfo.UserID = Convert.ToInt32("0" + oReader["user_id"]);
return tempOrderLogInfo;
}
CResult IOrderInfoDAO.GetOrderLogInformation(long orderID)
{
CResult objResult = new CResult();
List<OrderLogInformation> tempOrderLogInfoList = new List<OrderLogInformation>();
int counter = 0;
try
{
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.GetOrderLogInformation), orderID);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
OrderLogInformation tempObject = new OrderLogInformation();
tempObject = ConvertLogInfo(oReader, orderID);
tempOrderLogInfoList.Add(tempObject);
counter++;
}
objResult.Data = tempOrderLogInfoList;
}
}
catch (Exception ex)
{
Console.Write("###" + ex.ToString() + "###");
Logger.Write("Exception : " + ex + " in GetOrderLogInformation()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at GetOrderLogInformation()", ex);
}
else
{
throw new Exception("Exception occure at GetOrderLogInformation()", ex);
}
}
finally
{
this.CloseConnection();
}
return objResult;
}
/// <summary>
///
/// </summary>
/// <param name="oReader"></param>
/// <returns></returns>
private OrderLogInformation ConvertKitchenTextInfo(IDataReader oReader)
{
OrderLogInformation tempOrderLogInfo = new OrderLogInformation();
tempOrderLogInfo.KitchenText = Convert.ToString(oReader["kitchen_text"]);
tempOrderLogInfo.KitchenTextPrintStatus = Convert.ToInt32("0" + oReader["print_status"]);
return tempOrderLogInfo;
}