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 bool ResetSelectedItem() { try { string query = "DELETE From SelectedItem"; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); dcc.ExecuteSQL(query); dcc.CloseConnection(); dcc.ConnectWithDB(); dcc.ExecuteSQL("DBCC CHECKIDENT ('[SelectedItem]', RESEED, 0)"); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Update(int updateQuantity, string itemName) { try { string query = "UPDATE SelectedItem SET ItemQuantity = " + updateQuantity + " where ItemName = '" + itemName + "' "; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Update(User user) { try { string query = "UPDATE UserInfo SET userName = '******' , Password = '******', Designation = '" + user.Designation + "',Salary = " + user.Salary + " , UserType = '" + user.UserType + "', ContactNo = '" + user.ContactNo + "' WHERE userId = '" + user.UserId + "'"; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Insert(Menue menu) { try { string query = "INSERT into MenuInfo VALUES ('" + menu.MenuId + "', '" + menu.MenuName + "','" + menu.MenuCatagory + "','" + menu.MenuType + "') "; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Insert(OrderMenu order) { try { string query = "INSERT into SelectedItem VALUES ('" + order.ItemName + "'," + order.ItemQuantity + "," + "(select ItemPrice from Inventroy where ItemName = '" + order.ItemName + "' )" + ") "; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Delete(string ItemName) { try { string query = "DELETE From SelectedItem WHERE ItemName = '" + ItemName + "' "; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Delete(string userId) { try { string query = "DELETE From UserInfo WHERE userId = '" + userId + "' "; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public bool Insert(Inventory inventory) { try { string query = "Insert into Inventroy VALUES('" + inventory.ItemId + "','" + inventory.ItemName + "'," + inventory.ItemQuantity + "," + inventory.ItemPrice + ")"; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch { return(false); } }
public bool Insert(User user) { try { string query = "INSERT into UserInfo VALUES ('" + user.UserId + "', '" + user.UserName + "'," + " '" + user.DateOfBirth + "','" + user.Password + "','" + user.Designation + "'," + " " + user.Salary + ",'" + user.UserType + "','" + DateTime.Now + "','" + user.Salary + "')"; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); int x = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
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); }
public bool ItemUpdate(Inventory inventory) { string query = "UPDATE Inventroy SET ItemQuantity = " + inventory.ItemQuantity + " , ItemName = '" + inventory.ItemName + "' ,ItemPrice = " + inventory.ItemPrice + " where ItemId ='" + inventory.ItemId + "' "; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); /* try * { * string query = "UPDATE Inventroy SET ItemQuantity = " + inventory.ItemQuantity + " , ItemName = '" + inventory.ItemName + "' ,ItemPrice = " + inventory.ItemPrice + " where ItemId ='" + inventory.ItemId + "' "; * DataBaseConnectionClass dcc = new DataBaseConnectionClass(); * dcc.ConnectWithDB(); * dcc.ExecuteSQL(query); * dcc.CloseConnection(); * return true; * } * catch (Exception ex) * { * return false; * }*/ }