public ActionResult RollcallList(string courseTime) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "Index" })); } int t_id = PageValidate.FilterParam(User.Identity.Name); //从教师ID中查找可点名科目 DateTime minDt = DateTime.Now.AddMinutes(-10); var rc = (from c in db.Course_Infos join cvt in db.Course_vs_Times on c.course_id equals cvt.cvt_course_id join r in db.Sys_ClassRooms on cvt.cvt_room_id equals r.room_id into T1 from t1 in T1.DefaultIfEmpty() join s in db.Dic_Schools on t1.room_school_id equals s.school_id into T2 from t2 in T2.DefaultIfEmpty() where (c.c_teacher_id == t_id || c.c_assistant_id == t_id) && DbFunctions.DiffDays(DateTime.Now, cvt.cvt_time) == 0 && (cvt.cvt_time >= minDt || DbFunctions.AddMinutes(cvt.cvt_time, cvt.cvt_duration) > DateTime.Now) select new RollCallList { id = cvt.cvt_id, name = c.course_name, time = cvt.cvt_time } ); return(View(rc.ToList())); }
// GET: Histories/Grant/X - grant history for all time or for X days public async Task <ActionResult> Grant(int?days) { return(days == null ? View(await _db.Histories.Where(h => !h.Recieved).OrderByDescending(h => h.Date).ToListAsync()) : View(await _db.Histories.Where(h => !h.Recieved && DbFunctions.DiffDays(h.Date, DateTime.Now) < days) .OrderByDescending(h => h.Date).ToListAsync())); }
public IHttpActionResult OrderToShippedReport() { /* * Write a query to return an array of anonymous objects that have two properties. * * 1. A Shipper property containing that particular shipper. * 2. A OrderToShipped property containing the average amount of days between the OrderDate and ShippedDate by Shipper. * * Return the rows ordered by OrderToShipped * ");*/ var resultSet = _db.Shippers .Select(s => new { Shipper = new { s.ShipperID, s.CompanyName, s.Phone }, OrderToShipped = s.Orders.Average(o => DbFunctions.DiffDays(o.OrderDate, o.ShippedDate)) }) .OrderBy(s => s.OrderToShipped); Console.Write(resultSet); return(Ok(resultSet)); }
/// <summary> /// Get Daily appointments /// </summary> /// <param name="getDate"></param> /// <returns></returns> public IEnumerable <Appointment> GetDaillyAppointments(DateTime getDate) { return(_context.Appointments.Where(a => DbFunctions.DiffDays(a.StartDateTime, getDate) == 0) .Include(p => p.Pet) .Include(d => d.Doctor) .ToList()); }
public ActionResult GetAllChungChiOfNV(string mnv = "") { using (QUANGHANHABCEntities db = new QUANGHANHABCEntities()) { var temp = (from cc in db.ChungChis join ccnv in db.ChungChi_NhanVien on cc.MaChungChi equals ccnv.MaChungChi where ccnv.MaNV.Equals(mnv) select new { MaNV = ccnv.MaNV, TenChungChi = cc.TenChungChi, SoHieu = ccnv.SoHieu, NgayCap = ccnv.NgayCap, ConHan = (DbFunctions.DiffDays(DbFunctions.AddMonths(ccnv.NgayCap, cc.ThoiHan), DateTime.Now) < 0 ? "Hết Hạn" : DbFunctions.DiffDays(DbFunctions.AddMonths(ccnv.NgayCap, cc.ThoiHan), DateTime.Now) >= 0 ? "Còn Hạn" : "Còn Hạn" ) }); List <ChungChi_NhanVien_Model> arrChungChi = temp.ToList().Select(p => new ChungChi_NhanVien_Model { TenChungChi = p.TenChungChi, SoHieu = p.SoHieu, NgayCap = p.NgayCap, isConHan = p.ConHan }).ToList(); return(Json(new { success = true, data = arrChungChi }, JsonRequestBehavior.AllowGet)); } }
public List <Poliza> FindAll(string numSolicitud, string fechaIngreso, decimal?monto) { var query = _db.Poliza.AsQueryable(); if (!string.IsNullOrWhiteSpace(numSolicitud)) { query = query.Where(p => p.Nu_Poliza == numSolicitud); } if (!string.IsNullOrWhiteSpace(fechaIngreso)) { DateTime value; var esValida = DateTime.TryParse(fechaIngreso, out value); if (esValida) { query = query.Where(p => DbFunctions.DiffDays(p.Fe_Creacion, value).Value == 0); } } if (monto != null) { query = query.Where(p => p.Cap_Asegurado == monto); } return(query.OrderByDescending(p => p.Co_Poliza).ToList()); }
public NotificationResultDto GetNewNotifications() { var currentUserId = User.Identity.GetUserId(); var today = DateTime.Now; var userNotifications = _context.UserNotifications .Where(u => u.UserId == currentUserId); var unreadNotifications = userNotifications .Where(u => !u.IsRead) .ToList() .Count; var notifications = userNotifications .Select(u => u.Notification) .Include(n => n.Teamup.Organizer) .Where(n => DbFunctions.DiffDays(n.CreatedOn, today) <= 30) .ToList(); var notificationResultDto = new NotificationResultDto { Unread = unreadNotifications, All = notifications.Select(Mapper.Map <Notification, NotificationDto>) }; return(notificationResultDto); }
public ICollection <GelirGiderAylıkDTO> GecikenOdemeleriGetir(DateTime dateTime, bool kontrol) { using (CRMContext _db = new CRMContext()) { return((from finans in _db.FinansTakip join urun in _db.Urun on finans.UrunID equals urun.ID into urunfinans from Urun in urunfinans.DefaultIfEmpty() join sporcu in _db.Sporcu on finans.SporcuID equals sporcu.ID into sporcufinans from Sporcu in sporcufinans.DefaultIfEmpty() join calisan in _db.Calisan on finans.CalisanID equals calisan.ID into calisanfinans from Calisan in calisanfinans.DefaultIfEmpty() join uye in _db.Uye on finans.UyeID equals uye.ID into uyefinans from Uye in uyefinans.DefaultIfEmpty() join kat in _db.GelirGiderKategori on finans.GelirGiderKategoriID equals kat.ID where finans.GelirMiGiderMi == kontrol && finans.OdemeDurumu == false select new GelirGiderAylıkDTO { ID = finans.ID, KategoriAdi = kat.GelirGiderKategoriAdi, UyeAdi = Uye.Ad, CalisanAdi = Calisan.Ad, SporcuAdi = Sporcu.Ad, UrunAdi = Urun.UrunAd, Fiyat = finans.Fiyat, OdemeDurumu = finans.OdemeDurumu, OdemeTarihi = finans.OdemeTarihi.Value, SonOdemeTarihi = finans.SonOdemeTarihi.Value }).Where(x => x.SonOdemeTarihi.Value.Month == dateTime.Month && x.SonOdemeTarihi.Value.Year == dateTime.Year && DbFunctions.DiffDays(x.SonOdemeTarihi, DateTime.Now) > 0).ToList()); } }
public ICollection <AylikGelirGiderDTO> KategoriBilgileriniGetir(string ad) { using (CRMContext _db = new CRMContext()) { return((from finans in _db.FinansTakip join urun in _db.Urun on finans.UrunID equals urun.ID into urunfinans from Urun in urunfinans.DefaultIfEmpty() join sporcu in _db.Sporcu on finans.SporcuID equals sporcu.ID into sporcufinans from Sporcu in sporcufinans.DefaultIfEmpty() join calisan in _db.Calisan on finans.CalisanID equals calisan.ID into calisanfinans from Calisan in calisanfinans.DefaultIfEmpty() join uye in _db.Uye on finans.UyeID equals uye.ID into uyefinans from Uye in uyefinans.DefaultIfEmpty() join kat in _db.GelirGiderKategori on finans.GelirGiderKategoriID equals kat.ID where finans.AktifMi == true where finans.OdemeDurumu == false select new AylikGelirGiderDTO { ID = finans.ID, KategoriAdi = kat.GelirGiderKategoriAdi, UyeAdi = Uye.Ad, CalisanAdi = Calisan.Ad, SporcuAdi = Sporcu.Ad, UrunAdi = Urun.UrunAd, Fiyat = finans.Fiyat, SonOdemeTarihi = finans.SonOdemeTarihi.Value }).Where(x => x.KategoriAdi.Contains(ad) && DbFunctions.DiffDays(x.SonOdemeTarihi, DateTime.Now) > 0).ToList()); } }
public ActionResult ManageOrganizationAccounts() { try { DateTime CurrentTimeNow = new DateTime(); CurrentTimeNow = DateTime.Now; DateTime EndDate = CurrentTimeNow; return(Json(new { success = true, message = "Ok", data = db.OrganizationSettings.Select(x => new { x.OrganizationID, x.OrganizationNameInFull, Subdomain = db.Catalog.Where(y => y.OrganizationID == x.OrganizationID).Select(y => y.SubDomain).FirstOrDefault(), IsDemo = db.Catalog.Where(y => y.OrganizationID == x.OrganizationID).Select(y => y.IsDemo).FirstOrDefault(), IsActive = db.Catalog.Where(y => y.OrganizationID == x.OrganizationID).Select(y => y.IsActive).FirstOrDefault(), AccountStatus = db.Catalog.Where(y => y.OrganizationID == x.OrganizationID && (y.IsDemo == true || y.IsActive == true)).Select(y => (true) || (false)).FirstOrDefault(), NumberOfDemoDaysLeft = DbFunctions.DiffDays(CurrentTimeNow, db.RequestForDemo.Where(z => z.OrganizationFullName == x.OrganizationNameInFull).Select(z => z.DemoEndDate).FirstOrDefault()), // NumberOfActiveDaysLeft = DbFunctions.DiffDays(CurrentTimeNow, db.Catalog.Where(z => z.OrganizationID == x.OrganizationID).Select(z => z.ActiveEndDate).FirstOrDefault()) }) }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogHelper.Log(Log.Event.ONBOARDING, ex.Message); return(Json(new { success = false, message = "" + ex.Message, data = new { } }, JsonRequestBehavior.AllowGet)); } }
/* * Efecto: devuelve lista de instancias de modelo RequirementDurationsModel para reporte de análisis de duración de requerimientos * Requiere: complejidad de requerimiento * Modifica: NA */ public List <RequirementDurationsModel> GetRequirementDurationsInfo(int?complexity) { if (complexity != null) { IEnumerable <RequirementDurationsModel> info = from r in db.requerimientos where r.complejidad == complexity group r by r.complejidad into g select new RequirementDurationsModel { complexity = g.Select(d => d.complejidad).FirstOrDefault(), requirementCount = g.Count(), minDiff = g.Min(d => Math.Abs((int)(d.duracionDias - DbFunctions.DiffDays(d.fechaInicio, d.duracionEstimada)))), maxDiff = g.Max(d => Math.Abs((int)(d.duracionDias - DbFunctions.DiffDays(d.fechaInicio, d.duracionEstimada)))), avgDuration = (int)g.Average(d => d.duracionDias) }; return(info.ToList()); } else { IEnumerable <RequirementDurationsModel> info = from r in db.requerimientos group r by r.complejidad into g select new RequirementDurationsModel { complexity = g.Select(d => d.complejidad).FirstOrDefault(), requirementCount = g.Count(), minDiff = g.Min(d => Math.Abs((int)(d.duracionDias - DbFunctions.DiffDays(d.fechaInicio, d.duracionEstimada)))), maxDiff = g.Max(d => Math.Abs((int)(d.duracionDias - DbFunctions.DiffDays(d.fechaInicio, d.duracionEstimada)))), avgDuration = (int)g.Average(d => d.duracionDias) }; return(info.ToList()); } }
public IList <ShoppingCart> GetShoppingCartNullOrThan30Days() { var query = this.EntityDbSet.Include(p => p.ShoppingCartDetails); var result = query.Where(p => p.ShoppingCartDetails.Count() == 0 || DbFunctions.DiffDays(p.CreatedDate, DateTime.Now) < 10); return(result.ToList()); }
public IEnumerable <Appointment> GetDailyAppointments(DateTime getDate) { return(_db.Appointments.Where(a => DbFunctions.DiffDays(a.StartDateTime, getDate) == 0 && a.DStatus == true) .Include(m => m.Patient).OrderByDescending(m => m.StartDateTime) .Include(m => m.Doctor) .ToList()); }
public JsonResult BuscarDatosBrowser() { var data = (from vehiculo in context.icb_vehiculo join modelo in context.modelo_vehiculo on vehiculo.modvh_id equals modelo.modvh_codigo join color in context.color_vehiculo on vehiculo.colvh_id equals color.colvh_id join evento in context.icb_tpeventos on vehiculo.id_evento equals evento.tpevento_id where vehiculo.usado == true select new { vehiculo.nummot_vh, modelo.modvh_nombre, color.colvh_nombre, placa = vehiculo.plac_vh, fecfact_fabrica = vehiculo.fecfact_fabrica.ToString(), anomodelo = vehiculo.anio_vh, vehiculo.plan_mayor, evento.tpevento_nombre, dias_inventario = DbFunctions.DiffDays(vehiculo.fecfact_fabrica, DateTime.Now) }).ToList().OrderByDescending(x => x.fecfact_fabrica); return(Json(data, JsonRequestBehavior.AllowGet)); }
public HttpResponseMessage GetBurnedCalories(long date) { // Получаем смещение времени пользователя int timezoneOffset = RequestHelper.GetTimezoneOffset(Request); var zonedDateTime = TimeHelper.ConvertFromUtc(TimeHelper.FromUnixMsToDateTime(date), timezoneOffset); var zonedDate = zonedDateTime.Date; var workoutDiaryEntries = unitOfWork.WorkoutDiaryEntryRepository.Get( f => (f.CreateUserId == currentUserId && DbFunctions.DiffDays( // Выбрасываем время, оставляем только дату DbFunctions.TruncateTime( // Добавляем смещение временной зоны пользователя, получаем время из БД в часовом формате пользователя DbFunctions.AddMinutes(f.DateUTC, timezoneOffset) ), zonedDate) == 0), null, iE => iE.Exercise, iES => iES.Sets ); decimal burnedCalories = 0; if (workoutDiaryEntries != null && workoutDiaryEntries.Count() > 0) { burnedCalories = workoutDiaryEntries.Select(s => s.BurnedCalories).Sum(); } return(Request.CreateResponse(HttpStatusCode.OK, Helpers.Utilities.RoundAFZ(burnedCalories))); }
IEnumerable <Randevu> IRandevuRepo.GunlukRandevulariGetir(DateTime tarihGetir) { return(_context.Randevular.Where(a => DbFunctions.DiffDays(a.BaslangicTarihSure, tarihGetir) == 0) .Include(p => p.Hasta) .Include(d => d.Doktor) .ToList()); }
public HttpResponseMessage GetByDate(long date) { // Получаем смещение времени пользователя int timezoneOffset = RequestHelper.GetTimezoneOffset(Request); var zonedDateTime = TimeHelper.ConvertFromUtc(TimeHelper.FromUnixMsToDateTime(date), timezoneOffset); var zonedDate = zonedDateTime.Date; var workoutDiaryEntries = unitOfWork.WorkoutDiaryEntryRepository.Get( f => (f.CreateUserId == currentUserId && DbFunctions.DiffDays( // Выбрасываем время, оставляем только дату DbFunctions.TruncateTime( // Добавляем смещение временной зоны пользователя, получаем время из БД в часовом формате пользователя DbFunctions.AddMinutes(f.DateUTC, timezoneOffset) ), zonedDate) == 0), null, iE => iE.Exercise, iES => iES.Sets ); // Преобразовываем в DTO-объект для ответа var workoutDiaryEntryDTO = Mapper.Map <IEnumerable <WorkoutDiaryEntryDTO> >(workoutDiaryEntries); return(Request.CreateResponse <IEnumerable <WorkoutDiaryEntryDTO> >(HttpStatusCode.OK, workoutDiaryEntryDTO)); }
public ActionResult dsCodeMoiHomNay(int?page) { ViewBag.Title = "Danh sách code mới hôm nay"; IPagedList <CodeTable> codeTables = db.CodeTables.Where(t => DbFunctions.DiffDays(t.NgayDang, DateTime.Now) == 0).ToPagedList(page ?? 1, PAGE_SIZE); return(View("dsCode", codeTables)); }
private IEnumerable <HistoryRanking> GetRankingSinceDate(BlogContext db, DateTime since, DateTime rankDate, HistoryRanking.Type type) { return(db.BlogRatings.Where(r => DbFunctions.DiffDays(since, r.ratetime) >= 0).GroupBy(r => r.BlogID) .Select(g => new { blogId = g.Key, rating = g.Sum(r => r.value) }) .Join( db.Blogs.Where(b => b.isApproved == true && !NoRankCategories.Contains(b.CategoryID)), a => a.blogId, b => b.BlogID, (a, b) => new { blog = b, a.rating, postCount = db.Posts.Count(p => p.IdType == ItemType.Blog && p.ItemId == b.BlogID) } ).OrderByDescending(r => r.rating) .ThenByDescending(r => r.blog.BlogDate) .Take(RankSize) .ToList().Select(r => new HistoryRanking { Author = r.blog.Author, BlogDate = r.blog.BlogDate, BlogID = r.blog.BlogID, BlogThumb = BlogHelper.firstImgPath(r.blog, true), BlogTitle = r.blog.BlogTitle, BlogVisit = r.blog.BlogVisit, PostCount = r.postCount, Rating = r.rating, RankType = type, RankDate = rankDate, })); }
public int RemoveCONSOLUNID() { int impactRows = 0; try { using (var ctx = new KEntities()) { var query = (from j in ctx.JOB where j.SUREFNO.Contains(SysConstants.K35_SYSTEM_ID) && j.OWNERID.StartsWith("CN") && string.IsNullOrEmpty(j.VOIDBY) && j.SHPTYPE.Equals("H") && string.IsNullOrEmpty(j.CONSOLNO) && j.CONSOLLOT_UNID != null && DbFunctions.DiffDays(j.UPDATEDATE ?? j.CREATEDATE, DateTime.Now) <= 150 select j) .Take(200) .ToList() ; query.ForEach(q => { q.CONSOLLOT_UNID = null; ctx.Entry <JOB>(q).State = System.Data.Entity.EntityState.Modified; }); impactRows = ctx.SaveChanges(); } } catch (System.ArgumentOutOfRangeException ex) { throw (ex); } return(impactRows); }
/// <summary> /// 构造函数 /// </summary> public UserTableBLL() { TypeAdapterConfig <Models.UserTable, UserTableViewModel> .NewConfig() .Map(dest => dest.UserID, src => src.UserID) .Map(dest => dest.UserName, src => src.UserName) .Map(dest => dest.UserPassword, src => src.UserPassword) .Map(dest => dest.UserNickName, src => src.UserNickName) .Map(dest => dest.UserImage, src => src.UserImage) .Map(dest => dest.UserPhone, src => src.UserPhone) .Map(dest => dest.UserEmail, src => src.UserEmail) .Map(dest => dest.UserTheme, src => src.UserTheme) .Map(dest => dest.UserLevel, src => src.UserLevel) .Map(dest => dest.UserFrom, src => src.UserFrom) .Map(dest => dest.UserFromName, src => src.UserFromTable.UserFromName) .Map(dest => dest.ModifyDate, src => src.ModifyDate) .Map(dest => dest.CreateDate, src => src.CreateDate) .Map(dest => dest.UserCity, src => src.UserCity) .Map(dest => dest.UserMoney, src => src.UserMoney) .Map(dest => dest.UserWorkDay, src => src.UserWorkDay) .Map(dest => dest.UserWorkDayName, src => src.WorkDayTable.WorkDayName) .Map(dest => dest.UserFunction, src => src.UserFunction) .Map(dest => dest.CategoryRate, src => src.CategoryRate) .Map(dest => dest.Synchronize, src => src.Synchronize) .Map(dest => dest.MoneyStart, src => src.MoneyStart) .Map(dest => dest.IsUpdate, src => src.IsUpdate) .Map(dest => dest.ItemCount, src => src.ItemTable.Count()) .Map(dest => dest.JoinDay, src => DbFunctions.DiffDays(src.CreateDate, DateTime.Now) + 1) .Compile(); }
public int AddCONSOLUNID() { //Logger.Write(); int impactRows = 0; using (var ctx = new KEntities()) { var query = (from j in ctx.JOB where j.SUREFNO.Contains(SysConstants.K35_SYSTEM_ID) && j.OWNERID.StartsWith("CN") && string.IsNullOrEmpty(j.VOIDBY) && j.SHPTYPE.Equals("H") && !string.IsNullOrEmpty(j.SHPNO) && !string.IsNullOrEmpty(j.CONSOLNO) && j.CONSOLLOT_UNID == null && ctx.JOB.Any(m => m.SHPNO == j.CONSOLNO && m.OWNERID.Equals(j.OWNERID) && m.BIZTYPE.Equals(j.BIZTYPE) && string.IsNullOrEmpty(m.VOIDBY)) && DbFunctions.DiffDays(j.UPDATEDATE ?? j.CREATEDATE, DateTime.Now) <= 150 select j).ToList().Take(200); foreach (var q in query) { var consol = ctx.JOB.Where(j => j.SHPNO.Equals(q.CONSOLNO) && j.OWNERID == q.OWNERID && j.VOIDBY == null & j.VOIDDATE == null) .ToList().FirstOrDefault(); if (consol != null) { q.CONSOLLOT_UNID = consol.UNID; ctx.Entry <JOB>(q).State = System.Data.Entity.EntityState.Modified; } } impactRows = ctx.SaveChanges(); } return(impactRows); }
public IList <PropuestaSolucion> ListarPropuestaSolucion( int?numero, string fechaRegistro, string dni, string nombre) { var query = _db.PropuestaSolucion.AsQueryable(); if (numero.HasValue) { query = query.Where(x => x.Cod_Prop_Sol == numero.Value); } if (!string.IsNullOrWhiteSpace(fechaRegistro)) { //query = query.Where(x => x.Fe_Creacion.ToShortDateString().Contains(fechaRegistro)); DateTime vFechaRegistro = Convert.ToDateTime(fechaRegistro); query = query.Where(x => DbFunctions.DiffDays(x.Fec_Crea, vFechaRegistro).Value == 0); } if (!string.IsNullOrWhiteSpace(dni)) { query = query.Where(x => x.Prospecto.Num_DNI == dni); } if (!string.IsNullOrWhiteSpace(nombre)) { query = query.Where(x => x.Prospecto.Txt_Pros.Contains(nombre)); } return(query.ToList()); }
public object ObterPorLancamento() { return(contexto.Livros .Where(l => DbFunctions.DiffDays(l.DataPublicacao, DateTime.Now) <= 7) .Select(resumo) .ToList()); }
public ActionResult RecentTransactionGridViewPartial([ModelBinder(typeof(DevExpressEditorsBinder))] int?year) { ViewBag.Year = year; var model = unitOfWork.TransactionsRepo.Fetch(m => DbFunctions.DiffDays(m.TransactionDate, DateTime.Now) <= 1).ToList(); return(PartialView("_RecentTransactionGridViewPartial", model)); }
public void GenerateJsonFiles() { var db = new TravelAgencyDbContext(); var allExcursion = db.Excursions .Select(x => new { ID = x.ExcursionId, Name = x.Name, Duration = (int)DbFunctions.DiffDays(x.StartDate, x.EndDate), Destination = x.Destination.Country, ClientsCount = x.Clients, TotalIncome = x.PricePerClient * x.Clients, TransportCompany = x.Transport.CompanyName, TransportType = x.Transport.Type.ToString(), GuideName = x.Guide.Name }).ToList(); foreach (var item in allExcursion) { var jsonObj = JsonConvert.SerializeObject(item, Formatting.Indented); var adress = "../../../Data files/JSON/" + item.ID + ".json"; File.WriteAllText(adress, jsonObj); } }
/// <summary> /// 预约记录数据页 /// </summary> /// <param name="search"></param> /// <returns></returns> public ActionResult ReservationList(SearchHelperModel search) { Expression <Func <Reservation, bool> > whereLambda = (m => DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) <= 7 && DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) >= 0); var rowsCount = 0; //补充查询条件 //根据预约日期查询 if (!String.IsNullOrEmpty(search.SearchItem0)) { whereLambda = (m => DbFunctions.DiffDays(DateTime.Parse(search.SearchItem0), m.ReservationForDate) == 0); } //根据预约人联系方式查询 if (!String.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (m => m.ReservationPersonPhone.Contains(search.SearchItem1)); } //load data var list = new BLLReservation().GetReservationList(search.PageIndex, search.PageSize, out rowsCount, whereLambda, m => m.ReservationForDate, m => m.ReservationTime, false, false); var dataList = list.ToPagedList(search.PageIndex, search.PageSize, rowsCount); return(View(dataList)); }
public void DbFunctionsTests_DiffDays_DateTime_Test() { DateTime testDateTime2 = this.TestDateTime.AddDays(1); var result = this.GetOrderQuery().Select(x => DbFunctions.DiffDays(this.TestDateTime, testDateTime2)).First(); Assert.AreEqual(-1, result); }
/// <summary> /// 判断预约日期是否在可预约范围内 /// </summary> /// <param name="dt">预约日期</param> /// <param name="isAdmin">isAdmin</param> /// <param name="msg">errMsg</param> /// <returns></returns> public static bool IsReservationForDateAvailabel(DateTime dt, bool isAdmin, out string msg) { var daysdiff = dt.Subtract(DateTime.Today).Days; if (daysdiff < 0) { msg = "预约日期不可预约"; return(false); } if (!isAdmin && daysdiff > MaxReservationDiffDays) { msg = $"预约日期需要在{MaxReservationDiffDays}天内"; return(false); } var disabledPeriods = new BLLDisabledPeriod().GetAll(p => !p.IsDeleted && p.IsActive && DbFunctions.DiffDays(p.StartDate, dt) >= 0 && DbFunctions.DiffDays(dt, p.EndDate) >= 0); if (disabledPeriods == null || !disabledPeriods.Any()) { msg = ""; return(true); } msg = "预约日期被禁用,如要预约请联系网站管理员"; return(false); }
public void Execute() { var surveyCompletions = this.modelContext .SurveysCompletion .Include("Company") .Include("Role") .Where(x => x.Role.Name == "OFERTA" && x.PartialSave == true && x.DeletedAt == null && ( (x.CompleteReminderSentAt == null || DbFunctions.DiffDays(x.CreatedAt, DateTime.Now) >= 10) || (x.CompleteReminderSentAt != null && DbFunctions.DiffDays(x.CompleteReminderSentAt, DateTime.Now) >= 10)) ) .Take(20) .ToList(); foreach (var surveyCompletion in surveyCompletions) { try { var PdfName = this.pdfService.GetEvaluationFileName(surveyCompletion.Id); this.supplyCompleteRegistrationReminderEmailService.Send(PdfName, surveyCompletion); } catch (Exception e) { } finally { surveyCompletion.CompleteReminderSentAt = DateTime.Now; this.modelContext.SaveChanges(); } } }