public List <MenuCategoryData> GetMenuData(int sTableNumber, int eTableNumber) { List <MenuCategoryData> menuData = new List <MenuCategoryData>(); for (int i = 1; i < 45; i++) { int totalPrice = 0; int totalCount = 0; MenuCategoryData buffer = new MenuCategoryData(); MySqlDataReader reader = connection.GetDBData("select idxMenu, count, totalPrice, salePrice, eatTable from orders" + " where idxMenu = " + i + " and eatTable >= " + sTableNumber + " and eatTable <= " + eTableNumber + ";"); while (reader.Read()) { int count = Int32.Parse(reader["count"].ToString()); totalCount += count; totalPrice += (Int32.Parse(reader["totalPrice"].ToString()) * count + Int32.Parse(reader["salePrice"].ToString()) * count); } buffer.count = totalCount; buffer.sumProfits = totalPrice; reader = connection.GetDBData("select idxMenu, MenuName from menu where idxMenu = " + i); if (reader.Read()) { buffer.name = reader["menuName"].ToString(); } menuData.Add(buffer); } return(menuData); }
public List <MenuCategoryData> GetCategoryData(int sTableNumber, int eTableNumber) { string[] categoryName = { "햄버거", "드링크", "사이드 메뉴" }; List <MenuCategoryData> categoryData = new List <MenuCategoryData>(); for (int i = 1, checking = 1; i < 4; i++) { int totalPrice = 0; int totalCount = 0; int Nchecking = 0; MenuCategoryData buffer = new MenuCategoryData(); MySqlDataReader reader = connection.GetDBData("select category, idxMenu from menu where category = " + i + " order by idxMenu desc"); if (reader.Read()) { Nchecking = Int32.Parse(reader["idxMenu"].ToString()); } reader = connection.GetDBData("select idxMenu, count, totalPrice, salePrice, eatTable from orders " + " where idxMenu >= " + checking + " and idxMenu <= " + Nchecking + " and eatTable >= " + sTableNumber + " and eatTable <= " + eTableNumber + ";"); checking = ++Nchecking; while (reader.Read()) { int count = Int32.Parse(reader["count"].ToString()); totalCount += count; totalPrice += (Int32.Parse(reader["totalPrice"].ToString()) * count + Int32.Parse(reader["salePrice"].ToString()) * count); } buffer.count = totalCount; buffer.sumProfits = totalPrice; buffer.name = categoryName[(i - 1)]; categoryData.Add(buffer); } return(categoryData); }
public List <UserData> GetUserData() { List <UserData> usersData = new List <UserData>(); MySqlDataReader reader = connection.GetDBData("select max(idxUser) as MaxIdx from user"); if (reader.Read()) { int userNumbers = Int32.Parse(reader["MaxIdx"].ToString()) + 1; for (int i = 1; i < userNumbers; i++) { int profits = 0; UserData bufferUserData = new UserData(); List <MenuCategoryData> bufferMenuData = new List <MenuCategoryData>(); for (int j = 1; j < 45; j++) { MenuCategoryData buffer = new MenuCategoryData(); reader = connection.GetDBData("select idxMenu, count, totalPrice from orders where idxMenu = " + j); while (reader.Read()) { buffer.count += Int32.Parse(reader["count"].ToString()); profits += (Int32.Parse(reader["count"].ToString()) * Int32.Parse(reader["totalPrice"].ToString())); } reader = connection.GetDBData("select idxMenu, MenuName from menu where idxMenu = " + j); if (reader.Read()) { buffer.name = reader["MenuName"].ToString(); } bufferMenuData.Add(buffer); } bufferUserData.menuData = bufferMenuData; bufferUserData.sumProfits = profits; usersData.Add(bufferUserData); } } return(usersData); }