public void Delete(Admin admin)
{
using (TechContext context = new TechContext())
{
var entity = context.Entry(admin);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Add(Category category)
{
using (TechContext context = new TechContext())
{
var entity = context.Entry(category);
entity.State = EntityState.Added;
context.SaveChanges();
}
}
public void Update(Brand brand)
{
using (TechContext context = new TechContext())
{
var entity = context.Entry(brand);
entity.State = EntityState.Modified;
context.SaveChanges();
}
}
public void UserUpdate(User user)
{
using (TechContext context = new TechContext())
{
var entity = context.Entry(user);
entity.State = EntityState.Modified;
context.SaveChanges();
}
}
public void Add(Message message)
{
using (TechContext context = new TechContext())
{
var entity = context.Entry(message);
entity.State = EntityState.Added;
context.SaveChanges();
}
}
public List <Brand> GetBrandsName()
{
using (TechContext context = new TechContext())
{
var brandsList = context.Brands.ToList();
return(brandsList);
}
}
public List <Category> LatestCategories(int piece)
{
using (TechContext context = new TechContext())
{
var latestCategories = (from category in context.Categories
orderby category.CategoryID descending select category).Take(piece).ToList();
return(latestCategories);
}
}
public List <Product> JoinProducts(string brandName)
{
using (TechContext context = new TechContext())
{
var productList = (from i in context.Products
join brand in context.Brands on i.BrandID equals brand.BrandID
where brandName.Contains(brand.BrandName)
select i).ToList();
return(productList);
}
}
public List <Brand> LatestBrands(int piece)
{
using (TechContext context = new TechContext())
{
var latestBrands = (from i in context.Brands
orderby i.BrandID descending
select i).Take(piece).ToList();
return(latestBrands);
}
}
public int GetID(string brandName)
{
int ID = 0;
using (TechContext context = new TechContext())
{
var brandID = (from brand in context.Brands where brand.BrandName == brandName select brand.BrandID);
foreach (var i in brandID)
{
ID += i;
}
return(ID);
}
}
public int GetId(string username)
{
int Id = 0;
using (TechContext context = new TechContext())
{
var adminId = context.Admins.Where(p => p.Username == username);
foreach (var admin in adminId)
{
Id += admin.Id;
}
return(Id);
}
}
public string Login(string username, string password)
{
using (TechContext context = new TechContext())
{
var userList = context.Users.Where(p => p.UserName == username & p.Password == password).ToList();
if (userList.Count > 0)
{
return("Giriş başarılı");
}
else
{
return("Giriş başarısız");
}
}
}
public int GetFeatureId(int productId, int featureId, string featureValue = "")
{
int ID = 0;
using (TechContext context = new TechContext())
{
var featureID = (from i in context.FeatureDetails
where i.FeatureID == featureId && i.ProductID == productId
select i.ID);
foreach (var i in featureID)
{
ID += i;
}
return(ID);
}
}
public int GetFeature(string featureName)
{
int ID = 0;
using (TechContext context = new TechContext())
{
var featureID = (from i in context.Features
where i.FeatureName == featureName
select i.FeatureID);
foreach (var i in featureID)
{
ID += i;
}
return(ID);
}
}
public int GetProductID(string productName)
{
int ID = 0;
using (TechContext context = new TechContext())
{
var productID = (from product in context.Products
where product.ProductName == productName
select product.ProductID);
foreach (var i in productID)
{
ID += i;
}
return(ID);
}
}
public List <object> GetFeatureDetails()
{
using (TechContext context = new TechContext())
{
IQueryable <object> featureDetailsList = (from p in context.Products
join detail in context.FeatureDetails on p.ProductID equals detail.ProductID
join feature in context.Features on detail.FeatureID equals feature.FeatureID
select new
{
ProductName = p.ProductName,
Feature = feature.FeatureName,
Value = detail.FeatureValue,
}
);
List <object> featureList = new List <object>(featureDetailsList);
return(featureList);
}
}
public int GetCategoryID(string categoryName)
{
int ID = 0;
using (TechContext context = new TechContext())
{
var categoryID = (from category in context.Categories where category.CategoryName == categoryName select category.CategoryID
);
foreach (var i in categoryID)
{
ID += i;
}
return(ID);
}
}
public int GetUserId(string username)
{
int Id = 0;
using (TechContext context = new TechContext())
{
var userId = (from i in context.Users
where i.UserName == username
select i.Id);
foreach (var i in userId)
{
Id += i;
}
return(Id);
}
}
public List <Product> SortProducts(int id, int index)
{
using (TechContext context = new TechContext())
{
if (index == (int)Sort.atoZ)
{
var filtreProductList = (from product in context.Products
where product.CategoryID == id
orderby product.ProductName
select product).ToList();
return(filtreProductList);
}
else if (index == (int)Sort.ztoA)
{
var filtreProductList = (from product in context.Products
where product.CategoryID == id
orderby product.ProductName descending
select product).ToList();
return(filtreProductList);
}
else if (index == (int)Sort.hightoLow)
{
var filtreProductList = (from product in context.Products
where product.CategoryID == id
orderby product.AveragePrice descending
select product).ToList();
return(filtreProductList);
}
else if (index == (int)Sort.lowtoHigh)
{
var filtreProductList = (from product in context.Products
where product.CategoryID == id
orderby product.AveragePrice
select product).ToList();
return(filtreProductList);
}
return(null);
}
}
public string ControlAdmin(string username, string email)
{
using (TechContext context = new TechContext())
{
var usernameControl = context.Admins.Where(p => p.Username == username).ToList();
var emailControl = context.Admins.Where(p => p.Email == email).ToList();
if (usernameControl.Count > 0)
{
return("0");
}
else if (emailControl.Count > 0)
{
return("1");
}
return("-1");
}
}
public List <object> GetBrands()
{
using (TechContext context = new TechContext())
{
IQueryable <object> brandList = (from p in context.Products
join brand in context.Brands on p.BrandID equals brand.BrandID
select new { brand.BrandName, brand.BrandID } into x
group x by new{ x.BrandID, x.BrandName } into b
select new
{
BrandID = b.Key.BrandID,
Name = b.Key.BrandName,
BrandCount = b.Select(x => x.BrandID).Count(),
DisplayField = b.Key.BrandName + " (" + b.Select(x => x.BrandID).Count() + ")",
}
);
List <object> list = new List <object>(brandList);
return(list);
}
}
public List <object> CategoryCounter()
{
using (TechContext context = new TechContext())
{
IQueryable <object> categoryCount = from p in context.Products
join c in context.Categories
on p.CategoryID equals c.CategoryID
where (c.CategoryName != null)
select new { c.CategoryName, p.CategoryID, c.Icon } into x
group x by new { x.CategoryName, x.Icon, x.CategoryID } into g
select new
{
Name = g.Key.CategoryName,
Count = g.Select(x => x.CategoryID).Count(),
Icon = g.Key.Icon,
CategoryID = g.Key.CategoryID,
};
List <object> list = new List <object>(categoryCount);
return(list);
}
}
public List <object> GetProductDetails(string id)
{
using (TechContext context = new TechContext())
{
int productID = int.Parse(id);
IQueryable <object> productDetails = (from i in context.Products
join j in context.FeatureDetails
on i.ProductID equals j.ProductID
where i.ProductID == productID
select new
{
i.AveragePrice,
i.ProductImage_1,
i.ProductImage_2,
i.ProductImage_3,
i.ProductName,
j.Feature.FeatureName,
j.FeatureValue
});
List <object> list = new List <object>(productDetails);
return(list);
}
}
public List <object> JoinProducts()
{
using (TechContext context = new TechContext())
{
IQueryable <object> productList = (from p in context.Products
join c in context.Categories on p.CategoryID equals c.CategoryID
join b in context.Brands on p.BrandID equals b.BrandID
where (p.ProductID != null)
select new
{
Name = p.ProductName,
Category = c.CategoryName,
Brand = b.BrandName,
AveragePrice = p.AveragePrice,
ProductFeatures = p.ProductFeatures,
Image = p.ProductImage_1,
Image2 = p.ProductImage_2,
Image3 = p.ProductImage_3,
});
List <object> list = new List <object>(productList);
return(list);
}
}