public int GetCount()
{
using (YesAlaMungoEntities context = DbContextFactory.Create())
{
return(context.Set <T>().Count());
}
}
public UsedBook SearchBook(Sell sell)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
var query = from x in context.SellUsedBooks
where x.SellID.Equals(sell.SellID)
select new
{
UsedBook = x.UsedBook,
Title = x.UsedBook.MetaDataBook.Title,
Writer = x.UsedBook.MetaDataBook.Writer,
Publisher = x.UsedBook.MetaDataBook.Publisher,
Price = x.UsedBook.MetaDataBook.Price,
ImagePath = x.UsedBook.MetaDataBook.Image
};
var list = query.ToList();
foreach (var item in list)
{
item.UsedBook.Title = item.Title;
item.UsedBook.Writer = item.Writer;
item.UsedBook.Publisher = item.Publisher;
item.UsedBook.Price = item.Price;
item.UsedBook.ImagePath = item.ImagePath;
}
return(list.ConvertAll(x => x.UsedBook).FirstOrDefault());
}
}
public List <MetaDataBook> Search(string eTitle, string eWriter, string ePublisher)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
var query = from x in context.MetaDataBooks
select x;
if (string.IsNullOrEmpty(eTitle) == false)
{
query = query.Where(x => x.Title.Contains(eTitle));
}
if (string.IsNullOrEmpty(eWriter) == false)
{
query = query.Where(x => x.Writer.Contains(eWriter));
}
if (string.IsNullOrEmpty(ePublisher) == false)
{
query = query.Where(x => x.Publisher.Contains(ePublisher));
}
List <MetaDataBook> books = query.ToList();
return(books);
}
}
public List <T> GetAll()
{
using (YesAlaMungoEntities context = DbContextFactory.Create())
{
// DbSet의 제약조건과 일치해야 한다.
return(context.Set <T>().ToList());
}
}
public void Delete(T entity)
{
using (YesAlaMungoEntities context = DbContextFactory.Create())
{
context.Entry(entity).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Insert(T entity)
{
using (YesAlaMungoEntities context = DbContextFactory.Create())
{
context.Set <T>().Add(entity);
context.SaveChanges();
}
}
public static YesAlaMungoEntities Create()
{
YesAlaMungoEntities context = new YesAlaMungoEntities();
context.Database.Log = Write;
return(context);
}
public List <Buy> Search2(string bookName, string cusID, DateTime?fromDate, DateTime?toDate)
{
using (YesAlaMungoEntities context = DbContextFactory.Create())
{
//var query = from x in context.Buys
// join y in context.UsedBooks on x.BuyID equals y.UsedBookID
// //join z in context.Customers on x.BuyerID equals z.CustomerID
// select new
// {
// Buy = x,
// BookTitle = y.MetaDataBook.Title,
// //BuyerLoginID = z.LoginID
// BuyerLoginID = x.Customer.LoginID
// };
var query = from x in context.BuyUsedBooks
// where x.Buy.BuyerID.Equals(cusID)
orderby x.BuyID
select new
{
BuyUsedBook = x,
BookTitle = x.UsedBook.MetaDataBook.Title,
//BuyerLoginID = z.LoginID
BuyerLoginID = x.Buy.Customer.LoginID,
};
if (string.IsNullOrEmpty(bookName) == false)
{
query = query.Where(y => y.BookTitle.Contains(bookName));
}
if (string.IsNullOrEmpty(cusID) == false)
{
query = query.Where(x => x.BuyUsedBook.Buy.BuyerLoginID.Contains(cusID));
}
if (fromDate.HasValue && toDate.HasValue)
{
query = query.Where(x => x.BuyUsedBook.Buy.OrderDate >= fromDate && x.BuyUsedBook.Buy.OrderDate <= toDate);
}
var list = query.ToList();
foreach (var item in list)
{
item.BuyUsedBook.Buy.Title = item.BookTitle;
item.BuyUsedBook.Buy.BuyerLoginID = item.BuyerLoginID;
}
return(list.ConvertAll(x => x.BuyUsedBook.Buy));
}
}
public bool Check(string id, string pw)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
var query = from x in context.Employees
where x.LoginID.Equals(id) && x.PassWord.Equals(pw)
select x;
return(query.Any());
}
}
public bool CheckId(string id)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
var query = from x in context.Customers
where x.LoginID.Equals(id)
select x;
return(query.Any());
}
}
public List <Customer> CheckUser(string id, string pw)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
var query = from x in context.Customers
where x.LoginID.Equals(id) && x.PassWord.Equals(pw)
select x;
return(query.ToList());
}
}
public List <Sell> Search(string sellerId, bool?bookChecked)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
//var query = from x in context.Sells
// join y in context.Customers on x.SellID equals y.CustomerID
//var query = from x in context.Sells
// join y in context.UsedBooks on x.SellID equals y.UsedBookID
// join z in context.Customers on x.SellID equals z.CustomerID
// select new
// {
// Sells = x,
// Customer =z,
// LoginID = z.LoginID,
// Title = y.MetaDataBook.Title,
// Quality = y.Quality,
// Price = y.MetaDataBook.Price
// };
var query = from x in context.SellUsedBooks
select new
{
Sells = x.Sell,
Customer = x.Sell.Customer,
LoginID = x.Sell.Customer.LoginID,
Title = x.UsedBook.MetaDataBook.Title,
Quality = x.UsedBook.Quality,
Price = x.UsedBook.MetaDataBook.Price
};
if (string.IsNullOrEmpty(sellerId) == false)
{
query = query.Where(x => x.Customer.LoginID.Equals(sellerId));
}
if (bookChecked != null)
{
query = query.Where(x => x.Sells.Checked == bookChecked);
}
var list = query.ToList();
foreach (var item in list)
{
item.Sells.Title = item.Title;
item.Sells.Quality = item.Quality;
item.Sells.Price = item.Price;
item.Sells.LoginID = item.LoginID;
}
return(list.ConvertAll(x => x.Sells));
}
}
public Customer Check(string id, string pw)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
var query = from x in context.Customers
where x.LoginID.Equals(id) && x.PassWord.Equals(pw)
select x;
var list = query.ToList();
return(list.FirstOrDefault());
}
}
public List <Buy> Search3(string cusID, string bookName)
{
using (YesAlaMungoEntities context = DbContextFactory.Create())
{
var query = from x in context.BuyUsedBooks
orderby x.BuyID
select new
{
BuyUsedBoos = x,
Buy = x.Buy,
UsedBook = x.UsedBook,
BuyerLoginID = x.Buy.Customer.LoginID,
BookTitle = x.UsedBook.MetaDataBook.Title,
BookWriter = x.UsedBook.MetaDataBook.Writer,
BookPublisher = x.UsedBook.MetaDataBook.Publisher,
BookQuality = x.UsedBook.Quality,
BookPricce = x.UsedBook.MetaDataBook.Price,
ImagePath = x.UsedBook.MetaDataBook.Image
};
if (string.IsNullOrEmpty(bookName) == false)
{
query = query.Where(y => y.BookTitle.Contains(bookName));
}
if (string.IsNullOrEmpty(cusID) == false)
{
query = query.Where(x => x.BuyerLoginID.Contains(cusID));
}
query = query.Where(x => x.Buy.InvoiceState == 0);
var list = query.ToList();
foreach (var item in list)
{
item.Buy.Title = item.BookTitle;
item.Buy.BuyerLoginID = item.BuyerLoginID;
item.Buy.Writer = item.BookWriter;
item.Buy.Pubilsher = item.BookPublisher;
item.Buy.Quality = item.BookQuality;
item.Buy.ImagePath = item.ImagePath;
item.Buy.Price = Discount.SalePrices(item.BookQuality, item.BookPricce);
}
return(list.ConvertAll(x => x.Buy));
}
}
public Employee Check(string id, string pw)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
var query = from x in context.Employees
where x.LoginID.Equals(id) && x.PassWord.Equals(pw)
select x;
var list = query.ToList();
if (list.Count() != 0)
{
return(list[0]);
}
else
{
return(null);
}
}
}
public List <Buy> Search(string cusId,
string title, DateTime?fromDate, DateTime?ToDate)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
/*
* 구매버튼을 눌렀을 경우
* 구매 동시에 *
*/
//var query = from x in context.Buys
// where x.UsedBooks
// select x;
//var productsInCategory = db.Categorys
// .Where(c => c.CategoryId == categoryId)
// .SelectMany(c => c.Products);
//var products = (from p in db.Product_Category
// join ProductTable pt on p.ID = pt.ProductID
//join Category c on c.ID = P.CategoryID
//select new
//{
// p.ID,
// p.Name,
// p.Description,
// p.Price
//}).ToList();
//buy 에서 title 과 customerId만 빼오면되는데.
//var query = from x in context.Buys
// join y in context.UsedBooks on x.BuyID equals y.UsedBookID
// where x.Customer.LoginID.Equals(cusId)
// select new
// {
// Buy = x,
// BuyerLoginID = x.Customer.LoginID,
// Title = y.MetaDataBook.Title,
// BookWriter = y.MetaDataBook.Writer
// };
var query = from x in context.BuyUsedBooks
where x.Buy.Customer.LoginID.Equals(cusId)
orderby x.Buy.BuyID
select new
{
Buy = x,
BuyerLoginID = x.Buy.Customer.LoginID,
Title = x.UsedBook.MetaDataBook.Title,
BookWriter = x.UsedBook.MetaDataBook.Writer
};
if (string.IsNullOrEmpty(title) == false)
{
query = query.Where(x => x.Title.Contains(title));
}
if (fromDate != null && ToDate != null)
{
query = query.Where(x => x.Buy.Buy.OrderDate >=
fromDate && x.Buy.Buy.OrderDate <= ToDate);
}
var list = query.ToList();
foreach (var item in list)
{
item.Buy.Buy.Title = item.Title;
item.Buy.Buy.BuyerLoginID = item.BuyerLoginID;
item.Buy.Buy.Writer = item.BookWriter;
}
//var list =context.UsedBooks.SelectMany (x => x.Buys);
// list.Where(x=>x.)
// var query = from VAR in
return(list.ConvertAll(x => x.Buy.Buy));
}
}
public List <Buy> Search(string cusId,
string title, DateTime?fromDate, DateTime?ToDate)
{
using (YesAlaMungoEntities context = new YesAlaMungoEntities())
{
/*
* 구매버튼을 눌렀을 경우
* 구매 동시에 *
*/
//var query = from x in context.Buys
// where x.UsedBooks
// select x;
//var productsInCategory = db.Categorys
// .Where(c => c.CategoryId == categoryId)
// .SelectMany(c => c.Products);
//var products = (from p in db.Product_Category
// join ProductTable pt on p.ID = pt.ProductID
//join Category c on c.ID = P.CategoryID
//select new
//{
// p.ID,
// p.Name,
// p.Description,
// p.Price
//}).ToList();
//buy 에서 title 과 customerId만 빼오면되는데.
string tempId = "admin";
var query = from x in context.Buys
join y in context.UsedBooks on x.BuyID equals y.UsedBookID
where x.Customer.LoginID.Equals(tempId)
select new
{
Buy = x,
Title = y.MetaDataBook.Title
};
var list = query.ToList();
foreach (var item in list)
{
item.Buy.Title = item.Title;
}
//var list =context.UsedBooks.SelectMany (x => x.Buys);
// list.Where(x=>x.)
// var query = from VAR in
return(list.ConvertAll(x => x.Buy));
}
}
public List <UsedBook> Search(string title, string writer, string quality)
{
using (YesAlaMungoEntities context = DbContextFactory.Create())
{
var query = from x in context.UsedBooks
where x.IsSell == false
select new
{
UsedBook = x,
BookTitle = x.MetaDataBook.Title,
BookWriter = x.MetaDataBook.Writer,
BookPrice = x.MetaDataBook.Price,
ImagePath = x.MetaDataBook.Image,
BookPublisher = x.MetaDataBook.Publisher
};
if (string.IsNullOrEmpty(title) == false)
{
query = query.Where(x => x.UsedBook.MetaDataBook.Title.Contains(title));
}
if (string.IsNullOrEmpty(writer) == false)
{
query = query.Where(x => x.UsedBook.MetaDataBook.Writer.Contains(writer));
}
if (string.IsNullOrEmpty(quality) == false)
{
query = query.Where(x => x.UsedBook.Quality.Contains(quality));
}
var list = query.ToList();
foreach (var item in list)
{
item.UsedBook.Title = item.BookTitle;
item.UsedBook.Writer = item.BookWriter;
item.UsedBook.ImagePath = item.ImagePath;
item.UsedBook.Publisher = item.BookPublisher;
if (item.UsedBook.Quality == "A")
{
item.UsedBook.Price = (int)(item.BookPrice * 0.9);
}
else if (item.UsedBook.Quality == "B")
{
item.UsedBook.Price = (int)(item.BookPrice * 0.8);
}
else if (item.UsedBook.Quality == "C")
{
item.UsedBook.Price = (int)(item.BookPrice * 0.7);
}
else if (item.UsedBook.Quality == "F")
{
item.UsedBook.Price = (int)(item.BookPrice * 0.5);
}
}
return(list.ConvertAll(x => x.UsedBook));
}
}
