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 IDictionary <DateTime, UserOrdersModel> GetUserOrderForPeriod(int companyId, int userId, DateTime startDate, DateTime endDate)
{
var results = new Dictionary <DateTime, UserOrdersModel>();
using (var dataContext = this.dataContextFactory.Create())
{
var list = dataContext.p_GetUserOrderForPeriod(companyId, userId, startDate, endDate);
foreach (var item in list)
{
UserOrdersModel orderedList;
if (!results.ContainsKey(item.Date))
{
orderedList = new UserOrdersModel()
{
OrderID = item.OrderID,
IsPurchased = item.IsPurchased,
UserID = item.UserID,
UserName = item.Name,
Orders = new List <OrderedMenuModel>()
};
results.Add(item.Date, orderedList);
}
else
{
orderedList = results[item.Date];
}
orderedList.Orders.Add(new OrderedMenuModel
{
Course = new CourseModel
{
CategoryName = item.CourseCategoryName,
CategoryType = (CourseCategories)item.CourseCategoryID,
ID = item.CourseID,
Name = item.Name,
MenuItemID = item.MenuID,
Price = (float)item.Price,
OrderItemID = item.OrderItemID,
Boxindex = item.Boxindex
//OrderedQuantity = item.
},
Quantity = (double)item.Quantity,
IsPurchased = item.IsPurchased
});
}
}
return(results);
}
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);
}
public IEnumerable <UserOrdersForDateViewModel> GetOrders(DateTime fromDate, DateTime toDate)
{
var orders = this.orderService.GetUserOrders(fromDate, toDate);
var userOrdersInRangeViewModel = new List <UserOrdersForDateViewModel>();
for (var orderDate = fromDate; orderDate <= toDate; orderDate = orderDate.AddDays(1))
{
if (!this.calendarService.IsWorkingDay(orderDate))
{
continue;
}
UserOrdersModel userOrders;
if (!orders.ContainsKey(orderDate.Date))
{
userOrders = new UserOrdersModel
{
OrderID = 0,
IsPurchased = false,
Orders = new List <OrderedMenuModel>()
};
}
else
{
userOrders = orders[orderDate.Date];
}
var isFreezed = this.orderService.IsMenuFreezedForDate(orderDate);
var userOrdersForDateViewModel = new UserOrdersForDateViewModel
{
OrderID = userOrders.OrderID,
Date = orderDate,
IsFreezed = isFreezed,
IsPurchased = userOrders.IsPurchased,
Orders = userOrders.Orders
};
userOrdersInRangeViewModel.Add(userOrdersForDateViewModel);
}
return(userOrdersInRangeViewModel);
}
public List <UserOrdersModel> GETUserOrders(string kadi, string sifre)
{
List <UserOrdersModel> lo = new List <UserOrdersModel>();
Users u = db.Users.FirstOrDefault(x => x.Kadi == kadi && x.Sifre == sifre);
var orderlist = db.Orders.Where(x => x.UserID == u.Id);
foreach (var item in orderlist)
{
UserOrdersModel uom = new UserOrdersModel();
uom.Id = item.Id;
uom.ProductName = db.Products.FirstOrDefault(x => x.Id == item.ProductID).Ad;
uom.Tutar = item.Tutar.ToString();
uom.OrderDate = item.OrderDate.ToString();
uom.Durum = item.Durum.ToString();
uom.Adet = item.Adet.ToString();
int?cID = db.Products.FirstOrDefault(x => x.Ad == uom.ProductName).CategoryID;
uom.CategoryName = db.Categories.FirstOrDefault(x => x.Id == cID).Ad;
lo.Add(uom);
}
return(lo);
}
public UserOrdersModel GetUserOrderById(int orderId, DateTime day)
{
var result = new UserOrdersModel
{
Orders = new List <OrderedMenuModel>()
};
using (var dataContext = this.dataContextFactory.Create())
{
var list = dataContext.p_UserOrder_GetByID(orderId, day);
foreach (var item in list)
{
if (result.Orders.Count == 0)
{
result.OrderID = item.OrderID;
result.IsPurchased = item.IsPurchased;
result.UserID = item.UserID;
result.UserName = string.Empty; //TODO?
}
result.Orders.Add(new OrderedMenuModel
{
Course = new CourseModel
{
CategoryName = item.CourseCategoryName,
CategoryType = (CourseCategories)item.CourseCategoryID,
ID = item.CourseID,
CompanyID = item.CompanyID,
Name = item.Name,
Price = (float)item.Price,
Description = item.Description,
Weight = item.Weight
},
Quantity = (float)item.Quantity,
IsPurchased = item.IsPurchased
});
}
}
return(result);
}
public ActionResult ShowDetails([DataSourceRequest]DataSourceRequest request, UserOrdersModel model)
{
return this.RedirectToAction("Index", "Details", new { id = model.Id });
}
public ActionResult ShowDetails([DataSourceRequest] DataSourceRequest request, UserOrdersModel model)
{
return(this.RedirectToAction("Index", "Details", new { id = model.Id }));
}
