public List <V_CabDriver> GetList() { using (var ctx = new TaxiOperatorContext()) { return(ctx.V_CabDrivers.ToList()); } }
public User Find(string userName, string password) { using (var ctx = new TaxiOperatorContext()) { return(ctx.Users.FirstOrDefault(x => x.UserName == userName && x.Password == password)); } }
public void Update() { using (var ctx = new TaxiOperatorContext()) { ctx.Entry(this).State = Microsoft.EntityFrameworkCore.EntityState.Modified; ctx.SaveChanges(); } }
public Customer GetRandom() { using (var ctx = new TaxiOperatorContext()) { int toSkip = new Random().Next(0, ctx.Customers.Count()); return(ctx.Customers.Skip(toSkip).Take(1).First()); } }
public void SetVipCustomer(int id) { using (var ctx = new TaxiOperatorContext()) { var customer = ctx.Customers.FirstOrDefault(x => x.Id == id); customer.IsVip = true; customer.Update(); } }