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