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