public IEnumerable <Size> GetAllSizesByDepartment(int depId)
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.SizeDepartments.Where(sd => sd.DepartmentId == depId).Select(i => i.Size).ToList());
}
}
public ProductCategory GetProductCategoryByName(string name)
{
using (ProductionDataContext db = new ProductionDataContext())
{
return(db.ProductCategories.SingleOrDefault(productCategory => productCategory.Name == name));
}
}
public IEnumerable <Material> GetAllMaterials()
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.Materials.ToList());
}
}
public IEnumerable <BodyStyle> GetAllStyles()
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.BodyStyles.ToList());
}
}
public IEnumerable <Color> GetAllColors()
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.Colors.ToList());
}
}
public IEnumerable <Department> GetDepartments()
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.Departments.ToList());
}
}
public bool CheckIfItemIsInProduction(Item item)
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.ProductionDetails.Where(p => p.ItemId == item.Id).Any());
}
}
public DateTime LastDateOfProductionPerItem(Item item)
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.ProductionDetails.Where(p => p.ItemId == item.Id).OrderByDescending(p => p.Production.Date).First().Production.Date);
}
}
public IEnumerable <Item> GetAllItemsInProduction()
{
using (var context = new ProductionDataContext(_connectionString))
{
return(context.Items.ToList());
}
}
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 void AddItem(Item item)
{
using (var context = new ProductionDataContext(_connectionString))
{
context.Items.InsertOnSubmit(item);
context.SubmitChanges();
}
}
public void AddColors(IEnumerable <Color> colors)
{
using (var context = new ProductionDataContext(_connectionString))
{
context.Colors.InsertAllOnSubmit(colors);
context.SubmitChanges();
}
}
public Location GetLocation(short id)
{
using (ProductionDataContext db = new ProductionDataContext())
{
Location result = db.Location.FirstOrDefault(loc => loc.LocationID == id);
return(result);
}
}
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 ProductCategory GetProductCategoryById(int id)
{
using (ProductionDataContext db = new ProductionDataContext())
{
ProductCategory output = db.ProductCategories.SingleOrDefault(productCategory => productCategory.ProductCategoryID == id);
return(output);
}
}
public void AddProductCategory(ProductCategory productCategory)
{
using (ProductionDataContext db = new ProductionDataContext())
{
db.ProductCategories.InsertOnSubmit(productCategory);
db.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 static void AddProduct(Product p)
{
using (ProductionDataContext productionDataContext = new ProductionDataContext())
{
productionDataContext.Product.InsertOnSubmit(p);
productionDataContext.SubmitChanges();
}
}
public static void RemoveProduct(Product p)
{
using (ProductionDataContext productionDataContext = new ProductionDataContext())
{
productionDataContext.Product.DeleteOnSubmit(p);
productionDataContext.SubmitChanges();
}
}
public static int GetTotalStandardCostByCategory(ProductCategory category)
{
ProductionDataContext db = new ProductionDataContext();
return((int)(from product in db.Products
where product.ProductSubcategory.ProductCategory.Name == category.Name
select product.StandardCost).Sum());
}
public static string GetProductVendorByProductName(string productName)
{
ProductionDataContext db = new ProductionDataContext();
return((from product in db.Products
join productVendor in db.ProductVendors on product.ProductID equals productVendor.ProductID
where product.Name == productName
select productVendor.Vendor.Name).First());
}
public IEnumerable <Sleeve> AddSleeves(List <Sleeve> sleeve)
{
using (var context = new ProductionDataContext(_connectionString))
{
context.Sleeves.InsertAllOnSubmit(sleeve);
context.SubmitChanges();
return(sleeve);
}
}
public static List <Product> GetAllProducts()
{
using (ProductionDataContext productionDataContext = new ProductionDataContext())
{
return((
from p in productionDataContext.Product
select p).ToList());
}
}
public static List <Product> GetProductsWithNRecentReviews(int howManyReviews)
{
ProductionDataContext db = new ProductionDataContext();
return(new List <Product>(from product in db.Products
where product.ProductReviews.Count == howManyReviews
select product
));
}
public static List <string> GetSizeUnits()
{
using (ProductionDataContext productionDataContext = new ProductionDataContext())
{
List <string> response = new List <string>();
productionDataContext.Product.GroupBy(x => x.SizeUnitMeasureCode).Select(g => g.First()).ToList().ForEach(x => response.Add(x.SizeUnitMeasureCode));
return(response);
}
}
public static List <string> GetModels()
{
using (ProductionDataContext productionDataContext = new ProductionDataContext())
{
List <string> response = new List <string>();
productionDataContext.Product.GroupBy(x => x.ProductModelID).Select(g => g.First()).ToList().ForEach(x => response.Add(x.ProductModelID.ToString()));
return(response);
}
}
public static List <string> GetSubcategories()
{
using (ProductionDataContext productionDataContext = new ProductionDataContext())
{
List <string> response = new List <string>();
productionDataContext.Product.GroupBy(x => x.ProductSubcategory).Select(g => g.First()).ToList().ForEach(x => response.Add(x.ProductSubcategoryID == null ? null : x.ProductSubcategoryID.ToString()));
return(response);
}
}
public static List <Product> GetProductsByName(string namePart)
{
ProductionDataContext dataContext = new ProductionDataContext();
return(new List <Product>(from product in dataContext.Products
where product.Name.Contains(namePart)
orderby product.ProductID descending
select product));
}
