public void Create(SimpleStateGridView model) { var state = new SavedFilter { Name = model.Name, FilterKey = model.Key, Data = Encoding.UTF8.GetBytes(model.FilterRawOptions) }; _dc.SavedFilters.Add(state); _dc.SaveChanges(); }
private void DeleteProduct() { var productID = Convert.ToInt32(ProductID); using (NorthwindDataContext db = new NorthwindDataContext()) { var product = db.Products.FirstOrDefault(p => p.ProductID == productID); db.Products.Remove(product); db.SaveChanges(); } }
static void Main(string[] args) { //NorthwindDataContext context = new NorthwindDataContext(new Uri("http://localhost:12345/Northwind.svc")); NorthwindDataContext context = new NorthwindDataContext(new Uri("http://localhost:54321/Northwind.svc")); var order = (from o in context.Orders.Expand("Order_Details") where o.OrderID == 10248 select o).FirstOrDefault(); var item = order.Order_Details.FirstOrDefault(); item.Quantity += 1; context.UpdateObject(item); context.SaveChanges(); context.DeleteObject(item); context.SaveChanges(); context.AddRelatedObject(order, "Order_Details", item); context.SaveChanges(); }
public void Create(GridStateView model) { var bf = new BinaryFormatter(); var options = GetActionGridOptions(model.ActionGridRawOptions); using (var ms = new MemoryStream()) { bf.Serialize(ms, options); var data = ms.ToArray(); if (model.GridStateId.HasValue) { var gridState = _dc.SavedFilters.First(x => x.Id == model.GridStateId && x.FilterKey == model.GridKey); gridState.Name = model.Name; gridState.Data = data; _dc.SaveChanges(); } else { var gridState = new SavedFilter() { Data = data, FilterKey = model.GridKey, Name = model.Name }; _dc.SavedFilters.Add(gridState); _dc.SaveChanges(); model.GridStateId = gridState.Id; } } }
private void UpdateProduct() { var productID = Convert.ToInt32(ProductID); int unitsInStock = txtInStock.Text != string.Empty ? Convert.ToInt32(txtInStock.Text) : 0; decimal unitPrice = txtUnitPrice.Text != string.Empty ? Convert.ToDecimal(txtUnitPrice.Text) : 0.0m; using (NorthwindDataContext db = new NorthwindDataContext()) { var product = db.Products.FirstOrDefault(p => p.ProductID == productID); product.CategoryID = Convert.ToInt32(ddlCategories.SelectedValue); product.ProductName = txtProductName.Text; product.Discontinued = chkDiscontinued.Checked ? true : false; product.UnitsInStock = (short)unitsInStock; product.UnitPrice = unitPrice; db.SaveChanges(); } }
private void AddNewProduct() { int unitsInStock = txtInStock.Text != string.Empty ? Convert.ToInt32(txtInStock.Text) : 0; decimal unitPrice = txtUnitPrice.Text != string.Empty ? Convert.ToDecimal(txtUnitPrice.Text) : 0.0m; Products product = new Products() { CategoryID = Convert.ToInt32(ddlCategories.SelectedValue), ProductName = txtProductName.Text, Discontinued = chkDiscontinued.Checked ? true : false, UnitsInStock = (short)unitsInStock, UnitPrice = unitPrice }; using (NorthwindDataContext db = new NorthwindDataContext()) { db.Products.Add(product); db.SaveChanges(); } }