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