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);
}
