public static Sale GetSale(int saleID)
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return(cr.Sale.Where(x => x.SaleID == saleID).FirstOrDefault());
}
}
public static List <Sale> GetSales()
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return(cr.Sale.ToList());
}
}
public static List <Product> GetProducts()
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return(cr.Product.ToList());
}
}
public static List <Customer> GetCustomers()
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return(cr.Customer.ToList());
}
}
public static Kullanici GetKullanici(int ID)
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Kullanici.Where(x => x.KullaniciId == ID).FirstOrDefault());
}
}
public static List<Category> GetCategories()
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return cr.Category.ToList();
}
}
static public User GetUser(string username)
{
using (CariHesapEntities pw = new CariHesapEntities())
{
return(pw.User.Where(x => x.Username == username).FirstOrDefault());
}
}
public static Kategori GetKategori(int Id)
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Kategori.Where(x => x.KategoriId == Id).FirstOrDefault());
}
}
public static List <Urun> GetUrunsList(int kategoriId)
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Urun.Where(x => x.KategoriId == kategoriId).ToList());
}
}
static public List <User> GetUsers()
{
using (CariHesapEntities pw = new CariHesapEntities())
{
return(pw.User.ToList());
}
}
public static List <Urun> GetUrunsList()
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Urun.ToList());
}
}
public static Urun GetUrun(int urunId)
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Urun.Where(x => x.UrunId == urunId).FirstOrDefault());
}
}
public static List <ProductModel> GetProductModelsByCategoryId(int categoryId)
{
using (var che = new CariHesapEntities())
{
return(GetProducts().Where(pr => pr.categoryId == categoryId).ToList());
}
}
public static List <Musteriler> GetMusteriList()
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Musteriler.ToList());
}
}
public static List <Categories> GetCategories()
{
using (var che = new CariHesapEntities())
{
return(che.Categories.ToList());
}
}
public static List <Kategori> GetKategoriList()
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Kategori.ToList());
}
}
public static List <string> GetCategoryNames()
{
using (var che = new CariHesapEntities())
{
return(che.Categories.Select(c => c.categoryName).ToList());
}
}
public static Kullanici GetKullanici(string kullanici, string sifre)
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Kullanici.Where(x => x.KullaniciAd == kullanici && x.KullaniciSifre == sifre).FirstOrDefault());
}
}
public static Categories GetCategoryByName(string name)
{
using (var che = new CariHesapEntities())
{
return(che.Categories.FirstOrDefault(c => c.categoryName == name));
}
}
public static Category GetCategory(int categoryID)
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return cr.Category.Where(x => x.CategoryID == categoryID).FirstOrDefault();
}
}
public static Customer GetCustomer(int customerID)
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return(cr.Customer.Where(x => x.CustomerID == customerID).FirstOrDefault());
}
}
public static Product GetProduct(int productID)
{
using (CariHesapEntities cr = new CariHesapEntities())
{
return(cr.Product.Where(x => x.ProductID == productID).FirstOrDefault());
}
}
static List <SaleModel> ConvertToSaleModel(List <Sale> sales)
{
var saleModels = new List <SaleModel>();
using (CariHesapEntities c = new CariHesapEntities())
{
foreach (var sale in sales)
{
var model = new SaleModel();
model.SaleID = sale.SaleID;
model.ProductID = sale.ProductID;
model.UserID = sale.UserID;
model.SoldUnit = sale.SoldUnit;
model.Product = sale.Product;
model.Product.ProductID = sale.Product.ProductID;
model.Product.ProductName = sale.Product.ProductName;
model.Product.PurchasePrice = sale.Product.PurchasePrice;
model.Product.SalePrice = sale.Product.SalePrice;
model.Product.Category = sale.Product.Category;
model.User = sale.User;
model.User.Name = sale.User.Name;
model.DateSold = sale.DateSold;
model.Customer = sale.Customer;
model.Customer.Name = sale.Customer.Name;
model.Customer.Surname = sale.Customer.Surname;
saleModels.Add(model);
}
}
return(saleModels);
}
public static List <string> GetCustomerNamesByUserId(int userId)
{
using (var che = new CariHesapEntities())
{
return(che.Customers.Where(cs => cs.userId == userId).Select(cs => cs.customerName).ToList());
}
}
public static Musteriler GetMusteri(int ID)
{
using (CariHesapEntities contex = new CariHesapEntities())
{
return(contex.Musteriler.Where(x => x.MusteriId == ID).FirstOrDefault());
}
}
public static Customers GetCustomerByName(string name)
{
using (var che = new CariHesapEntities())
{
return(che.Customers.FirstOrDefault(c => c.customerName == name));
}
}
public static List <Customers> GetCustomersByUserId(int userId)
{
using (var che = new CariHesapEntities())
{
return(che.Customers.Where(cs => cs.userId == userId).ToList());
}
}
public static bool CUD(Product product, EntityState state)
{
using (CariHesapEntities c = new CariHesapEntities())
{
c.Entry(product).State = state;
return(c.SaveChanges() > 0);
}
}
public static List <ProductModel> GetProductModels(int categoryID)
{
using (CariHesapEntities c = new CariHesapEntities())
{
var products = c.Product.Where(x => x.CategoryID == categoryID).ToList();
return(ConvertToProductModel(products));
}
}
public static List <ProductModel> GetProductModels()
{
using (CariHesapEntities c = new CariHesapEntities())
{
var products = c.Product.ToList();
return(ConvertToProductModel(products));
}
}
