public bool performSignIn(string userName, string password) { MerchandiserID = userName; string pass; List <Dictionary <String, String> > result = DataBaseManager.runSelectQuery("Select Password from SignInInfo where UserName='******'"); result.ElementAt(0).TryGetValue("Password", out pass); return(password == pass ? true : false); }
public List <Dictionary <String, String> > getCompanyID() { List <Dictionary <String, String> > result = DataBaseManager.runSelectQuery("Select CompanyID from Provider"); return(result); }
public List <Dictionary <String, String> > availableStock() { List <Dictionary <String, String> > result = DataBaseManager.runSelectQuery("Select Item.ItemID,Item.ItemName,Item.Cost,Item.CompanyID,Stock.Quantity from Item Inner Join Stock ON Item.ItemID=Stock.ItemID"); return(result); }
public List <Dictionary <String, String> > getBuyerID() { List <Dictionary <String, String> > result = DataBaseManager.runSelectQuery("Select BuyerID from Buyer"); return(result); }
public List <Dictionary <String, String> > getItemIDs() { List <Dictionary <String, String> > result = DataBaseManager.runSelectQuery("Select ItemID from Item"); return(result); }