public void PopulateAccountTypesDropdown(object selectedAccountTypes = null)
{
MilkCRMv0_12Entities entities = new MilkCRMv0_12Entities();
var ut = entities.UserTypes.Select(s => new { UserTypeId = s.UserTypeId, Description = s.Description });
ViewBag.UserTypeID = new SelectList(ut, "UserTypeId", "Description", selectedAccountTypes);
}
public void PopulateSuppliersDropdown(object selectedSuppliers = null)
{
MilkCRMv0_12Entities entities = new MilkCRMv0_12Entities();
var sup = entities.Suppliers.Select(s => new { SupplierID = s.SupplierID, CompanyName = s.CompanyName });
ViewBag.SupplierID = new SelectList(sup, "SupplierID", "CompanyName", selectedSuppliers);
}
public void PopulateCategoriesDropdown(object selectedCategories = null)
{
MilkCRMv0_12Entities entities = new MilkCRMv0_12Entities();
var ent = entities.Categories.Select(s => new { CategoryID = s.CategoryID, CategoryName = s.CategoryName });
ViewBag.CategoryID = new SelectList(ent, "CategoryID", "CategoryName", "selectedCategories");
}
public void ProcessRequest(HttpContext context)
{
// CategoriesBLL bll = new CategoriesBLL();
MilkCRMv0_12Entities db = new MilkCRMv0_12Entities();
context.Response.ContentType = "Image/gif";
var param = context.Request.QueryString[0];
int id = 0;
byte[] image = null;
if (param != null && int.TryParse(param, out id))
{
image = db.Categories.Where(a => a.CategoryID.Equals(id)).FirstOrDefault().Picture;
}
context.Response.BinaryWrite(image);
}
public UserTypesDAL()
{
db = new MilkCRMv0_12Entities();
}
public Orders_QryDAL()
{
db = new MilkCRMv0_12Entities();
}
public SuppliersDb()
{
db = new MilkCRMv0_12Entities();
}
public ProductsController()
{
db = new AdminBLL();
entities = new MilkCRMv0_12Entities();
}
public ProductsDb()
{
entities = new MilkCRMv0_12Entities();
}
public CategoriesDb()
{
db = new MilkCRMv0_12Entities();
}
public EmployeesDb()
{
db = new MilkCRMv0_12Entities();
}
public UserAccountsDAL()
{
entities = new MilkCRMv0_12Entities();
}
public SalesbycategoriesDb()
{
db = new MilkCRMv0_12Entities();
}
public OrdersDB()
{
db = new BOL.MilkCRMv0_12Entities();
}
public CustomersDb()
{
db = new MilkCRMv0_12Entities();
}
public SalestotalsbyamountDb()
{
db = new MilkCRMv0_12Entities();
}
public OrdersController()
{
db = new AdminBLL();
ent = new MilkCRMv0_12Entities();
}
