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()); }