public double GetPrice()
{
double Price = 0;
double convertQantity = 0;
string query = "SELECT * from SelectedItem";
List <Inventory> inventoryList = new List <Inventory>();
DataBaseConnectionClass dcc = new DataBaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Inventory inventory = new Inventory();
inventory.ItemQuantity = Convert.ToInt32(sdr["ItemQuantity"]);
convertQantity = (double)inventory.ItemQuantity;
inventory.ItemPrice = Convert.ToDouble(sdr["ItemPrice"]);
Price = (inventory.ItemPrice * convertQantity) + Price;
inventoryList.Add(inventory);
}
dcc.CloseConnection();
return(Price);
}
public List <Inventory> GetInventory(string ItemId)
{
string query = "SELECT * From Inventroy WHERE (ItemId LIKE '%" + ItemId + "%' OR ItemId LIKE '" + ItemId + "%_%') OR (ItemName LIKE '%" + ItemId + "%' ) ";
Inventory inventory = null;
List <Inventory> inventoryList = new List <Inventory>();
DataBaseConnectionClass dcc = new DataBaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
inventory = new Inventory();
inventory.ItemId = sdr["ItemId"].ToString();
inventory.ItemName = sdr["ItemName"].ToString();
inventory.ItemQuantity = Convert.ToInt32(sdr["ItemQuantity"]);
inventory.ItemPrice = Convert.ToDouble(sdr["ItemPrice"]);
inventoryList.Add(inventory);
}
dcc.CloseConnection();
return(inventoryList);
}
public List <User> GetUser(string userS)
{
string query = "SELECT * From UserInfo WHERE (userId LIKE '%" + userS + "%' OR userId LIKE '" + userS + "%_%') OR (userName LIKE '%" + userS + "%' ) OR (userType LIKE '%" + userS + "%' ) ";
User user = null;
List <User> userList = new List <User>();
DataBaseConnectionClass dcc = new DataBaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
user = new User();
user.UserId = sdr["UserId"].ToString();
user.DateOfBirth = Convert.ToDateTime(sdr["DateOfBirth"]);
user.UserName = sdr["UserName"].ToString();
user.Password = sdr["Password"].ToString();
user.Designation = sdr["Designation"].ToString();
user.Salary = Convert.ToDouble(sdr["Salary"]);
user.UserType = sdr["UserType"].ToString();
user.DateOfJoing = Convert.ToDateTime(sdr["DateOfJoing"]);
user.ContactNo = sdr["ContactNo"].ToString();
userList.Add(user);
}
dcc.CloseConnection();
return(userList);
}
public List <OrderMenu> GetAllOrderMenu()
{
string query = "SELECT * from SelectedItem";
List <OrderMenu> orderMenuList = new List <OrderMenu>();
DataBaseConnectionClass dcc = new DataBaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
OrderMenu orderMenu = new OrderMenu();
orderMenu.OrderNo = Convert.ToInt32(sdr["OrderNo"].ToString());
orderMenu.ItemName = sdr["ItemName"].ToString();
orderMenu.ItemQuantity = Convert.ToInt32(sdr["ItemQuantity"]);
orderMenu.ItemPrice = Convert.ToDouble(sdr["ItemPrice"]);
orderMenuList.Add(orderMenu);
}
dcc.CloseConnection();
return(orderMenuList);
}
public List <Inventory> GetAllInventory()
{
string query = "SELECT * from Inventroy";
List <Inventory> inventoryList = new List <Inventory>();
DataBaseConnectionClass dcc = new DataBaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Inventory inventory = new Inventory();
inventory.ItemId = sdr["ItemId"].ToString();
inventory.ItemName = sdr["ItemName"].ToString();
inventory.ItemQuantity = Convert.ToInt32(sdr["ItemQuantity"]);
inventory.ItemPrice = Convert.ToDouble(sdr["ItemPrice"]);
inventoryList.Add(inventory);
}
dcc.CloseConnection();
return(inventoryList);
}
public List <Menue> GetItem(string menuId)
{
string query = "SELECT * from MenuInfo where MenuID = '" + menuId + "'";
List <Menue> menuList = new List <Menue>();
DataBaseConnectionClass dcc = new DataBaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Menue menu = new Menue();
menu.MenuId = sdr["MenuID"].ToString();
menu.MenuName = sdr["MenuName"].ToString();
menu.MenuCatagory = sdr["MenuCatagory"].ToString();
menu.MenuType = sdr["MenuType"].ToString();
menuList.Add(menu);
}
dcc.CloseConnection();
return(menuList);
}