public void Delete(int id) { var db = new ShopEnSonEntities(); UsersOld result = db.UsersOld.Where(c => c.Id == id).FirstOrDefault(); db.UsersOld.Remove(result); db.SaveChanges(); }
public void Delete(int id) { ShopEnSonEntities db = new ShopEnSonEntities(); Users usr = db.Users.Where(c => c.Id == id).FirstOrDefault(); db.Users.Remove(usr); db.SaveChanges(); }
public List <Users> List() { var db = new ShopEnSonEntities(); List <Users> result = new List <Users>(); result = db.Users.ToList(); return(result); }
public void Delete(int id) { var db = new ShopEnSonEntities(); Categories result = db.Categories.Where(c => c.Id == id).FirstOrDefault(); result = db.Categories.Remove(result); db.SaveChanges(); }
public List <Categories> List() { var db = new ShopEnSonEntities(); List <Categories> result = new List <Categories>(); result = db.Categories.ToList(); return(result); }
public UsersOld Insert(UsersOld entity) { var db = new ShopEnSonEntities(); UsersOld result = new UsersOld(); result = db.UsersOld.Add(entity); db.SaveChanges(); return(result); }
public List <UsersOld> List() { ShopEnSonEntities db = new ShopEnSonEntities(); List <UsersOld> result = new List <UsersOld>(); result = db.UsersOld.ToList(); return(result); }
public Users Insert(Users entity) { Users result = new Users(); ShopEnSonEntities db = new ShopEnSonEntities(); result = db.Users.Add(entity); db.SaveChanges(); return(result); }
public Categories Insert(Categories categories) { var db = new ShopEnSonEntities(); Categories result = new Categories(); result = db.Categories.Add(categories); db.SaveChanges(); return(result); }
public Categories Update(Categories entity) { var db = new ShopEnSonEntities(); Categories result = db.Categories.Where(c => c.Id == entity.Id).FirstOrDefault(); result.Name = entity.Name; result.CatOrder = entity.CatOrder; result.Description = entity.Description; db.SaveChanges(); return(result); }
public Users Update(Users entitiy) { ShopEnSonEntities db = new ShopEnSonEntities(); Users defaultUser = db.Users.Where(c => c.Id == entitiy.Id).FirstOrDefault(); defaultUser.Password = entitiy.Password; defaultUser.UserName = entitiy.UserName; defaultUser.FullName = entitiy.FullName; defaultUser.Credit = entitiy.Credit; db.SaveChanges(); return(defaultUser); }
public UsersOld Update(UsersOld entity) { var db = new ShopEnSonEntities(); UsersOld result = db.UsersOld.Where(c => c.Id == entity.Id).FirstOrDefault(); result.Password = entity.Password; result.UserName = entity.UserName; result.FullName = entity.FullName; result.Bakiye = entity.Bakiye; db.SaveChanges(); return(result); }
public ProductRepository() { db = new ShopEnSonEntities(); }