public void AddExpense(Expense expense)
{
using (var context = new TruckDataContext(@"Data Source=.\sqlexpress;Initial Catalog=Truck;Integrated Security=True"))
{
context.Expenses.InsertOnSubmit(expense);
context.SubmitChanges();
}
}
public void AddProduct(Product p)
{
using (var context = new TruckDataContext(@"Data Source=.\sqlexpress;Initial Catalog=Truck;Integrated Security=True"))
{
context.Products.InsertOnSubmit(p);
context.SubmitChanges();
}
}
public void AddStock(AddStock addStock)
{
using (var context = new TruckDataContext(@"Data Source=.\sqlexpress;Initial Catalog=Truck;Integrated Security=True"))
{
context.AddStocks.InsertOnSubmit(addStock);
context.SubmitChanges();
}
}
public void UpdateExpense(Expense e)
{
using (var context = new TruckDataContext(@"Data Source=.\sqlexpress;Initial Catalog=Truck;Integrated Security=True"))
{
context.Expenses.Attach(e);
context.Refresh(RefreshMode.KeepCurrentValues, e);
context.SubmitChanges();
}
}
public void DeleteExpense(int id)
{
using (var context = new TruckDataContext(@"Data Source=.\sqlexpress;Initial Catalog=Truck;Integrated Security=True"))
{
var expense = context.Expenses.FirstOrDefault(e => e.Id == id);
context.Expenses.DeleteOnSubmit(expense);
context.SubmitChanges();
}
}
public void DeleteStock(int id)
{
using (var context = new TruckDataContext(@"Data Source=.\sqlexpress;Initial Catalog=Truck;Integrated Security=True"))
{
var Stock = context.AddStocks.FirstOrDefault(s => s.Id == id);
context.AddStocks.DeleteOnSubmit(Stock);
context.SubmitChanges();
}
}
public void UpdateStock(AddStock a)
{
using (var context = new TruckDataContext(@"Data Source=.\sqlexpress;Initial Catalog=Truck;Integrated Security=True"))
{
context.AddStocks.Attach(a);
context.Refresh(RefreshMode.KeepCurrentValues, a);
context.SubmitChanges();
}
}