public bool WriteUserToDB(User user) { MyDataContext dataContext = new MyDataContext(); var context = (IDataContextFactory <HealthDataContext>)dataContext.GetMyDataContextContext(_configuration); using (var db = context.Create()) { var lastidquery = (from u in db.Users //where t.DeliverySelection == true && t.Delivery.SentForDelivery == null orderby u.Id descending select u).Take(1); int id = 0; foreach (var u in lastidquery) { id = u.Id + 1; } if (id != 0) { user.Id = id; if (db.Insert(user) > 0) { return(true); } } } return(false); }
//--------------------------------------------------------------------------------- public IActionResult ShowUsers() { MyDataContext dataContext = new MyDataContext(); var context = (IDataContextFactory <HealthDataContext>)dataContext.GetMyDataContextContext(_configuration); //ViewBag.ListOfUsers = GetAllusers(context); return(View("Show", GetAllusers(context))); }
//---------------------------------------------------------- public bool UpdateUserToDB(User user) { MyDataContext dataContext = new MyDataContext(); var context = (IDataContextFactory <HealthDataContext>)dataContext.GetMyDataContextContext(_configuration); using (var db = context.Create()) { if (db.Update(user) > 0) { return(true); } } return(false); }