public static List <PromoItemsVM> GetPromotionItems() { List <PromoItemsVM> lstitems = new List <PromoItemsVM>(); try { using (var context = new SCMEntity()) { var rtnmodel = (from s in context.PromoItems join i in context.Items on s.ItemId equals i.ItemId orderby i.ItemName select new PromoItemsVM { ItemId = s.ItemId, PromoItemId = s.PromoItemId, ItemName = i.ItemName, PromotionalQty = s.PromotionalQty, FixedPrice = s.FixedPrice, GroupId = s.GroupId ?? 0 }).ToList(); return(rtnmodel); } } catch (Exception ex) { return(lstitems); } }
public static List <Item> GetItems() { List <Item> lstitems = new List <Item>(); try { using (var context = new SCMEntity()) { var rtnmodel = context.Items.OrderBy(x => x.ItemName).ToList(); return(rtnmodel); } } catch (Exception exe) { return(lstitems); } }
public HomeController(SCMEntity sCMEntity) { this.sCMEntity = sCMEntity; }