/// <summary> /// Orders of the selected date /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <returns></returns> public CResult GetOrderdetails(Int64 startTime, Int64 endTime) { CResult tempResult = new CResult(); List<COrderInfoArchive> tempOrderInfoArchive = new List<COrderInfoArchive>(); try { this.OpenConnection(); string sSql = string.Format(SqlQueries.GetQuery(Query.LogRegisterForOrders), startTime,endTime); IDataReader oReader = this.ExecuteReader(sSql); if (oReader != null) { while (oReader.Read()) { COrderInfoArchive orderDetails = new COrderInfoArchive(); orderDetails = ReaderToOrderInfoArchive(oReader, false); ; tempOrderInfoArchive.Add(orderDetails); } oReader.Close(); } tempResult.Data = tempOrderInfoArchive; tempResult.IsSuccess = true; } catch (Exception ex) { tempResult.IsException = true; Console.Write("###" + ex.ToString() + "###"); Logger.Write("Exception : " + ex + " in GetOrderdetails()", LogLevel.Error, "Database"); throw new Exception("Exception occure at GetOrderdetails()", ex); } finally { this.CloseConnection(); } return tempResult; }
//new Added /// <summary> /// /For LogRegister /// </summary> /// <param name="inReader"></param> /// <param name="blnValue"></param> /// <returns></returns> private COrderInfoArchive ReaderToOrderInfoArchive(IDataReader inReader,bool blnValue) { COrderInfoArchive tempOrderInfo = new COrderInfoArchive(); blnValue = true; if (inReader["user_id"] != null) tempOrderInfo.UserID = int.Parse(inReader["user_id"].ToString()); if (inReader["order_type"] != null) tempOrderInfo.OrderType = inReader["order_type"].ToString(); if (inReader["order_time"] != null) //tempOrderInfo.OrderTime = DateTime.Parse(inReader["order_time"].ToString()); tempOrderInfo.OrderTime = new DateTime(Int64.Parse(inReader["order_time"].ToString())); if (inReader["terminal_id"] != null) tempOrderInfo.TerminalID = Int32.Parse(inReader["terminal_id"].ToString()); if (inReader["user_name"] != null) tempOrderInfo.UserName = Convert.ToString(inReader["user_name"].ToString()); return tempOrderInfo; }
//new Added private COrderInfoArchive ReaderToOrderInfoArchive(IDataReader inReader) { COrderInfoArchive tempOrderInfo = new COrderInfoArchive(); if (inReader["order_id"] != null) tempOrderInfo.OrderID = Int64.Parse(inReader["order_id"].ToString()); if (inReader["customer_id"] != null) tempOrderInfo.CustomerID = Int64.Parse(inReader["customer_id"].ToString()); if (inReader["user_id"] != null) tempOrderInfo.UserID = int.Parse(inReader["user_id"].ToString()); if (inReader["status"] != null) tempOrderInfo.Status = inReader["status"].ToString(); if (inReader["order_type"] != null) tempOrderInfo.OrderType = inReader["order_type"].ToString(); if (inReader["order_time"] != null) //tempOrderInfo.OrderTime = DateTime.Parse(inReader["order_time"].ToString()); tempOrderInfo.OrderTime = new DateTime(Int64.Parse(inReader["order_time"].ToString())); if (inReader["guest_count"] != null) tempOrderInfo.GuestCount = int.Parse(inReader["guest_count"].ToString()); if (inReader["table_number"] != null) tempOrderInfo.TableNumber = int.Parse(inReader["table_number"].ToString()); if (inReader["table_name"] != null) tempOrderInfo.TableName = inReader["table_name"].ToString(); if (inReader["serial_no"] != null) tempOrderInfo.SerialNo = Int64.Parse(inReader["serial_no"].ToString()); return tempOrderInfo; }
//new Added public CResult GetOrderInfoArchiveByOrderID(Int64 inOrderID) { CResult tempResult = new CResult(); COrderInfoArchive tempOrderInfoArchive = new COrderInfoArchive(); try { this.OpenConnection(); string sSql = string.Format(SqlQueries.GetQuery(Query.orderInfoArchiveByOrderID), inOrderID); IDataReader oReader = this.ExecuteReader(sSql); if (oReader != null) { while (oReader.Read()) { tempOrderInfoArchive = ReaderToOrderInfoArchive(oReader); } oReader.Close(); } tempResult.Data = tempOrderInfoArchive; tempResult.IsSuccess = true; } catch (Exception ex) { tempResult.IsException = true; Console.Write("###" + ex.ToString() + "###"); Logger.Write("Exception : " + ex + " in GetOrderInfoArchiveByOrderID()", LogLevel.Error, "Database"); throw new Exception("Exception occure at GetOrderInfoArchiveByOrderID()", ex); } finally { this.CloseConnection(); } return tempResult; }
private void OrderDataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { if(OrderDataGridView.Columns[e.ColumnIndex].Name.Equals("Reorder") && e.RowIndex>=0 && OrderDataGridView[0,e.RowIndex].Value!=null) { Int64 oldOrderID = 0; Int64.TryParse(OrderDataGridView["OrderID", e.RowIndex].Value.ToString(), out oldOrderID); COrderManager tempOrderManager = new COrderManager(); COrderInfoArchive tempOrderInfo = new COrderInfoArchive(); List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>(); m_htPreviousOrders = new Hashtable(); CResult oResult = tempOrderManager.OrderInfoArchiveByOrderID(oldOrderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderInfo = (COrderInfoArchive)oResult.Data; } oResult = tempOrderManager.OrderDetailsArchiveByOrderID(oldOrderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderDetailsList = (List<COrderDetails>)oResult.Data; } m_htPreviousOrders.Add("orderinfo", tempOrderInfo); m_htPreviousOrders.Add("orderdetail", tempOrderDetailsList); this.DialogResult = DialogResult.OK; } }