public int count()
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
return(DB.products.Count());
}
}
public product filterread(Expression <Func <product, bool> > filtre)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
return(DB.products.SingleOrDefault(filtre));
}
}
public List <product> filtre(Expression <Func <product, bool> > filtre)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
return(DB.products.Where(filtre).ToList());
}
}
public IEnumerable <category> read()
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
return(DB.categories.ToList());
}
}
public category filterread(Expression <Func <category, bool> > filtre)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
return(DB.categories.SingleOrDefault(filtre));
}
}
public IEnumerable <cargo_type> read()
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
return(DB.cargo_type.ToList());
}
}
public void delete(int id)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
DB.products.Remove(DB.products.Find(id));
DB.SaveChanges();
}
}
public void create(product t)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
DB.products.Add(t);
DB.SaveChanges();
}
}
public void update(category t)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
DB.categoryupdate(t.category_name.ToString(), t.id);
DB.SaveChanges();
}
}
public void create(category t)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
DB.categoryinsert(t.category_name.ToString());
DB.SaveChanges();
}
}
public void create(cargo_type t)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
DB.cargo_type.Add(t);
DB.SaveChanges();
}
}
public void update(product t)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
DB.products.Attach(t);
DB.Entry(t).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
}
}
public string login_successfull(string username, string password)
{
using (satissitesivol1DBEntities DB = new satissitesivol1DBEntities())
{
user _user = DB.users.Where(x => x.user_name == username && x.user_password == password).FirstOrDefault();
if (_user != null)
{
return("basarili_giris");
}
return("bulunamadi");
}
}
public IEnumerable <product> read()
{
satissitesivol1DBEntities DB = new satissitesivol1DBEntities();
return(DB.products.ToList());
}
