public void AddBookTagBook(Int32 bookTag_Id, Int32 book_Id)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddBookTagBook(bookTag_Id, book_Id);
}
}
public void AddBookAuthor(Int32 book_Id, Int32 author_Id)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddBookAuthor(book_Id, author_Id);
}
}
public void AddPublisherBook(Int32 publisher_Id, Int32 book_Id)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddPublisherBook(publisher_Id, book_Id);
}
}
public void Edit(BookVariableInfo bookVariableInfo)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.EditBookVariableInfo(bookVariableInfo.Id,
bookVariableInfo.ProductCount, bookVariableInfo.Price);
}
}
public void Edit(UserProfile newUserProfile)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.EditUserProfile(newUserProfile.UserId, newUserProfile.UserName,
newUserProfile.IndividualId);
}
}
public object FindIndividualByUserProfileName(string userProfileName)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
var items = db.FindIndividualByUserProfileName(userProfileName);
var item = items.FirstOrDefault();
return item;
}
}
//BookVariableInfo и Book связь 1:1
public BookVariableInfo FindByBookId(Int32 id)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
var items = db.FindBookVariableInfoByBookId(id);
var item = items.FirstOrDefault<BookVariableInfo>();
return item;
}
}
public object FindById(Int32 id)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
var items = db.FindAuthorById(id);
var item = items.FirstOrDefault();
return item;
}
}
//BasketItem basketItem)
public void Delete(Int32 basketItemId)
{
BasketItem oldBasketItem;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.DeleteBasketItem(basketItemId);
}
}
public Publisher FindByName(string name)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
var items = db.FindPublisherByName(name);
var item = items.FirstOrDefault<Publisher>();
return item;
}
}
public object Add(object item)
{
Publisher publisher = (Publisher)item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddPublisher(publisher.Name);
}
return GetAll().publishers.Last();
}
public void Edit(W1Payment newW1Payment)
{
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.EditW1Payment(newW1Payment.WMI_PAYMENT_NO,
newW1Payment.WMI_MERCHANT_ID, newW1Payment.WMI_CURRENCY_ID,
newW1Payment.WMI_DESCRIPTION, newW1Payment.WMI_EXPIRED_DATE,
newW1Payment.WMI_PAYMENT_AMOUNT, newW1Payment.WMI_SIGNATURE);
}
}
public object Add(object item)
{
Language language = (Language)item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddLanguage(language.Name);
}
return GetAll().languages.Last();
}
public object FindById(Int32 id)
{
//var item = this._db.WebMoneys.Find(id);
using (BookMarketDbContext db = new BookMarketDbContext())
{
var items = db.FindWebmoneyById(id);
var item = items.FirstOrDefault();
return item;
}
}
public object Add(object item)
{
Author author = (Author)item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddAuthor(author.LastName, author.FirstName);
}
return GetAll().authors.Last();
}
//oldPayment и newPayment указывают на один и тот же экземпляр, но
//для надежности оставлю обмен значений полей
public void Edit(Payment newPayment)
{
Payment oldPayment;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.EditPayment(newPayment.Id, newPayment.isPayed,
newPayment.ShopId, newPayment.IndividualId);
}
}
public object Add(object item)
{
City city = (City)item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddCity(city.Name);
}
return GetAll().cities.Last();
}
public void Edit(BasketItem newBasketItem)
{
BasketItem oldBasketItem;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.EditBasketItem(newBasketItem.Id, newBasketItem.Amount,
newBasketItem.ItemCount, newBasketItem.BookVariableInfoId,
newBasketItem.BasketId, newBasketItem.PaymentId);
}
}
public object Add(object item)
{
BookTag bookTag = (BookTag)item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddBookTag(bookTag.Name, bookTag.BookTypeId);
}
return GetAll().bookTags.Last();
}
public object Add(object item)
{
Book book = (Book)item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
var ret = db.AddBook(book.Name, book.Year, book.PageCount, book.ImageName,
book.Description, book.LanguageId);
}
return GetAll().books.Last();
}
public UserProfile FindByUserName(string userName)
{
UserProfile item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
var items = db.FindUserProfileByUserName(userName).ToList();
item = items.FirstOrDefault<UserProfile>();
return item;
}
}
public object Add(object item)
{
BookVariableInfo bookVariableInfo = (BookVariableInfo)item;
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddBookVariableInfo(bookVariableInfo.Id,
bookVariableInfo.ProductCount, bookVariableInfo.Price);
}
return GetAll().bookVariableInfoes.Last();
}
public object Add(object item)
{
WebMoney webmoney = (WebMoney)item;
/*this._db.WebMoneys.Add(webmoney);
this._db.SaveChanges();*/
using (BookMarketDbContext db = new BookMarketDbContext())
{
db.AddWebMoney(webmoney.WMR, webmoney.IndividualId);
}
return GetAll().webmoneys.Last();
}
public IList<Author> FindAllAuthorsByBook(Int32 bookId)
{
IList<Author> books;
books = new List<Author>();
using (BookMarketDbContext db = new BookMarketDbContext())
{
foreach (var entry in db.FindAllAuthorsByBook(bookId))
books.Add(entry);
}
return books;
}
public IList<BookTag> FindBookTagsByBook(Int32 bookId)
{
List<BookTag> bookTags;
bookTags = new List<BookTag>();
using (BookMarketDbContext db = new BookMarketDbContext())
{
foreach (var entry in db.FindBookTagsByBook(bookId))
bookTags.Add(entry);
}
return bookTags;
}
public IList<Publisher> FindAllByBook(Int32 bookId)
{
IList<Publisher> items;
items = new List<Publisher>();
using (BookMarketDbContext db = new BookMarketDbContext())
{
foreach (var entry in db.FindPublishersByBook(bookId))
items.Add(entry);
}
return items;
}
//Так как связь City и Address 1:1, то ищем адрес по Id Shop
public IList<Shop> FindAllByCity(Int32 cityId)
{
IList<Shop> items;
items = new List<Shop>();
using (BookMarketDbContext db = new BookMarketDbContext())
{
foreach (var entry in db.FindAllShopsByCity(cityId))
items.Add(entry);
}
return items;
}
public IList<string> GetNames()
{
List<string> names;
names = new List<string>();
using (BookMarketDbContext db = new BookMarketDbContext())
{
foreach (var entry in db.GetShopNames())
names.Add(entry);
}
return names;
}
public IList<BasketItem> FindBasketItemsByPayment(Int32 paymentId)
{
IList<BasketItem> items;
items = new List<BasketItem>();
using (BookMarketDbContext db = new BookMarketDbContext())
{
foreach (var entry in db.FindBasketItemsByPayment(paymentId))
items.Add(entry);
}
return items;
}
public ModelToModel GetAll()
{
ModelToModel mm;
mm = new ModelToModel();
mm.authors = new List<Author>();
using (BookMarketDbContext db = new BookMarketDbContext())
{
foreach (var entry in db.GetAllAuthors())
mm.authors.Add(entry);
}
return mm;
}
