?using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;

// NOTE: If you change the class name "Service" here, you must also update the reference to "Service" in Web.config.
public class Service : IService
{


    #region IService Members
    //獲取通訊錄表
    public List<addresslist> GetAllAddress()
    {
        DataClassesDataContext db = new DataClassesDataContext();
        var add = from a in db.addresslists
                  select a;
        return add.ToList<addresslist>();
    }
    //存入一個電話記錄
    public addresslist SaveAAddress(addresslist address)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        if (address.編號 > 0)
        {
            db.addresslists.Attach(address, true);
        }
        else { db.addresslists.InsertOnSubmit(address); }
        db.SubmitChanges();
        return address;
    }
    //獲取圖書館書籍
    public List<librarylist> GetAllBooks()
    {
        DataClassesDataContext db = new DataClassesDataContext();
        var book = from b in db.librarylists
                   select b;
        return book.ToList<librarylist>();
    }
    //根據書名查詢書籍
    public List<librarylist> GetBookWithName(string bookname)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        var book = from b in db.librarylists
                   where b.書名==bookname
                   select b;
        return book.ToList<librarylist>();
    }
    //根據編號查詢書籍

    public List<librarylist> GetBookWithMark(string marknum)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        var book = from b in db.librarylists
                   where b.書標號 == marknum
                   select b;
        return book.ToList<librarylist>();
    }
    //根據作者查詢書籍
    public List<librarylist> GetBookWithAuthor(string author)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        var book = from b in db.librarylists
                   where b.作者 == author
                   select b;
        return book.ToList<librarylist>();
    }
    //根據姓名刪除聯系人

    public void DeleteAAdd(string name)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        var result = from r in db.addresslists
                     where r.姓名 == name
                     select r;
        db.addresslists.DeleteAllOnSubmit(result);
        db.SubmitChanges();
    }
    #endregion
}