public List<Items> ReadList(string sortmode, string filter) { List<Items> tmp = new List<Items>(); try { OrderSystemEntities database = new OrderSystemEntities(); if (filter == "") { tmp = database.Items.Where<Items>(rec => rec.Quantity > 0).ToList<Items>(); } else switch (sortmode) { case "name": { tmp = database.Items.Where<Items>(rec => rec.ItemName.ToLower().Contains(filter.ToLower()) && rec.Quantity > 0).ToList<Items>(); break; } case "description": { tmp = database.Items.Where<Items>(rec => rec.ItemDescriprion.ToLower().Contains(filter.ToLower()) && rec.Quantity > 0).ToList<Items>(); break; } } database.Dispose(); } catch (Exception ex) { Session["err"] = ex.Message.ToString(); } return tmp; }
public void OutRecord(ItemsOrder tmp) { try { OrderSystemEntities database = new OrderSystemEntities(); database.ItemsOrder.AddObject(tmp); int t = database.SaveChanges(); if (t <= 0) { // ErroredSoft(); } database.Dispose(); } catch (Exception ex) { Session["err"] = ex.Message.ToString(); // Errored(); } }