internal static void DeleteUser(UserViewModel user)
{
WarehouseEntities entity = new WarehouseEntities();
var userToDelete =
from utd in entity.Users
where utd.Username.Contains(user.Username)
select utd;
if (userToDelete.Count() != 0)
{
foreach (var item in userToDelete)
{
entity.Users.Remove(item);
}
entity.SaveChanges();
MessageBox.Show("User " + user.Username + " deleted", "Confirmation", MessageBoxButton.OK);
}
else
{
MessageBox.Show("User " + user.Username + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
}
private void ButtonLoginClick(object sender, RoutedEventArgs e)
{
var pass = Convert.ToString(Convert.ToBase64String(System.Security.Cryptography.MD5.Create().ComputeHash(Encoding.UTF8.GetBytes(TextBoxPassword.Password))));
WarehouseEntities entity = new WarehouseEntities();
try
{
var userToLogin =
(from utl in entity.Users
where utl.Username == TextBoxUsernameLogin.Text && utl.Password == pass
select utl).First();
if (userToLogin != null)
{
switch (userToLogin.Rank)
{
case "Admin":
AdminPanel adminPanelWindow = new AdminPanel();
adminPanelWindow.Show();
break;
case "Worker":
TechnicianPanelWindow techPanelWindow = new TechnicianPanelWindow();
techPanelWindow.Show();
break;
}
Application.Current.MainWindow.Close();
}
}
catch(Exception)
{
MessageBox.Show("Wrong username or password", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
internal static void AddUser(UserViewModel user)
{
WarehouseEntities entity = new WarehouseEntities();
var userToAdd =
from uta in entity.Users
where uta.Username==user.Username
select uta;
if (userToAdd.Count()!=0)
{
MessageBox.Show("User " + user.Username + " exists", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
entity.Users.Add(new User()
{
Username = user.Username,
Password = Convert.ToBase64String(System.Security.Cryptography.MD5.Create().
ComputeHash(Encoding.UTF8.GetBytes(user.Password))),
Rank = user.Rank
});
entity.SaveChanges();
MessageBox.Show("User " + user.Username + " added", "Confirmation", MessageBoxButton.OK);
}
}
internal static void DeleteProduct(ProductViewModel product)
{
WarehouseEntities entity = new WarehouseEntities();
var productToDelete =
from ptd in entity.Products
where ptd.Name.Contains(product.Name) && ptd.Vendor1.Name.Contains(product.Vendor.Name)
select ptd;
if (productToDelete.Count() != 0)
{
foreach (var item in productToDelete)
{
entity.Products.Remove(item);
}
MessageBox.Show("Product " + product.Name + " deleted", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
else
{
MessageBox.Show("Product " + product.Name + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
internal static void DeleteVendor(VendorViewModel vendor)
{
WarehouseEntities entity = new WarehouseEntities();
var vendorToDelete =
(from vtd in entity.Vendors
where vtd.Name == vendor.Name
select vtd).First();
if (vendorToDelete!=null)
{
var del = vendorToDelete.Products;
foreach (var item in del.ToList())
{
entity.Products.Remove(item);
}
entity.Vendors.Remove(vendorToDelete);
MessageBox.Show("Vendor " + vendor.Name + " deleted", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
else
{
MessageBox.Show("Vendor " + vendor.Name + " doesn't exist", "Confirmation", MessageBoxButton.OK);
}
}
internal static void AddVendor(VendorViewModel vendor)
{
WarehouseEntities entity = new WarehouseEntities();
var vendorToAdd =
from vta in entity.Vendors
where vta.Name.Contains(vendor.Name)
select vta;
if (vendorToAdd.Count()!=0)
{
MessageBox.Show("Vendor " + vendor.Name + " exists", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
entity.Vendors.Add(new Vendor()
{
Name = vendor.Name
});
MessageBox.Show("Vendor " + vendor.Name + " added", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
}
internal static IEnumerable<VendorViewModel> GetAllVendors()
{
WarehouseEntities entity = new WarehouseEntities();
var allVendors =
from av in entity.Vendors
select new VendorViewModel()
{
Name = av.Name,
};
return allVendors;
}
internal static IEnumerable<UserViewModel> GetAllUsers()
{
WarehouseEntities entity = new WarehouseEntities();
var allUsers =
from au in entity.Users
select new UserViewModel()
{
Username = au.Username,
Rank = au.Rank
};
return allUsers;
}
internal static IEnumerable<ProductViewModel> GetAllProducts()
{
WarehouseEntities entity = new WarehouseEntities();
var allProducts =
from ap in entity.Products
select new ProductViewModel()
{
Name = ap.Name,
Quantity = ap.Quantity,
BuyPrice = ap.BuyPrice,
SellPrice = ap.SellPrice,
DayOfPurchase = ap.DayOfPurchase,
Vendor = new VendorViewModel()
{
Name = ap.Vendor1.Name
}
};
return allProducts;
}
internal static void AddProduct(ProductViewModel product)
{
WarehouseEntities entity = new WarehouseEntities();
var productToAdd =
from pta in entity.Products
where ((pta.Name == product.Name) && (pta.Vendor1.Name == product.Vendor.Name))
select pta;
if (productToAdd.Count() != 0)
{
UpdateProduct(product);
}
else
{
var productVendor =
(from pv in entity.Vendors
where pv.Name == product.Vendor.Name
select pv).First();
entity.Products.Add(new Product()
{
Name = product.Name,
BuyPrice = product.BuyPrice,
SellPrice = product.SellPrice,
Quantity = product.Quantity,
DayOfPurchase = DateTime.Now,
Vendor = productVendor.VendorID
});
MessageBox.Show("Product " + product.Name + " added!", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
}
internal static void UseProduct(ProductViewModel product)
{
WarehouseEntities entity = new WarehouseEntities();
var productToUse =
from ptu in entity.Products
where ptu.Name.Contains(product.Name) && ptu.Vendor1.Name.Contains(product.Vendor.Name)
select ptu;
if (productToUse.Count() != 0)
{
foreach (var item in productToUse)
{
item.Quantity -= product.Quantity;
item.DayOfSale = DateTime.Now;
if (item.SaleQuantity == null)
{
item.SaleQuantity = product.Quantity;
}
else
{
item.SaleQuantity += product.Quantity;
}
}
MessageBox.Show("Product " + product.Name + " used", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
else
{
MessageBox.Show("Product " + product.Name + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
internal static void UpdateProduct(ProductViewModel product)
{
WarehouseEntities entity = new WarehouseEntities();
var productToUpdate =
from ptu in entity.Products
where ptu.Name.Contains(product.Name) && ptu.Vendor1.Name.Contains(product.Vendor.Name)
select ptu;
if (productToUpdate.Count() != 0)
{
foreach (var item in productToUpdate)
{
item.Quantity += product.Quantity;
item.BuyPrice = product.BuyPrice;
}
MessageBox.Show("Product " + product.Name + " updated", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
else
{
MessageBox.Show("Product " + product.Name + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
internal static IEnumerable<ProductViewModel> GetProductReportSales(ProductViewModel product)
{
WarehouseEntities entity = new WarehouseEntities();
var productReportSales =
(from prs in entity.Products
where prs.DayOfSale.Day.Equals(product.DayOfSale.Day)
&& prs.DayOfSale.Month.Equals(product.DayOfSale.Month)
&& prs.DayOfSale.Year.Equals(product.DayOfSale.Year)
select new ProductViewModel()
{
Name = prs.Name,
Quantity = prs.Quantity,
SaleQuantity = prs.SaleQuantity,
BuyPrice = prs.BuyPrice,
SellPrice = prs.SellPrice,
DayOfSale = prs.DayOfSale,
Vendor = new VendorViewModel()
{
Name = prs.Vendor1.Name
}
}).ToList();
return productReportSales;
}
