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();
}
}
