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