public void InitializeDropDowns(string mode)
{
using (FreeMarketEntities db = new FreeMarketEntities())
{
if (mode == "edit")
{
Departments = db.Departments
.Select(c => new SelectListItem
{
Text = "(" + c.DepartmentNumber + ") " + c.DepartmentName,
Value = c.DepartmentNumber.ToString(),
Selected = (c.DepartmentNumber == DepartmentNumber) ? true : false
})
.ToList();
Custodians = db.Custodians
.Select(c => new SelectListItem
{
Text = "(" + c.CustodianNumber + ") " + c.CustodianName,
Value = c.CustodianNumber.ToString(),
Selected = c.CustodianNumber == SelectedCustodianNumber ? true : false
})
.ToList();
}
else
{
Departments = db.Departments
.Select(c => new SelectListItem
{
Text = "(" + c.DepartmentNumber + ") " + c.DepartmentName,
Value = c.DepartmentNumber.ToString(),
})
.ToList();
}
if (mode == "create")
{
Suppliers = db.Suppliers
.Select(c => new SelectListItem
{
Text = "(" + c.SupplierNumber + ") " + c.SupplierName,
Value = c.SupplierNumber.ToString()
})
.ToList();
Custodians = db.Custodians
.Select(c => new SelectListItem
{
Text = "(" + c.CustodianNumber + ") " + c.CustodianName,
Value = c.CustodianNumber.ToString(),
})
.ToList();
SizeVariations = ProductSize.GetNewProductSizes();
}
}
}
public static Product GetNewProduct()
{
Product product = new Product();
product.DateAdded = DateTime.Now;
using (FreeMarketEntities db = new FreeMarketEntities())
{
product.Departments = db.Departments
.Select(c => new SelectListItem
{
Text = "(" + c.DepartmentNumber + ")" + c.DepartmentName,
Value = c.DepartmentNumber.ToString()
})
.ToList();
product.Suppliers = db.Suppliers
.Select(c => new SelectListItem
{
Text = "(" + c.SupplierNumber + ")" + c.SupplierName,
Value = c.SupplierNumber.ToString()
})
.ToList();
product.Custodians = db.Custodians
.Select(c => new SelectListItem
{
Text = "(" + c.CustodianNumber + ") " + c.CustodianName,
Value = c.CustodianNumber.ToString(),
})
.ToList();
product.SizeVariations = ProductSize.GetNewProductSizes();
}
return(product);
}
public static Product GetShallowProduct(int productNumber, int supplierNumber)
{
Product product = new Product();
using (FreeMarketEntities db = new FreeMarketEntities())
{
var productInfo = db.GetShallowProduct(productNumber, supplierNumber)
.FirstOrDefault();
product = new Product
{
Activated = productInfo.Activated,
DateAdded = productInfo.DateAdded,
DateModified = productInfo.DateModified,
DepartmentName = productInfo.DepartmentName,
DepartmentNumber = productInfo.DepartmentNumber,
Description = productInfo.Description,
PricePerUnit = productInfo.PricePerUnit,
ProductNumber = productInfo.ProductNumber,
Size = "",
SupplierName = productInfo.SupplierName,
SupplierNumber = productInfo.SupplierNumberID,
SpecialPricePerUnit = productInfo.SpecialPricePerUnit ?? productInfo.PricePerUnit,
RetailPricePerUnit = productInfo.RetailPricePerUnit ?? productInfo.PricePerUnit,
Weight = 0,
LongDescription = productInfo.LongDescription,
IsVirtual = productInfo.IsVirtual
};
product.SelectedCustodianNumber = db.ProductCustodians
.Where(c => c.ProductNumber == product.ProductNumber && c.SupplierNumber == product.SupplierNumber)
.FirstOrDefault()
.CustodianNumber;
product.MainImageNumber = db.ProductPictures
.Where(c => c.ProductNumber == product.ProductNumber && c.Dimensions == PictureSize.Medium.ToString())
.Select(c => c.PictureNumber)
.FirstOrDefault();
product.SecondaryImageNumber = db.ProductPictures
.Where(c => c.ProductNumber == product.ProductNumber && c.Dimensions == PictureSize.Small.ToString())
.Select(c => c.PictureNumber)
.FirstOrDefault();
product.AdditionalImageNumber = db.ProductPictures
.Where(c => c.ProductNumber == product.ProductNumber && c.Dimensions == PictureSize.Large.ToString())
.Select(c => c.PictureNumber)
.FirstOrDefault();
product.Departments = db.Departments
.Select(c => new SelectListItem
{
Text = "(" + c.DepartmentNumber + ") " + c.DepartmentName,
Value = c.DepartmentNumber.ToString(),
Selected = c.DepartmentNumber == product.DepartmentNumber ? true : false
})
.ToList();
product.Custodians = db.Custodians
.Select(c => new SelectListItem
{
Text = "(" + c.CustodianNumber + ") " + c.CustodianName,
Value = c.CustodianNumber.ToString(),
Selected = c.CustodianNumber == product.SelectedCustodianNumber ? true : false
})
.ToList();
product.SizeVariations = ProductSize.GetExistingProductSizes(productNumber, supplierNumber);
}
return(product);
}