public List <OrderedMenuModel> SelectAllOrderedMenus() { string query = "SELECT * FROM orderedmenu"; List <OrderedMenuModel> orderedMenus = new List <OrderedMenuModel>(); if (this.OpenMySqlConnection() == true) { MySqlCommand command = CreateCommand(query); MySqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { OrderedMenuModel orderedMenu = new OrderedMenuModel(); orderedMenu.IDX = dataReader.GetInt32("IDX"); orderedMenu.OrderIdx = dataReader.GetInt32("order_IDX"); orderedMenu.MenuIDX = dataReader.GetInt32("menu_IDX"); orderedMenu.Amount = dataReader.GetInt32("amount"); orderedMenus.Add(orderedMenu); } dataReader.Close(); this.CloseMySqlConnection(); return(orderedMenus); } else { MessageBox.Show("메뉴를 불러오는것에 실패하였습니다."); return(null); } }
public IEnumerable <UserOrdersModel> GetAllOrdersForDay(int companyId, DateTime day) { var results = new Dictionary <int, UserOrdersModel>(); Func <p_GetAllOrdersByDate_Result, UserOrdersModel> getUserOrders = user => { if (results.ContainsKey(user.UserID)) { return(results[user.UserID]); } var userOrders = new UserOrdersModel { OrderID = user.OrderID, UserID = user.UserID, UserName = user.UserName, IsPurchased = user.IsPurchased, UserIdentityNumber = user.UserIdentityNumber, Orders = new List <OrderedMenuModel>() }; results[user.UserID] = userOrders; return(userOrders); }; using (var dataContext = this.dataContextFactory.Create()) { var list = dataContext.p_GetAllOrdersByDate(companyId, day); foreach (var item in list) { var userOrders = getUserOrders(item); var order = new OrderedMenuModel { Course = new CourseModel { ID = item.CourseID, CategoryName = item.CourseCategoryName, CategoryType = (CourseCategories)item.CourseCategoryID, Name = item.CourseName, Price = (float)item.CoursePrice, OrderItemID = item.OrderItemID, Boxindex = item.Boxindex }, Quantity = (double)item.Quantity, IsPurchased = item.IsPurchased }; userOrders.Orders.Add(order); } } return(results.Values.OrderBy(x => x.UserName)); }
public UserOrdersModel GetOrderByIdentityCard(int supplierCompanyId, DateTime date, string hexIdentityCard) { UserOrdersModel userOrders = null; using (var dataContext = this.dataContextFactory.Create()) { var list = dataContext.p_Order_GetByIdentityCard(supplierCompanyId, date, hexIdentityCard); foreach (var item in list) { if (userOrders == null) { userOrders = new UserOrdersModel { OrderID = item.OrderID, UserID = item.UserID, UserName = item.UserName, IsPurchased = item.IsPurchased, Orders = new List <OrderedMenuModel>() }; } if (item.UserID != userOrders.UserID) { throw new Exception( string.Format("p_Order_GetByIdentityCard return wrong userOrders item:{0}; UserID: {1}", userOrders.UserID, item.UserID)); } var order = new OrderedMenuModel { Course = new CourseModel { ID = item.CourseID, CategoryName = item.CourseCategoryName, CategoryType = (CourseCategories)item.CourseCategoryID, Name = item.CourseName, Price = (float)item.CoursePrice, OrderItemID = item.OrderItemID, Boxindex = item.Boxindex }, Quantity = (double)item.Quantity }; userOrders.Orders.Add(order); } } return(userOrders); }