private JourExceptionnel AjouterPeriodeExceptionnelle(DateTime dateDebut, DateTime dateFin, bool ouvert) { using (foodtruckEntities db = new foodtruckEntities()) { JourExceptionnel chevauchement = (from j in db.JourExceptionnel where DbFunctions.DiffMinutes(j.DateDebut, dateFin) >= 0 && DbFunctions.DiffMinutes(dateDebut, j.DateFin) >= 0 select j).FirstOrDefault(); if (chevauchement == null) { JourExceptionnel jour = new JourExceptionnel { DateDebut = dateDebut, DateFin = dateFin, Ouvert = ouvert, }; db.JourExceptionnel.Add(jour); db.SaveChanges(); } return(chevauchement); } }
private JourExceptionnel ModifierPeriodeExceptionnelle(DateTime dateId, DateTime dateDebut, DateTime dateFin, bool ouvert) { using (foodtruckEntities db = new foodtruckEntities()) { JourExceptionnel jourSelectionne = (from j in db.JourExceptionnel where j.DateDebut == dateId && j.Ouvert == ouvert select j).FirstOrDefault(); JourExceptionnel chevauchement = (from j in db.JourExceptionnel where j.DateDebut != jourSelectionne.DateDebut && DbFunctions.DiffMinutes(j.DateDebut, dateFin) > 0 && DbFunctions.DiffMinutes(dateDebut, j.DateFin) > 0 select j).FirstOrDefault(); if (chevauchement == null && jourSelectionne != null) { jourSelectionne.DateDebut = dateDebut; jourSelectionne.DateFin = dateFin; jourSelectionne.Ouvert = ouvert; db.SaveChanges(); } return(chevauchement); } }
public void DbFunctionsTests_DiffMinutes_DateTimeOffset_Test() { this.AssertException <NotSupportedException>(() => { this.GetOrderQuery().Select(x => DbFunctions.DiffMinutes(this.TestDateTimeOffset, this.TestDateTimeOffset)).First(); }); }
private void RankingScheduler() { Action timertask = new Action(() => { _logger.LogInformation("Starting Ranking Scheduler!"); using (var scope = _scopeFactory.CreateScope()) { var db = scope.ServiceProvider.GetRequiredService <BlogContext>(); var sincemonth = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); if (DateTime.Today.Day != 1) // Show last month on day 1 { var ranking1month = GetRankingSinceDate(db, sincemonth, DateTime.Today, HistoryRanking.Type.RankMonthly); db.HistoryRankings.RemoveRange(db.HistoryRankings.Where(h => h.RankType == HistoryRanking.Type.RankMonthly && DbFunctions.DiffMonths(h.RankDate, sincemonth) == 0)); db.HistoryRankings.AddRange(ranking1month); } var rankings24h = db.Blogs.Where(b => !NoRankCategories.Contains(b.CategoryID) && DbFunctions.DiffMinutes(b.BlogDate, DateTime.Now) < 1440 && b.isApproved == true) .OrderByDescending(r => r.Rating) .ThenByDescending(r => r.BlogDate) .Take(RankSize) .Select(b => new { blog = b, rating = b.Rating ?? 0, postCount = db.Posts.Count(p => p.IdType == ItemType.Blog && p.ItemId == b.BlogID) }).ToList() .Select(r => new HistoryRanking { Rating = r.rating, PostCount = r.postCount, Author = r.blog.Author, BlogVisit = r.blog.BlogVisit, BlogTitle = r.blog.BlogTitle, BlogThumb = BlogHelper.firstImgPath(r.blog, true), BlogID = r.blog.BlogID, BlogDate = r.blog.BlogDate, RankDate = DateTime.Now, RankType = HistoryRanking.Type.Rank24h }); db.HistoryRankings.RemoveRange(db.HistoryRankings.Where(h => h.RankType == HistoryRanking.Type.Rank24h)); db.HistoryRankings.AddRange(rankings24h); var dayFromMonday = DateTime.Now.DayOfWeek - DayOfWeek.Monday; if (dayFromMonday < 0) { dayFromMonday += 7; } var firstday = DateTime.Today.AddDays(-dayFromMonday); // remove this week's data. db.HistoryRankings.RemoveRange(db.HistoryRankings.Where(h => h.RankType == HistoryRanking.Type.RankWeekly && firstday <= h.RankDate)); if (dayFromMonday == 0) //if today is monday reuse last week data. { var lastWeek = GetRankingSinceDate(db, firstday.AddDays(-7), DateTime.Today, HistoryRanking.Type.RankWeekly); db.HistoryRankings.AddRange(lastWeek); } else { var rankings7d = GetRankingSinceDate(db, firstday, DateTime.Today, HistoryRanking.Type.RankWeekly); db.HistoryRankings.AddRange(rankings7d); } db.SaveChanges(); } }); Schedule(timertask).WithName(RankingTask).ToRunEvery(UpdateInterval).Minutes(); }
private bool checkTimes(DateTime aimTime, string fileBasePath, string fileName, out int gCount, out List <stock_alarm_GSA> goodsList) { gCount = 0; using (ksoaContext db = new ksoaContext()) { var query = from q in db.stock_alarm_GSA where q.stock_5DLatter < q.threshold_value && q.alarm_state == 0 && DbFunctions.DiffMinutes(q.last_alarmDate, DateTime.Now) >= q.alarmSpan select q; var query1 = from q in query where q.stock_5DLatter < q.threshold_value && q.alarm_state == 0 && DbFunctions.DiffMinutes(q.last_alarmDate, DateTime.Now) >= q.alarmSpan from p in db.spkfks from r in db.huoweizls //from s in db.hwsps where q.spid == p.spid && r.hw == q.hw //&&q.spid==s.spid&&q.hw==s.hw select new { //18335768012 462045 ID = q.ID, 商品编号 = q.spbh, 商品名称 = q.spmch, 货位 = r.huowname, 一级分类 = p.yjfl, 二级分类 = p.ejfl, 级分类 = p.sjfl, 预警阈值 = (int)(q.threshold_value), //实时库存= (int)s.hwshl, 计算时库存 = (int)q.amount_static, 近1月总销量 = q.saledIn1Month, 近7天销量 = q.saledIn7Days, 预计五天后库存 = q.stock_5DLatter, 在途数量 = q.stock_transit, 预计补货量 = q.restock_count, 最大库存量 = (int)(q.amount_static + q.restock_count + q.stock_transit - q.delivery_cycle * (q.saledIn7Days / 7.0)), 安全库存量 = (int)(q.safty_days * (0.85 * (q.saledIn7Days / 7.0) + 0.15 * (q.saledIn1Month / 30.0))), 次预警时间 = q.last_alarmDate, 最后统计时间 = q.lastCalcuDate }; goodsList = query.ToList(); gCount = goodsList.Count(); if (gCount > 0) { OpenXmlExcelOper.CreateSpreadSheet(fileBasePath + fileName, "data"); OpenXmlExcelOper.FillAlarmData(fileBasePath + fileName, "data", ListToDataTable(query1.ToList())); } } return(true); }
public void DbFunctionsTests_DiffMinutes_TimeSpan_Test() { this.AssertException <NotSupportedException>(() => { this.GetOrderQuery().Select(x => DbFunctions.DiffMinutes(this.TestTimeSpan, this.TestTimeSpan)).First(); }); }
public HttpResponseMessage GetAllTrips() { try { var timezone = TimeZoneInfo.FindSystemTimeZoneById("Egypt Standard Time"); var date = TimeZoneInfo.ConvertTime(DateTime.Now, timezone); var tripss = context.trips.Where(t => t.ID != context.Reservations.FirstOrDefault(r => r.TripId == t.ID).TripId).Join(context.UserMasters, t => t.DriverId, u => u.UserID, (tr, us) => new { DateOfTrip = DbFunctions.TruncateTime(tr.DateOfTrip).Value, DriverId = tr.DriverId, FromCity = tr.FromCity, ID = tr.ID, PlaceToMeet = tr.PlaceToMeet, TimeOfTrip = tr.TimeOfTrip, ToCity = tr.ToCity, Name = (us.FullName == null) ? us.UserName : us.FullName, ImageUrl = us.ImageUrl, PostTime = (DbFunctions.TruncateTime(tr.TimeOfPost) == DbFunctions.TruncateTime(date)) ? (tr.TimeOfPost.Value.Hour == date.Hour ? new { time = DbFunctions.DiffMinutes(tr.TimeOfPost.Value, date).Value, unit = "Minutes" } : new { time = DbFunctions.DiffHours(tr.TimeOfPost.Value, date).Value, unit = "hours" }) : new { time = DbFunctions.DiffDays(tr.TimeOfPost.Value, date).Value, unit = "days" } }).OrderByDescending(p => p.ID).ToList(); //var tripsAllTrips = context.trips.ToList(); //var trips = context.trips.ToList().Select(tr => new //{ // UserName = context.UserMasters.Where(u => u.UserID == tr.DriverId).ToList().FirstOrDefault().UserName, // DateOfTrip = tr.DateOfTrip, // DriverId = tr.DriverId, // FromCity = tr.FromCity, // ID = tr.ID, // PlaceToMeet = tr.PlaceToMeet, // TimeOfTrip = tr.TimeOfTrip, // ToCity = tr.ToCity //}).ToList(); if (tripss == null) { return(Request.CreateResponse(HttpStatusCode.NotFound, "There is no trips")); } var tripssToReturn = tripss.Select(t => new { DateOfTrip = t.DateOfTrip.ToString("MM/dd/yyyy"), DriverId = t.DriverId, FromCity = t.FromCity, ID = t.ID, PlaceToMeet = t.PlaceToMeet, TimeOfTrip = t.TimeOfTrip.Hours + ":" + t.TimeOfTrip.Minutes, ToCity = t.ToCity, Name = t.Name, ImageUrl = t.ImageUrl, PostTime = t.PostTime }).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, tripssToReturn)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
private bool checkTimes(DateTime aimTime, string fileBasePath, string fileName, out int gCount, out List <stock_alarm_GSA> goodsList) { gCount = 0; using (ksoaContext db = new ksoaContext()) { var query = from q in db.stock_alarm_GSA where q.stock_5DLatter < q.threshold_value && q.alarm_state == 0 && DbFunctions.DiffMinutes(q.last_alarmDate, DateTime.Now) >= q.alarmSpan select q; var query1 = from q in query where q.stock_5DLatter < q.threshold_value && q.alarm_state == 0 && DbFunctions.DiffMinutes(q.last_alarmDate, DateTime.Now) >= q.alarmSpan from p in db.spkfks from r in db.huoweizls where q.spid == p.spid && r.hw == q.hw select new { ID = q.ID, 商品编号 = q.spbh, 商品名称 = q.spmch, 货位 = r.huowname, 一级分类 = p.yjfl, 二级分类 = p.ejfl, 级分类 = p.sjfl, 预警阈值 = q.threshold_value, 五日后库存 = q.stock_5DLatter, 最后统计时间 = q.lastCalcuDate, 次预警时间 = q.last_alarmDate, 近两个月销量 = q.saledIn2Month, 近一月销量 = q.saledIn1Month, }; goodsList = query.ToList(); gCount = goodsList.Count(); if (gCount > 0) { OpenXmlExcelOper.CreateSpreadSheet(fileBasePath + fileName, "data"); OpenXmlExcelOper.FillAlarmData(fileBasePath + fileName, "data", ListToDataTable(query1.ToList())); } } return(true); }
public HttpResponseMessage GetMyReservedTrips() { try { var timezone = TimeZoneInfo.FindSystemTimeZoneById("Egypt Standard Time"); var date = TimeZoneInfo.ConvertTime(DateTime.Now, timezone); var currentUserID = context.UserMasters.FirstOrDefault(u => u.UserName == (RequestContext.Principal.Identity.Name)).UserID; var ReservedTripsOfCurrentUser = context.trips .Join(context.Reservations, t => t.ID, r => r.TripId, (tr, re) => new { DateOfTrip = DbFunctions.TruncateTime(tr.DateOfTrip).Value, DriverId = tr.DriverId, FromCity = tr.FromCity, TripID = tr.ID, PlaceToMeet = tr.PlaceToMeet, TimeOfTrip = tr.TimeOfTrip, ToCity = tr.ToCity, PostTime = (DbFunctions.TruncateTime(tr.TimeOfPost) == DbFunctions.TruncateTime(date)) ? (tr.TimeOfPost.Value.Hour == date.Hour ? new { time = DbFunctions.DiffMinutes(tr.TimeOfPost.Value, date).Value, unit = "Minutes" } : new { time = DbFunctions.DiffHours(tr.TimeOfPost.Value, date).Value, unit = "hours" }) : new { time = DbFunctions.DiffDays(tr.TimeOfPost.Value, date).Value, unit = "days" }, re.TravellerId, re.Accebted }).Where(t => DbFunctions.TruncateTime(date) < DbFunctions.TruncateTime(t.DateOfTrip) && currentUserID == t.TravellerId) .Join(context.UserMasters, t => t.DriverId, u => u.UserID, (tr, us) => new { DateOfTrip = tr.DateOfTrip, DriverId = tr.DriverId, FromCity = tr.FromCity, TripID = tr.TripID, PlaceToMeet = tr.PlaceToMeet, TimeOfTrip = tr.TimeOfTrip, ToCity = tr.ToCity, PostTime = tr.PostTime, tr.TravellerId, Accebted = tr.Accebted == true ? "Accepted reservation" : "reservation not yet Accepted ", Name = (us.FullName == null) ? us.UserName : us.FullName, ImageUrl = us.ImageUrl }).OrderByDescending(p => p.TripID).ToList(); //var ReservedTrips = context.trips.Join(context.UserMasters, t => t.DriverId, u => u.UserID, //(tr, us) => new //{ // DateOfTrip = DbFunctions.TruncateTime(tr.DateOfTrip).Value, // DriverId = tr.DriverId, // FromCity = tr.FromCity, // ID = tr.ID, // PlaceToMeet = tr.PlaceToMeet, // TimeOfTrip = tr.TimeOfTrip, // ToCity = tr.ToCity, // Accebted=context.Reservations.FirstOrDefault(r=>r.TripId==tr.ID).Accebted.Value==true? // "Accepted reservation": "reservation not yet Accepted " // , // Name = (us.FullName == null) ? us.UserName : us.FullName, // ImageUrl = us.ImageUrl, // PostTime = (DbFunctions.TruncateTime(tr.TimeOfPost) == DbFunctions.TruncateTime(date)) ? // (tr.TimeOfPost.Value.Hour == date.Hour ? // new { time = DbFunctions.DiffMinutes(tr.TimeOfPost.Value, date).Value, unit = "Minutes" } : // new { time = DbFunctions.DiffHours(tr.TimeOfPost.Value, date).Value, unit = "hours" }) : // new { time = DbFunctions.DiffDays(tr.TimeOfPost.Value, date).Value, unit = "days" } //}) .OrderByDescending(p => p.ID).ToList(); if (ReservedTripsOfCurrentUser == null) { return(Request.CreateResponse(HttpStatusCode.NotFound, "there is no Reserved trips")); } var tripssToReturn = ReservedTripsOfCurrentUser.Select(t => new { DateOfTrip = t.DateOfTrip.ToString("MM/dd/yyyy"), DriverId = t.DriverId, FromCity = t.FromCity, ID = t.TripID, PlaceToMeet = t.PlaceToMeet, TimeOfTrip = t.TimeOfTrip.Hours + ":" + t.TimeOfTrip.Minutes, t.Accebted, ToCity = t.ToCity, Name = t.Name, ImageUrl = t.ImageUrl, PostTime = t.PostTime }).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, tripssToReturn)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public HttpResponseMessage SearchForTrip(SearchForTripDto searchDto) { if (ModelState.IsValid) { try { var timezone = TimeZoneInfo.FindSystemTimeZoneById("Egypt Standard Time"); var date = TimeZoneInfo.ConvertTime(DateTime.Now, timezone); var ResultTripsOfSearch = context.trips.Where (t => DbFunctions.TruncateTime(t.DateOfTrip) == DbFunctions.TruncateTime(searchDto.DateOfTrip) && t.FromCity == searchDto.FromCity && t.ToCity == searchDto.ToCity) .Join(context.UserMasters, t => t.DriverId, u => u.UserID, (tr, us) => new { DateOfTrip = DbFunctions.TruncateTime(tr.DateOfTrip).Value, DriverId = tr.DriverId, FromCity = tr.FromCity, ID = tr.ID, PlaceToMeet = tr.PlaceToMeet, TimeOfTrip = tr.TimeOfTrip, ToCity = tr.ToCity, Name = (us.FullName == null) ? us.UserName : us.FullName, ImageUrl = us.ImageUrl, PostTime = (DbFunctions.TruncateTime(tr.TimeOfPost) == DbFunctions.TruncateTime(date)) ? (tr.TimeOfPost.Value.Hour == date.Hour ? new { time = DbFunctions.DiffMinutes(tr.TimeOfPost.Value, date).Value, unit = "Minutes" } : new { time = DbFunctions.DiffHours(tr.TimeOfPost.Value, date).Value, unit = "hours" }) : new { time = DbFunctions.DiffDays(tr.TimeOfPost.Value, date).Value, unit = "days" } }).ToList(); var tripsEditDate = ResultTripsOfSearch.Select(t => new { DateOfTrip = t.DateOfTrip.ToString("MM/dd/yyyy"), DriverId = t.DriverId, FromCity = t.FromCity, ID = t.ID, PlaceToMeet = t.PlaceToMeet, TimeOfTrip = t.TimeOfTrip.Hours + ":" + t.TimeOfTrip.Minutes, ToCity = t.ToCity, Name = t.Name, ImageUrl = t.ImageUrl, PostTime = t.PostTime }); if (ResultTripsOfSearch == null) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "There is no trips")); } var tripssToReturn = ResultTripsOfSearch. Join(context.Reservations, t => t.ID, r => r.TripId, (t, r) => new { DateOfTrip = t.DateOfTrip, DriverId = t.DriverId, FromCity = t.FromCity, ID = t.ID, PlaceToMeet = t.PlaceToMeet, TimeOfTrip = t.TimeOfTrip, ToCity = t.ToCity, Name = t.Name, ImageUrl = t.ImageUrl, PostTime = t.PostTime }).ToList(); var triptoreturn = tripssToReturn.Select(t => new { DateOfTrip = t.DateOfTrip.ToString("MM/dd/yyyy"), DriverId = t.DriverId, FromCity = t.FromCity, ID = t.ID, PlaceToMeet = t.PlaceToMeet, TimeOfTrip = t.TimeOfTrip.Hours + ":" + t.TimeOfTrip.Minutes, ToCity = t.ToCity, Name = t.Name, ImageUrl = t.ImageUrl, PostTime = t.PostTime }); List <object> listToRet = new List <object>(); bool found = false; object ObjToAdd; for (int i = 0; i < tripsEditDate.Count(); i++) { for (int j = 0; j < tripssToReturn.Count(); j++) { if (tripsEditDate.ElementAt(i).ID == tripssToReturn.ElementAt(j).ID) { found = true; } } if (!found) { listToRet.Add(tripsEditDate.ElementAt(i)); } found = false; } return(Request.CreateResponse(HttpStatusCode.OK, listToRet)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } } return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "you have to fill required fields")); }
public ActionResult GetNotificationsData() { var currentUserId = User.Identity.GetUserId(); var notificationsData = new List <NotificationsModel>(); var currentUserIds = this.eventsUsers.All().Where(x => x.UserID == currentUserId && x.Status == EventUserStatus.Enrolled).Select(x => x.EventID).ToList();; var upcomingEvents = this.eventsUsers.All().Where(x => x.UserID == currentUserId && x.Status == EventUserStatus.Enrolled && DbFunctions.DiffHours(DateTime.Now, x.EventId.StartDate) < 24 && DbFunctions.DiffMinutes(DateTime.Now, x.EventId.StartDate) > 0).ToList(); var upcomingLectures = this.lectures.All().Where(x => currentUserIds.Contains(x.EventId) && DbFunctions.DiffHours(DateTime.Now, x.Date) < 24 && DbFunctions.DiffMinutes(DateTime.Now, x.Date) > 0).Select(x => new CourseLectureViewModel { Id = x.Id, EventId = x.EventId, LectureDate = x.Date, LectureTitle = x.Title }); foreach (var ev in upcomingEvents) { notificationsData.Add(new NotificationsModel { Id = ev.EventID, Title = ev.EventId.Title, StartDate = ev.EventId.StartDate, LectureId = 0, HoursRemaining = (ev.EventId.StartDate - DateTime.Now).Hours, MinutesRemaining = (ev.EventId.StartDate - DateTime.Now).Minutes, TypeMessage = base.GetLocalizedEventTypeString(ev.EventId.Type) }); } foreach (var lecture in upcomingLectures) { notificationsData.Add(new NotificationsModel { Id = lecture.EventId, Title = lecture.LectureTitle, StartDate = lecture.LectureDate, LectureId = lecture.Id, HoursRemaining = (lecture.LectureDate - DateTime.Now).Hours, MinutesRemaining = (lecture.LectureDate - DateTime.Now).Minutes, TypeMessage = string.Format("{0} {1} {2}", EventsTypes.Lecture, Global.From, EventsTypes.Course) }); } //var currentUserEvents = this.eventsUsers.All().Where(x => x.UserID == currentUserId).ToList() // .Select(x => new NotificationsModel // { // Id = x.EventID, // Title = x.EventId.Title, // LectureId = x.EventId.Lectures. // }); return(Json(notificationsData.OrderBy(x => x.StartDate).ThenBy(x => x.Title), JsonRequestBehavior.AllowGet)); }
public IEnumerable <Todo> GetRecentTodos() { var currentTime = DateTime.Now; return(_db.Todos.Where(t => t.Status.Equals("Open") || DbFunctions.DiffMinutes(t.LastModified, currentTime) <= _timeInterval)); }
public object Book(string userID, int facutlyID, int roomID, string timeStart, string timeEnd, string title, string content, string note, int numberPerson) { DateTime start = Convert.ToDateTime(timeStart); DateTime end = Convert.ToDateTime(timeEnd); //var checkCoinCide = db.LineRooms.Where(x => x.RoomID == roomID //&& (start >= x.TimeStart && start <= x.TimeEnd) //|| (end >= x.TimeStart && end <= x.TimeEnd) //|| (start >= x.TimeStart && end <= x.TimeEnd) //).ToList(); var checkCoinCide = db.LineRooms.Where(q => q.RoomID == roomID && ((DbFunctions.DiffMinutes(start, q.TimeStart) >= 0 && DbFunctions.DiffMinutes(end, q.TimeStart) <= 0) || (DbFunctions.DiffMinutes(start, q.TimeEnd) >= 0 && DbFunctions.DiffMinutes(end, q.TimeEnd) <= 0)) ).ToList(); if (checkCoinCide.Count > 0) { return(new { isBooking = false, message = "Lịch họp bạn đặt đã trùng với một cuộc họp khác", }); } LineRoom lineRoom = new LineRoom(); lineRoom.LineRoomName = title; lineRoom.Content = content; lineRoom.Description = note; lineRoom.Status = 1; lineRoom.TimeStart = start; lineRoom.TimeEnd = end; lineRoom.NumberPerson = numberPerson; lineRoom.CreateBy = userID; lineRoom.CreateTime = DateTime.Now; lineRoom.RoomID = roomID; db.LineRooms.Add(lineRoom); try { db.SaveChanges(); return(new { isBooking = true, message = "Bạn đã đặt phòng họp thành công", result = new LineRoomDao().GetLineRoomByRoomID(roomID) }); } catch { return(new { isBooking = false, message = "Lỗi hệ thống! Vui lòng thử lại", }); } }
private Table GetFreeTable(DateTime orderDate) { var allReservations = UnitOfWork.All <ReservationOrder>(); var table = UnitOfWork.GetActual <Table>( x => x.IsNewest && !x.IsDeleted && !allReservations .Any( r => r.Status != ReservationOrderStatus.Cancelled && r.Table == x && DbFunctions.DiffMinutes(r.ReservationTime, orderDate) < 30)); return(table); }
internal OubliMotDePasse Details(string identifiant) { using (foodtruckEntities db = new foodtruckEntities()) { DateTime maintenant = DateTime.Now; var oubliMotDePasse = (from u in db.OubliMotDePasse where u.CodeVerification == identifiant && DbFunctions.DiffMinutes(maintenant, u.DateFinValidite) >= 0 select u).FirstOrDefault(); return(oubliMotDePasse); } }