private void FormCreateRequest_Load(object sender, EventArgs e) { try { List <FlowerViewModel> list = flowerLogic.Read(null); if (list != null) { comboBoxNameFlower.DisplayMember = "FlowerName"; comboBoxNameFlower.ValueMember = "Id"; comboBoxNameFlower.DataSource = list; comboBoxNameFlower.SelectedItem = null; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } try { List <RequestViewModel> list = requestLogic.Read(null); if (list != null) { comboBoxRequest.DisplayMember = "RequestName"; comboBoxRequest.ValueMember = "Id"; comboBoxRequest.DataSource = list; comboBoxRequest.SelectedItem = null; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List<ReportRequestViewModel> GetRequestPlaces() { var flowers = flowerLogic.Read(null); var requests = requestLogic.Read(null); var list = new List<ReportRequestViewModel>(); foreach (var request in requests) { var record = new ReportRequestViewModel { RequestName = request.RequestName, Flowers = new List<Tuple<string, int>>(), TotalCount = 0 }; foreach (var place in flowers) { if (request.RequestsFlowers.ContainsKey(place.Id)) { record.Flowers.Add(new Tuple<string, int>(place.FlowerName, request.RequestsFlowers[place.Id].Item2)); record.TotalCount += request.RequestsFlowers[place.Id].Item2; } } list.Add(record); } return list; }
public List <ReportDetailRequestViewModel> GetDetailRequest() { var requests = requestLogic.Read(null); var list = new List <ReportDetailRequestViewModel>(); foreach (var request in requests) { foreach (var rec in request.DetailRequests) { var record = new ReportDetailRequestViewModel { RequestName = request.RequestName, DateCreate = request.DateCreate, DetailName = rec.Value.Item1, Count = rec.Value.Item2 }; list.Add(record); } } return(list); }
private void LoadData() { try { var list = logic.Read(null); if (list != null) { dataGridView.DataSource = list; dataGridView.Columns[0].Visible = false; dataGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView.Columns[3].Visible = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <RequestModel> GetRequestList() => _request.Read(null)?.Select(rec => RequestConvert(rec)).ToList();
/// <summary> /// Получение списка заявок и заказов с расшифровкой по продуктам /// </summary> /// <returns></returns> public List <ReportRequestAndOrderProductsViewModel> GetRequestOrderProducts(ReportPeriodBindingModel model) { var reportList = new List <ReportRequestAndOrderProductsViewModel>(); var requests = requestLogic.Read(new RequestBindingModel { DateFrom = model.DateFrom, DateTo = model.DateTo }); var orders = orderLogic.Read(new OrderBindingModel { DateFrom = model.DateFrom, DateTo = model.DateTo }); int ri = 0; int oi = 0; while (ri < requests.Count && oi < orders.Count) { if (requests[ri].DateRequest < orders[oi].DateCreate) { foreach (var product in requests[ri].RequestProducts) { reportList.Add(new ReportRequestAndOrderProductsViewModel { Id = requests[ri].Id.Value, DateCreate = requests[ri].DateRequest, DishName = string.Empty, ProductName = product.Value.Item1, Count = product.Value.Item2 }); } ri++; } else { foreach (var dish in orders[oi].OrderDishes) { var currentDish = dishLogic.Read(new DishBindingModel { Id = dish.Key })[0]; foreach (var product in currentDish.DishProducts) { reportList.Add(new ReportRequestAndOrderProductsViewModel { Id = null, DateCreate = orders[oi].DateCreate, DishName = currentDish.DishName, ProductName = product.Value.Item1, Count = product.Value.Item2 }); } } oi++; } } while (ri < requests.Count) { foreach (var product in requests[ri].RequestProducts) { reportList.Add(new ReportRequestAndOrderProductsViewModel { Id = requests[ri].Id.Value, DateCreate = requests[ri].DateRequest, DishName = string.Empty, ProductName = product.Value.Item1, Count = product.Value.Item2 }); } ri++; } while (oi < orders.Count) { foreach (var dish in orders[oi].OrderDishes) { var currentDish = dishLogic.Read(new DishBindingModel { Id = dish.Key })[0]; foreach (var product in currentDish.DishProducts) { reportList.Add(new ReportRequestAndOrderProductsViewModel { Id = null, DateCreate = orders[oi].DateCreate, DishName = currentDish.DishName, ProductName = product.Value.Item1, Count = product.Value.Item2 }); } } oi++; } return(reportList); }