예제 #1
0
        public static Bill GetBill(string dinningId)
        {
            using (SqlConnection conn = Utilities.GetConnection())
            {
                SqlCommand comm = new SqlCommand(@"select Bill.Id,DinningTable.TableId, TotalMoney, BillTime, Note, Name
                                                                                 from DinningTable, Bill, BillType
                                                                                 where DinningTable.Id = @dinningId
                                                                                            and Bill.TypeId = BillType.Id", conn);
                comm.Parameters.Add("@dinningId", SqlDbType.Char, 10);
                comm.Parameters["@dinningId"].Value = dinningId;
                try
                {
                    conn.Open();

                    SqlDataReader reader = comm.ExecuteReader();

                    if (reader.Read())
                    {
                        List<string> cardId = new List<string>();
                        cardId.Add(reader["TableId"].ToString());
                        BillingInfo info = new BillingInfo();
                        return convertToBill(reader["Id"].ToString(), dinningId, reader.GetDateTime(3),reader["Note"].ToString(),reader.GetDecimal(2), info);
                    }
                    else
                    {
                        throw new HCSMSException("No Type Found");
                    }
                }
                catch (SqlException sqlException)
                {
                    throw new HCSMSException(sqlException.Message);
                }
                finally
                {
                    if (conn != null)
                    {
                        conn.Close();
                    }
                }
            }
        }
예제 #2
0
        private static Bill convertToBill(string Id, string dinningId, DateTime billTime,string note, decimal totalMoney, BillingInfo billInfo)
        {
            Bill bill = new Bill();

            bill.BillingInfo.Add(billInfo);
            bill.BillingTable.Id = dinningId;
            bill.BillTime = billTime;
            bill.Id = Id;
            bill.Note = note;
            bill.TotalMoney = totalMoney;

            return bill;
        }
예제 #3
0
 public void PayBill( Bill aBill, BillingInfo billingInfo)
 {
     throw new NotImplementedException();
 }