public bool Add(Product item) { try { item.ModifiedDate = DateTime.Today; item.rowguid = Guid.NewGuid(); production.GetTable <Product>().InsertOnSubmit(item); production.SubmitChanges(); return(true); } catch { return(false); } }
public static void UpdateProduct(int id, Product product) { using (ProductionDataContext productionDataContext = new ProductionDataContext()) { Product original = productionDataContext.GetTable <Product>().Single(p => p.ProductID == product.ProductID); original.Name = product.Name; original.ProductNumber = product.ProductNumber; original.MakeFlag = product.MakeFlag; original.FinishedGoodsFlag = product.FinishedGoodsFlag; original.Color = product.Color; original.SafetyStockLevel = product.SafetyStockLevel; original.ReorderPoint = product.ReorderPoint; original.StandardCost = product.StandardCost; original.ListPrice = product.ListPrice; original.Size = product.Size; original.SizeUnitMeasureCode = product.SizeUnitMeasureCode; original.WeightUnitMeasureCode = product.WeightUnitMeasureCode; original.Weight = product.Weight; original.DaysToManufacture = product.DaysToManufacture; original.ProductLine = product.ProductLine; original.Class = product.Class; original.Style = product.Style; original.ProductSubcategoryID = product.ProductSubcategoryID; original.ProductModelID = product.ProductModelID; original.SellStartDate = product.SellStartDate; original.SellEndDate = product.SellEndDate; original.DiscontinuedDate = product.DiscontinuedDate; original.ModifiedDate = DateTime.Today; productionDataContext.SubmitChanges(); } }
public static void UpdateProduct(Product product) { using (ProductionDataContext dataContext = new ProductionDataContext()) { Product testProduct = dataContext.Product.Single(p => p.ProductID.Equals(product.ProductID)); testProduct.Name = product.Name; testProduct.ProductNumber = product.ProductNumber; testProduct.MakeFlag = product.MakeFlag; testProduct.FinishedGoodsFlag = product.FinishedGoodsFlag; testProduct.Color = product.Color; testProduct.SafetyStockLevel = product.SafetyStockLevel; testProduct.ReorderPoint = product.ReorderPoint; testProduct.StandardCost = product.StandardCost; testProduct.ListPrice = product.ListPrice; testProduct.Size = product.Size; testProduct.SizeUnitMeasureCode = product.SizeUnitMeasureCode; testProduct.WeightUnitMeasureCode = product.WeightUnitMeasureCode; testProduct.Weight = product.Weight; testProduct.DaysToManufacture = product.DaysToManufacture; testProduct.ProductLine = product.ProductLine; testProduct.Class = product.Class; testProduct.Style = product.Style; testProduct.ProductSubcategoryID = product.ProductSubcategoryID; testProduct.ProductModelID = product.ProductModelID; testProduct.SellStartDate = product.SellStartDate; testProduct.SellEndDate = product.SellEndDate; testProduct.DiscontinuedDate = product.DiscontinuedDate; testProduct.ModifiedDate = DateTime.Today; dataContext.SubmitChanges(ConflictMode.ContinueOnConflict); } }
public static void RemoveProduct(Product p) { using (ProductionDataContext productionDataContext = new ProductionDataContext()) { productionDataContext.Product.DeleteOnSubmit(p); productionDataContext.SubmitChanges(); } }
public void AddColors(IEnumerable <Color> colors) { using (var context = new ProductionDataContext(_connectionString)) { context.Colors.InsertAllOnSubmit(colors); context.SubmitChanges(); } }
public static void cleanUp() { ProductionDataContext production = new ProductionDataContext(); Product product = production.Products.Where(p => p.ProductID == 316).First(); product.Name = "Blade"; production.SubmitChanges(); }
public void AddProductCategory(ProductCategory productCategory) { using (ProductionDataContext db = new ProductionDataContext()) { db.ProductCategories.InsertOnSubmit(productCategory); db.SubmitChanges(); } }
public void AddLocation(Location location) { using (ProductionDataContext db = new ProductionDataContext()) { db.Location.InsertOnSubmit(location); db.SubmitChanges(); } }
public void AddItems(IEnumerable <Item> items) { using (var context = new ProductionDataContext(_connectionString)) { context.Items.InsertAllOnSubmit(items); context.SubmitChanges(); } }
public void AddItem(Item item) { using (var context = new ProductionDataContext(_connectionString)) { context.Items.InsertOnSubmit(item); context.SubmitChanges(); } }
public static void AddProduct(Product p) { using (ProductionDataContext productionDataContext = new ProductionDataContext()) { productionDataContext.Product.InsertOnSubmit(p); productionDataContext.SubmitChanges(); } }
public static void DeleteProduct(Product product) { using (ProductionDataContext dataContext = new ProductionDataContext()) { Product current = dataContext.Product.Single(p => product.ProductID.Equals(p.ProductID)); dataContext.Product.DeleteOnSubmit(current); dataContext.SubmitChanges(ConflictMode.ContinueOnConflict); } }
public IEnumerable <BodyStyle> AddBodyStyles(List <BodyStyle> styles) { using (var context = new ProductionDataContext(_connectionString)) { context.BodyStyles.InsertAllOnSubmit(styles); context.SubmitChanges(); return(styles); } }
public IEnumerable <Sleeve> AddSleeves(List <Sleeve> sleeve) { using (var context = new ProductionDataContext(_connectionString)) { context.Sleeves.InsertAllOnSubmit(sleeve); context.SubmitChanges(); return(sleeve); } }
public void UpdateProductCategory(string name, int id) { using (ProductionDataContext db = new ProductionDataContext()) { ProductCategory output = db.ProductCategories.SingleOrDefault(productCategory => productCategory.ProductCategoryID == id); output.Name = name; db.SubmitChanges(); } }
public void DeleteProductCategory(int id) { using (ProductionDataContext db = new ProductionDataContext()) { ProductCategory output = db.ProductCategories.SingleOrDefault(productCategory => productCategory.ProductCategoryID == id); if (output != null) { db.ProductCategories.DeleteOnSubmit(output); db.SubmitChanges(); } } }
public void DeleteLocation(int id) { using (ProductionDataContext db = new ProductionDataContext()) { Location result = db.Location.FirstOrDefault(l => l.LocationID == id); if (result != null) { db.Location.DeleteOnSubmit(result); db.SubmitChanges(); } } }
public void UpdateLocation(int id, string name) { using (ProductionDataContext db = new ProductionDataContext()) { Location result = db.Location.FirstOrDefault(l => l.LocationID == id); if (result != null) { result.Name = name; result.ModifiedDate = DateTime.Today; db.SubmitChanges(); } } }