public static List <productspart> GetAllAssocPartsBasedOnPart(int index) { using (var con = new InventoryMgmtEntities()) { return(con.productsparts.Where(n => n.partid == index).ToList()); } }
public static bool PartExists(int index) { using (var con = new InventoryMgmtEntities()) { return(con.partsdbs.Any(n => n.partid == index)); } }
public static List <productsdb> GetAllProducts() { using (var con = new InventoryMgmtEntities()) { return(con.productsdbs.ToList()); } }
public static productsdb GetProduct(int index) { using (var con = new InventoryMgmtEntities()) { return(con.productsdbs.Find(index)); } }
public static List <usertable> getOrderedeUsers() { using (var con = new InventoryMgmtEntities()) { return(con.usertables.OrderBy(n => n.username).ToList()); } }
//Products public static int AddProduct(productsdb product) { using (var con = new InventoryMgmtEntities()) { con.productsdbs.Add(product); con.SaveChanges(); return(product.productid); } }
public static void RemoveAssocPartByid(int index) { using (var con = new InventoryMgmtEntities()) { productspart tempProductPart = con.productsparts.Find(index); con.productsparts.Remove(tempProductPart); con.SaveChanges(); } }
//Parts public static int AddPart(partsdb part) { using (var con = new InventoryMgmtEntities()) { con.partsdbs.Add(part); con.SaveChanges(); return(part.partid); } }
public static void RemovePart(int index) { using (var con = new InventoryMgmtEntities()) { partsdb partTemp = con.partsdbs.Find(index); con.partsdbs.Remove(partTemp); con.SaveChanges(); } }
//Associated Parts public static void AddAssocPart(int product, int part) { using (var con = new InventoryMgmtEntities()) { productspart temp = new productspart(); temp.productid = product; temp.partid = part; con.productsparts.Add(temp); con.SaveChanges(); } }
public static List <partsdb> GetAllAssocPartsFull(int index) { using (var con = new InventoryMgmtEntities()) { var prodpart = con.productsparts.Where(n => n.productid == index).ToList(); List <partsdb> partsList = new List <partsdb>(); for (int i = 0; i < prodpart.Count(); i++) { partsList.Add(con.partsdbs.Find(prodpart[i].partid)); } return(partsList); } }
public static bool userExists(string user) { using (var con = new InventoryMgmtEntities()) { bool result = con.usertables.Any(n => n.username == user); if (result == false) { MessageBox.Show("No user by that name exists."); return(false); } return(true); } }
public static List <productsdb> GetAllProductsByUser(int index) { using (var con = new InventoryMgmtEntities()) { List <productsdb> products = con.productsdbs.ToList(); List <productsdb> toSend = new List <productsdb>(); for (int i = 0; i < products.Count(); i++) { if (products[i].createdby == index) { toSend.Add(products[i]); } } return(toSend); } }
public static void UpdatePart(partsdb part) { partsdb updatedPart = part; using (var con = new InventoryMgmtEntities()) { partsdb tempPart = con.partsdbs.Find(updatedPart.partid); tempPart.name = updatedPart.name; tempPart.instock = updatedPart.instock; tempPart.min = updatedPart.min; tempPart.max = updatedPart.max; tempPart.type = updatedPart.type; tempPart.details = updatedPart.details; tempPart.price = updatedPart.price; tempPart.lastmodified = DateTime.Now; if (updatedPart.createdby != null) { tempPart.createdby = updatedPart.createdby; } con.SaveChanges(); } }
public static bool isPassword(string user, string password) { using (var con = new InventoryMgmtEntities()) { usertable userObj = con.usertables.First(j => j.username == user); if (userObj.useractive != "t") { MessageBox.Show("This user does not have database priviledges. Please contact your supervisor."); return(false); } if (userObj.userpassword == password) { currentUser = userObj; return(true); } else { MessageBox.Show("Your password is incorrect."); } return(false); } }
public static List <partsdb> GetDerivedParts(int productIndex) { using (var con = new InventoryMgmtEntities()) { List <productspart> productPartList = con.productsparts.Where(n => n.productid == productIndex).ToList(); List <partsdb> tempList = new List <partsdb>(); for (int i = 0; i < productPartList.Count(); i++) { //Get part based on productPartLists.partID partsdb partTemp = con.partsdbs.Find(productPartList[i].partid); partDerived tempDerivedPart = new partDerived(); tempDerivedPart.zproductpartid = productPartList[i].productpartid; tempDerivedPart.name = partTemp.name; tempDerivedPart.instock = partTemp.instock; tempDerivedPart.max = partTemp.max; tempDerivedPart.min = partTemp.min; tempDerivedPart.partid = partTemp.partid; tempDerivedPart.price = partTemp.price; tempDerivedPart.type = partTemp.type; tempDerivedPart.createdby = partTemp.createdby; tempDerivedPart.details = partTemp.details; tempDerivedPart.lastmodified = partTemp.lastmodified; //partDerived tempDerived = (partDerived)partTemp; //cast operation instead? tempList.Add(tempDerivedPart); } return(tempList); } }
public static bool ModifyProductImproved(productsdb product, List <partsdb> partsList, List <productspart> originalParts) { using (var con = new InventoryMgmtEntities()) { //Update Part Details productsdb productTemp = con.productsdbs.Find(product.productid);; productTemp.name = product.name; productTemp.min = product.min; productTemp.max = product.max; productTemp.instock = product.instock; productTemp.price = product.price; productTemp.lastmodified = DateTime.Now; //Split list into associated parts that already exist and new parts List <partDerived> partDerivedList = new List <partDerived>(); List <partsdb> realParts = new List <partsdb>(); for (int i = 0; i < partsList.Count(); i++) { if (partsList[i].GetType() == typeof(partDerived)) { partDerived tempPart = (partDerived)(object)partsList[i]; partDerivedList.Add(tempPart); } else { realParts.Add(partsList[i]); } } //Take original list and derived part list, where there is a match remove part from partListfinal List <productspart> partListFinal = originalParts; for (int i = 0; i < originalParts.Count(); i++) { for (int j = 0; j < partDerivedList.Count(); j++) { if (originalParts[i].productpartid == partDerivedList[j].zproductpartid) { partListFinal.RemoveAll(u => u.productpartid == (int)partDerivedList[j].zproductpartid); } } var temp = partListFinal; } //Remove all productparts from the db that are in the list partListFinal if (partListFinal.Count() > 0) { for (int k = 0; k < partListFinal.Count(); k++) { productspart tempProductPart = con.productsparts.Find(partListFinal[k].productpartid); con.productsparts.Remove(tempProductPart); } } //Add new associated parts for (int l = 0; l < realParts.Count(); l++) { productspart temp = new productspart(); temp.productid = product.productid; temp.partid = realParts[l].partid; con.productsparts.Add(temp); } con.SaveChanges(); return(true); } }