public FrontierAg.Models.Shipping GetItem3([FriendlyUrlSegmentsAttribute(2)] int ShippingId)
{
using (FrontierAg.Models.ProductContext _db = new FrontierAg.Models.ProductContext())
{
return(_db.Shippings.Where(m => m.ShippingId == ShippingId).FirstOrDefault());
}
}
public IQueryable <Category> GetCategories()
{
var _db = new FrontierAg.Models.ProductContext();
IQueryable <Category> query = _db.Categories;
return(query);
}
public FrontierAg.Models.Contact GetItem([FriendlyUrlSegmentsAttribute(0)] int ContactId)
{
using (FrontierAg.Models.ProductContext _db = new FrontierAg.Models.ProductContext())
{
return(_db.Contacts.Where(m => m.ContactId == ContactId).FirstOrDefault());
}
}
public IQueryable <Order> OrdersList_GetData([FriendlyUrlSegmentsAttribute(0)] int?ContactId)
{
if (ContactId != null)
{
FrontierAg.Models.ProductContext _db = new FrontierAg.Models.ProductContext();
return(_db.Orders.Include(m => m.OrderShippings.Select(en => en.Shipping)).Where(en => en.ContactId == ContactId));
}
return(null);
}
// The return type can be changed to IEnumerable, however to support
// paging and sorting, the following parameters must be added:
// int maximumRows
// int startRowIndex
// out int totalRowCount
// string sortByExpression
public IQueryable <FrontierAg.Models.PackCharge> PackchargeGrid_GetData([FriendlyUrlSegmentsAttribute(0)] int?productId)
{
var _db = new FrontierAg.Models.ProductContext();
IQueryable <PackCharge> query = _db.PackCharges;
if (productId.HasValue && productId > 0)
{
query = query.Where(p => p.ProductId == productId);
}
else
{
query = null;
}
return(query);
}
public void addPriceForm_InsertItem()
{
var item = new FrontierAg.Models.Price();
TryUpdateModel(item);
if (ModelState.IsValid)
{
// Save changes here
using (FrontierAg.Models.ProductContext db = new FrontierAg.Models.ProductContext())
{
db.Prices.Add(item);
db.SaveChanges();
}
}
}
public void addProductForm_InsertItem()
{
var item = new FrontierAg.Models.Product();
TryUpdateModel(item);
if (ModelState.IsValid)
{
// Save changes here
using (FrontierAg.Models.ProductContext db = new FrontierAg.Models.ProductContext())
{
item.DateCreated = DateTime.Now;
db.Products.Add(item);
db.SaveChanges();
}
}
}
public IQueryable <Product> GetProducts([FriendlyUrlSegmentsAttribute(0)] int?categoryId, [FriendlyUrlSegmentsAttribute(1)] String searchString)
{
var _db = new FrontierAg.Models.ProductContext();
IQueryable <Product> query = _db.Products;
if (categoryId.HasValue && categoryId > 0)
{
return(query = query.Where(p => p.CategoryId == categoryId));
}
else if (!String.IsNullOrEmpty(searchString))
{
return(query = query.Where(s => s.ProductNo.Contains(searchString) || s.ProductName.Contains(searchString)));
}
return(query);
}