static public Product SelectProduct(string code)
{
DentistToolsEntities context = new DentistToolsEntities();
Product SelectedProduct = context.Products.Where(p => p.Code == code).FirstOrDefault();
return(SelectedProduct);
}
static public bool AddNewProduct(Product NewProduct)
{
DentistToolsEntities context = new DentistToolsEntities();
if (SelectProduct(NewProduct.Code) == null)
{
context.Products.Add(NewProduct);
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
static public bool ValidateLogin(string username, string password)
{
DentistToolsEntities context = new DentistToolsEntities();
UserLogin User = new UserLogin();
User = context.UserLogins.Where(u => u.UserName == username & u.Pass == password).FirstOrDefault();
if (User == null)
{
return(false);
}
else
{
return(true);
}
}
static public bool RevokeQuantity(int Quantity, String Code)
{
try
{
DentistToolsEntities context = new DentistToolsEntities();
Product ModifiedProduct = new Product();
ModifiedProduct = context.Products.Where(p => p.Code == Code).FirstOrDefault();
ModifiedProduct.Qty -= Quantity;
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
static public List <Product> SelectAllProducts()
{
DentistToolsEntities context = new DentistToolsEntities();
return(context.Products.ToList());
}
