//public ICommand DeketeCommand { get; set; }
//Удаление целой записи
public async Task DeleteBasket(BasketList del)
{
_ = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketDell") // добавляет к ендпоинт
.PostJsonAsync(del);
var basket = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketGet") // добавляет к ендпоинт
.GetJsonAsync <BasketList[]>(); // https://192.168.1.12:5002/api/basket/basketGet
BasketList = new ObservableCollection <BasketList>(basket);
//using (var db = new ApplicationContext())
//{
// //удалить из локальной БД
// db.BasketList.Remove(del);
// var basket = db.Basket.FirstOrDefault(x => x.BasketId == del.BasketId);
// //удалить из передаваемой таблицы
// db.Basket.Remove(basket);
// //удалиь из лист вьюш
// BasketList.Remove(del);
// NumberPrice();
// db.SaveChangesAsync();
//}
}
static void Main()
{
BasketList basket = new BasketList();
App myApp = new App(basket);
myApp.Run();
}
public ReceiptView(BasketList shopping_basket)
{
this.shopping_basket = shopping_basket;
InitializeComponent();
shopping_basket.AddedItem += new System.EventHandler(this.UpdateTotalPrice);
UpdateTotalPrice(null, null);
}
protected void BasketList_PreRender(object sender, EventArgs e)
{
//Configuring Data Source for the ListView
string connectionString = ConfigurationManager.ConnectionStrings[dbCommander.sourceString].ConnectionString;
if (Session["Basket"] != null)
{
List <string> venuesBasket = (List <string>)Session["Basket"];
if (venuesBasket.Count == 0)
{
ids = "00000000-0000-0000-0000-000000000000";
}
else
{
//Creating string from VenueID list in session
ids = string.Join("','", ((List <string>)Session["Basket"]).ToArray());
}
}
else
{
ids = "00000000-0000-0000-0000-000000000000";
}
//Passing the string of ids to the query
query = String.Format("SELECT * FROM Venues INNER JOIN Customers ON Venues.CustomerID = Customers.CustomerID WHERE VenueID IN ('{0}')", ids);
SqlDataSource source = new SqlDataSource(connectionString, query);
BasketList.DataSource = source;
BasketList.DataBind();
dbCommander.CloseConnection();
}
public StoreViewModel(BasketList shopping_basket, FezItem fez_item)
{
base.DisplayName = "Store";
_shopping_basket = shopping_basket;
_selected_fez_item = fez_item;
//OnAddToBasket += AddToBasket;
}
public void setup()
{
basket = new BasketList();
//FezSize fez_size = new FezSize("Test Fez Size", 1.2);
//FezStyle fez_style = new FezStyle("Long Description", "Short", 15.0m, true);
//fez_item = new FezItem(fez_size, fez_style);
}
private void AddToBasket(object o, bool isNewData = true)
{
Dish clone = (o as Dish).Clone();
BasketList.Add(clone);
SelectedBasketItem = clone;
CalculateBasketPrice();
}
public async Task <IActionResult> DeleteFromBasket(BasketList del)
{
var basket = _db.Baskets.FirstOrDefault(x => x.BasketId == del.BasketId);
_db.Baskets.RemoveRange(basket);
await _db.SaveChangesAsync(); // сохранить запись
return(Ok());
}
private void DeleteItemFromBasket(object o)
{
if (o != null)
{
Dish removableObject = o as Dish;
//(ItemList.Where(i => i.Name == removableObject.Name).First() as Dish).Color = new Color();
BasketList.Remove(removableObject);
CalculateBasketPrice();
}
}
public FezSelection(BasketList shopping_basket)
{
this.shopping_basket = shopping_basket;
InitializeComponent();
this.comboBoxStyle.SelectionChanged += new SelectionChangedEventHandler(UpdateOnStyleSelectionChanged);
this.comboBoxSize.SelectionChanged += new SelectionChangedEventHandler(UpdateOnSizeSelectionChanged);
CalculatePrice();
}
protected override void OnStartup(StartupEventArgs e)
{
base.OnStartup(e);
BasketList shopping_basket = new BasketList();
//FezSelection window = new FezSelection(shopping_basket);
MainWindowView window = new MainWindowView();
var viewModel = new MainWindowViewModel(shopping_basket);
window.DataContext = viewModel;
window.Show();
}
private void RemoveFromBasket_Click(object sender, RoutedEventArgs e)
{
if (BasketList.SelectedItem != null)
{
order.ItemsInBasket.Remove((MenuItem)BasketList.SelectedItem);
BasketList.UnselectAll();
}
if (order.ItemsInBasket.Count == 0)
{
HideBasket();
}
}
public async Task <IActionResult> basketOneAdd(BasketList del)
{
var basket = _db.Baskets.FirstOrDefault(x => x.BasketId == del.BasketId);
if (basket.Quantity >= 10)
{
return(BadRequest("Максимальное количество"));
}
basket.Quantity++;
await _db.SaveChangesAsync(); // сохранить запись
return(Ok());
}
public async Task <IActionResult> basketOneDell(BasketList del)
{
var basket = _db.Baskets.FirstOrDefault(x => x.BasketId == del.BasketId);
if (basket.Quantity <= 1)
{
return(BadRequest("Достигнуто минимальное количество"));
}
basket.Quantity--;
await _db.SaveChangesAsync(); // сохранить запись
return(Ok());
}
//прибавление кол-ва
public async Task AddQuantity(BasketList del)
{
_ = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketOneAdd") // добавляет к ендпоинт
.PostJsonAsync(del);
var basket = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketOneGet") // добавляет к ендпоинт
.SetQueryParam("orderOne", OrderDetail.OrderId)
.GetJsonAsync <BasketList[]>(); // https://192.168.1.12:5002/api/basket/basketOneGet
BasketList = new ObservableCollection <BasketList>(basket);
UpdatePrice();
}
private void xmlImportButton_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog fromXMLDialog = new OpenFileDialog();
fromXMLDialog.AddExtension = true;
fromXMLDialog.DefaultExt = "xml";
fromXMLDialog.Filter = "XML files (*.xml)|*.xml|Text files (*.txt)|*.txt|All files (*.*)|*.*";
if (fromXMLDialog.ShowDialog(this) == true)
{
StreamReader fileStream;
fileStream = new StreamReader(fromXMLDialog.OpenFile());
XmlSerializer xmlSerializer = new XmlSerializer(typeof(BasketList));
shopping_basket = (BasketList)xmlSerializer.Deserialize(fileStream);
fileStream.Close();
}
}
private void WebCamConnect_NewObject(List <int?> id)
{
FindObjectList.Clear();
BasketList.Clear();
// findObject.ForEach(obj => FindObjectList.Add(obj));
foreach (int?recId in id)
{
foreach (var group in DishData.DishGroup)
{
if (group.ListDishes.Any(d => d.Id == recId))
{
AddToBasket(group.ListDishes.Find(d => d.Id == recId)); break;
}
}
}
}
//Удаление целой записи
public async Task DeleteFromBasket(BasketList del)
{
var response = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketOrderDell") // добавляет к ендпоинт
.SetQueryParam("orderId", OrderDetail.OrderId)
.PostJsonAsync(del);
var ok = await response.Content.ReadAsStringAsync();
Deleted = ok;
var basket = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketOneGet") // добавляет к ендпоинт
.SetQueryParam("orderOne", OrderDetail.OrderId)
.GetJsonAsync <BasketList[]>(); // https://192.168.1.12:5002/api/basket/basketOneGet
BasketList = new ObservableCollection <BasketList>(basket);
UpdatePrice();
}
public async Task <IActionResult> BasketOrderDell(BasketList del, int orderId)
{
var basket = _db.Baskets.FirstOrDefault(x => x.BasketId == del.BasketId);
_db.Baskets.RemoveRange(basket);
await _db.SaveChangesAsync(); // сохранить запись
var orderExistBasket = _db.Baskets.Any(x => x.OrderId == orderId); //есть ли продукты в заказе если нет то удалить заказ
if (!orderExistBasket)
{
var orderDel = _db.Orders.FirstOrDefault(x => x.OrderId == orderId);
_db.Orders.Remove(orderDel);
await _db.SaveChangesAsync(); // сохранить запись
return(Ok(del.Name));
}
return(Ok());
}
//удаление одного кол-ва
public async Task LowerQuantity(BasketList del)
{
_ = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketOneDell") // добавляет к ендпоинт
.PostJsonAsync(del);
var basket = await RequestBuilder.Create()
.AppendPathSegments("api", "basket", "basketGet") // добавляет к ендпоинт
.GetJsonAsync <BasketList[]>(); // https://192.168.1.12:5002/api/basket/basketOneDell
BasketList = new ObservableCollection <BasketList>(basket);
//using (var db = new ApplicationContext())
//{
// var quantity = BasketList.FirstOrDefault(x => x.BasketListId == del.BasketListId).Quantity;
// if (quantity <= 1)
// {
// return;
// }
// else
// {
// db.BasketList.FirstOrDefault(x => x.BasketListId == del.BasketListId).Quantity--; //изменить в БД
// db.Basket.FirstOrDefault(x => x.BasketId == del.BasketId).Quantity--; //изменить в передаваемой таблице
// BasketList.FirstOrDefault(x => x.BasketListId == del.BasketListId).Quantity--; //изменить в лист вьюш
// db.SaveChangesAsync();
// //посчет цены с учетом изменения количества
// var Price = Convert.ToInt32(BasketList.FirstOrDefault(x => x.BasketListId == del.BasketListId).Price);
// var Quantity = Convert.ToInt32(BasketList.FirstOrDefault(x => x.BasketListId == del.BasketListId).Quantity);
// BasketList.FirstOrDefault(x => x.BasketListId == del.BasketListId).OverallPrice = Price * Quantity;
// db.BasketList.FirstOrDefault(x => x.BasketListId == del.BasketListId).OverallPrice = Price * Quantity;
// //подсчет общей цены и передача на страницу
// NumberPrice();
// BasketList = new ObservableCollection<BasketList>(db.BasketList);
// }
//}
}
public static void RenderBasket(GroupBox gbSender)
{
//Finding the final parent (the main form (ShopForm))
ShopGBControl sgbcSender = (ShopGBControl)gbSender.Parent;
FlowLayoutPanel flpSender = (FlowLayoutPanel)sgbcSender.Parent;
Form baseForm = (Form)flpSender.Parent;
//Generating an IEnumerable of required type
var flpList = baseForm.Controls.OfType <FlowLayoutPanel>();
//Looping through the flpList, looking for the needed FlowLayoutPanel
//Checking whether the item is already in there and adding it if needed
//Or displaying an error message
foreach (var flp in flpList)
{
if (flp.Name == "BasketPanel")
{
for (int i = 0; i < TempBasketList.Count; i++)
{
Product prod = TempBasketList[i];
if (!BasketList.Contains(prod))
{
prod.Quantity--;
Product basketProd = new Product(prod);
BasketList.Add(basketProd);
flp.Controls.Add(new BasketGBControl(basketProd));
TempBasketList.Clear();
}
else
{
TempBasketList.Clear();
MessageBox.Show("Product is in the basket already");
}
}
}
}
}
// выводит список товаров в корзине
static public Product ViewToBasket(int click)
{
string sql = $"SELECT * FROM Products P JOIN Basket B ON P.Id = B.ProductId WHERE (SELECT DeviceId FROM Device WHERE DeviceId = N'{deviceId}') = N'{deviceId}'";
bool check = true;
SqlCommand sqlCommand = new SqlCommand(sql, connection);
SqlDataReader reader = sqlCommand.ExecuteReader();
Product p = new Product();
while (reader.Read())
{
p.productPhoto = reader.GetString(reader.GetOrdinal("Photo"));
p.productName = reader.GetString(reader.GetOrdinal("Title"));
p.productCharacter = reader.GetString(reader.GetOrdinal("Description"));
p.productAmount = reader.GetString(reader.GetOrdinal("ProductAmount"));
p.productPrice = reader.GetInt32(reader.GetOrdinal("Price"));
p.basketAmount = 0 + reader.GetInt32(reader.GetOrdinal("BasketAmount"));
p.productId = reader.GetInt32(reader.GetOrdinal("Id"));
p.basketPrice = 1;
if (click == 1)
{
BasketList.listPoducts(p);
}
else
{
ProductBasket.Prod(p);
}
check = false;
}
reader.Close();
if (check)
{
p = null;
}
return(p);
}
public void init()
{
myBasket = new BasketList();
}
public ShoppingBasketViewModel(BasketList shopping_basket)
{
base.DisplayName = "Basket";
_shopping_basket = shopping_basket;
}
public App()
{
shopping_basket = new BasketList();
}
public App(BasketList shopping_basket)
{
this.shopping_basket = shopping_basket;
}
