private void InsertProduct() { using (cnViragkereskedes context = new cnViragkereskedes()) { foreach (var x in Prod) { var CategoryId = context.enCategories.First(a => a.category_name == x.CategoryName); var NewProduct = new enProduct() { product_name = x.Name, product_price_net = x.NetPrice, product_fees = x.Fees, product_sale = x.Sale, product_description = x.Description, product_icon = x.Icon, product_active = x.Active, enCategory = CategoryId, product_price_gross = x.GrossPrice }; if (Bouquet) { foreach (var UsedAccessories in AccessoryAmount) { var AccessoryName = context.enAccessories.First(a => a.accessory_name == UsedAccessories.Key); NewProduct.enAccessory_vs_product.Add(new enAccessory_vs_product() { enAccessory = AccessoryName, accessory_amount = UsedAccessories.Value }); } foreach (var UsedProducts in ProdAmount) { var ProductName = context.enProducts.Where(a => a.product_name == UsedProducts.Key).ToList(); NewProduct.enBouquets.Add(new enBouquet() { enProducts = ProductName, product_amount = UsedProducts.Value }); } } context.enProducts.Add(NewProduct); } context.SaveChanges(); } }
public static List <enCategory> AllCategories() { using (cnViragkereskedes context = new cnViragkereskedes()) { return(context.enCategories.ToList()); } }
private void chbTATermékÚjFelvétel_Checked(object sender, RoutedEventArgs e) { cbTATermékek.IsEnabled = false; btTAMódosítás.Visibility = Visibility.Hidden; btTAFelvétel.Visibility = Visibility.Visible; cnViragkereskedes valami = new cnViragkereskedes(); cbTAKategóriák.ItemsSource = (from x in valami.enCategories select new { x.category_name }).ToList(); }
public List <UserData> User_Login(string uName, string userPassword, out List <UserData> validData) { using (cnViragkereskedes context = new cnViragkereskedes()) { validData = context.enUsers.Where(x => x.user_name == uName && x.user_password == userPassword).Select(x => new UserData { userName = x.user_name, userAdmin = x.user_admin }).ToList(); return(validData); } }
public List <OrderList> UserOrders(int uid) { using (cnViragkereskedes context = new cnViragkereskedes()) { return(context.enOrders.Where(x => x.enUsers.user_id == uid).Select(x => new OrderList() { Id = x.order_id, price = x.order_price, OrderDate = x.order_date }).ToList()); } }
public void ChangePassword(string uName, string newPassword) { using (cnViragkereskedes context = new cnViragkereskedes()) { var oldPassword = context.enUsers.SingleOrDefault(x => x.user_name == uName); oldPassword.user_password = newPassword; oldPassword.user_name = uName; context.Entry(oldPassword).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
private void Insert_User(string uname, string pw, bool admin = false) { //enUser newUser = new enUser() { user_name = uname, user_password = pw, user_admin = admin }; using (cnViragkereskedes context = new cnViragkereskedes()) { context.enUsers.Add(new enUser() { user_name = uname, user_password = pw, user_admin = admin }); context.SaveChanges(); } }
private bool UserCheck(string uname) { using (cnViragkereskedes context = new cnViragkereskedes()) { var user = context.enUsers.Where(x => x.user_name == uname).Select(x => x.user_name); if (user.Count() == 0) { return(true); } return(false); } }
public List <ProductsList> ListingProducts(bool onSale) { using (cnViragkereskedes context = new cnViragkereskedes()) { if (!onSale) { return(context.enProducts.Where(x => x.product_active == true).Select(x => new ProductsList() { Name = x.product_name, NetPrice = x.product_price_net, Fees = x.product_fees, Sale = x.product_sale, Description = x.product_description, Icon = x.product_icon, Active = x.product_active, CategoryName = x.enCategory.category_name, GrossPrice = x.product_price_gross }).ToList()); } else { return(context.enProducts.Where(x => x.product_sale == true && x.product_active == true).Select(x => new ProductsList() { Name = x.product_name, NetPrice = x.product_price_net, Fees = x.product_fees, Sale = x.product_sale, Description = x.product_description, Icon = x.product_icon, Active = x.product_active, CategoryName = x.enCategory.category_name, GrossPrice = x.product_price_gross }).ToList()); } } }
public List <DetailsList> OrderDetails(int oid) { List <enOrder> Orders = new List <enOrder>(); using (cnViragkereskedes context = new cnViragkereskedes()) { Orders = context.enOrders.Where(x => x.order_id == oid).ToList(); List <DetailsList> oDetails = new List <DetailsList>(); var DetailsId = context.enOrder_details.Where(x => x.enOrders == Orders).ToList(); foreach (var x in DetailsId) { oDetails.Add(new DetailsList() { ProductName = x.pName, ProdAmount = x.product_amount, ProdPrice = x.product_price }); } return(oDetails); } }
private bool IsProductExists() { using (cnViragkereskedes context = new cnViragkereskedes()) { string IsName = ""; foreach (var x in Prod) { IsName = x.Name; } var IsExists = context.enProducts.Where(x => x.product_name == IsName).Select(x => x.product_id); if (IsExists.Count() > 0) { return(false); } else { return(true); } } }
public bool ModifyProduct(List <ProductsList> CProd) { using (cnViragkereskedes context = new cnViragkereskedes()) { var ProductToChange = new enProduct(); foreach (var prod in CProd) { ProductToChange = context.enProducts.Where(x => x.product_name == prod.Name).First(); ProductToChange.product_name = prod.Name; ProductToChange.product_price_net = prod.NetPrice; ProductToChange.product_fees = prod.Fees; ProductToChange.product_sale = prod.Sale; ProductToChange.product_description = prod.Description; ProductToChange.product_icon = prod.Icon; ProductToChange.product_active = prod.Active; ProductToChange.product_price_gross = prod.GrossPrice; } context.Entry(ProductToChange).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return(true); } }
public void InsertOrder(List <OrderList> oList, List <DetailsList> dList, int uid) { using (cnViragkereskedes context = new cnViragkereskedes()) { var CurrentUser = context.enUsers.Where(x => x.user_id == uid).First(); var NewOrder = new enOrder(); foreach (var x in oList) { NewOrder = context.enOrders.Add(new enOrder() { order_price = x.price, order_date = x.OrderDate, enUsers = CurrentUser }); context.enOrders.Add(NewOrder); } foreach (var x in dList) { var CurrentProduct = context.enProducts.Where(y => y.product_name == x.ProductName).ToList(); NewOrder.enOrder_detail.Add(new enOrder_detail() { enProduct = CurrentProduct, product_amount = x.ProdAmount, product_price = x.ProdPrice }); } } }