Webform追加削除

1209 ワード

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
/// CarDA  
/// </summary>
public class CarDA
{
    private DataClassesDataContext Context;
	public CarDA()
	{
		Context=new DataClassesDataContext ();
	}
    public List<Car>Select()
    {
        return Context.Car.ToList();
    }
    public Car Select(string code)
    {
        return Context.Car.Where(p => p.Code == code).First();
    }
    public void Delete(string code)
    {
        Context.Car.DeleteOnSubmit(Context.Car.Where(p => p.Code == code).First());
        Context.SubmitChanges();
    }
    public void update(Car data)
    {
        Car dt = Context.Car.Where(p => p.Code == data.Code).First();
        dt.Brand = data.Brand;
        dt.Name = data.Name;
        Context.SubmitChanges();
    }
    public void insert(Car data)
    {
        Context.Car.InsertOnSubmit(data);
        Context.SubmitChanges();
    }
}