public static void B() { //<snippet2> using (AdventureWorksEntities AWEntities = new AdventureWorksEntities()) { double?stdDev = EntityFunctions.StandardDeviation( from o in AWEntities.SalesOrderHeaders select o.SubTotal); Console.WriteLine(stdDev); } //</snippet2> }
public IEnumerable <EventureList> GetEventureListsByOwnerId(Int32 id) { var queryOwnerEventures = _contextProvider.Context .Eventures.Where(e => e.OwnerId == id) .Select(e => e.Id); return(_contextProvider.Context.EventureLists .Where(el => queryOwnerEventures.Contains(el.EventureId) && (el.Active) && (EntityFunctions.TruncateTime(el.DateBeginReg) <= EntityFunctions.TruncateTime(DateTime.Now)) && (EntityFunctions.TruncateTime(el.DateEndReg) >= EntityFunctions.TruncateTime(DateTime.Now))) .OrderBy(el => el.SortOrder).ToList()); }
public ActionResult Index() { var sonuc = db.Order .GroupBy(s => EntityFunctions.TruncateTime(s.OrderTime)) .Select(gruop => new GunlukCiro { Gun = gruop.Key, SiparisAdet = gruop.Count(), Ciro = gruop.Sum(x => x.PaymentTotal) }).ToList(); return(View(sonuc)); }
// GET: /OldCopies/Delete/5 public ActionResult Delete(int?id) { DateTime currentDate = DateTime.Now; var data = db.DVDDetails.Where(d => EntityFunctions.DiffDays(d.DateAdded, currentDate) > 365); foreach (var item in data) { db.DVDDetails.Remove(item); } db.SaveChanges(); ViewBag.Message = "Delete successful"; return(RedirectToAction("Index")); }
public void ClearOldServiceMessages() { var targets = DataService.PerThread.MessageSet .Where(x => x.Type != (byte)MessageType.PrivateMessage && EntityFunctions.DiffMonths(x.Date, DateTime.Today) > 1) .ToList(); foreach (var msg in targets) { DataService.PerThread.MessageSet.DeleteObject(msg); } DataService.PerThread.SaveChanges(); }
private StatusData.Status GetCurrentStatusMinus30(int counterId, double minThreshold, double maxThreshold) { var stat = _context.Results .Where(c => c.DeviceCounter.Id == counterId) .Where(t => t.LogDate <= EntityFunctions.AddMinutes(DateTime.Now, -20) && t.LogDate >= EntityFunctions.AddMinutes(DateTime.Now, -30)) .FirstOrDefault(); if (stat != null) { return(GetStatus(minThreshold, maxThreshold, stat.AverageRead, stat.DeviceCounter.Device.Name)); } return(StatusData.Status.Green); }
public ActionResult Index() { var liste = db.PERSONELs.Where(a => a.DOGUM_GUNU_TARIHI != null). OrderBy(a => EntityFunctions.DiffDays(DateTime.Today, EntityFunctions.AddYears(a.DOGUM_GUNU_TARIHI, EntityFunctions.DiffYears(a.DOGUM_GUNU_TARIHI, DateTime.Today) + ((a.DOGUM_GUNU_TARIHI.Month < DateTime.Today.Month || (a.DOGUM_GUNU_TARIHI.Day <= DateTime.Today.Day && a.DOGUM_GUNU_TARIHI.Month == DateTime.Today.Month)) ? 1 : 0)))).Take(3).ToList(); ViewData["yuksek"] = db.EGITIMs.Where(s => s.OGRETIM_TIPI == "Yüksek Lisans").Count(); ViewData["lisans"] = db.EGITIMs.Where(s => s.OGRETIM_TIPI == "Lisans").Count(); ViewData["onlisans"] = db.EGITIMs.Where(s => s.OGRETIM_TIPI == "Ön Lisans").Count(); ViewData["duyuru"] = db.DUYURUs.ToList(); return(View(liste)); }
public ActionResult PayConsultation(ConsultationPaymentViewModel model) { if (model.price < (model.discount + model.insurer)) { ModelState.AddModelError("", _("lblPaymentAmountsErr")); } var consultation = db.Consultations .FirstOrDefault(c => c.patientID == model.patientID && c.doctorID == model.doctorID && EntityFunctions.TruncateTime(c.createDate) == EntityFunctions.TruncateTime(DateTime.Now)); if (consultation != null && consultation.Consultations_Payment.FirstOrDefault() != null) { ModelState.AddModelError("alreadyPayed", _("lblPaymentMadeErr")); } if (ModelState.IsValid) { var c = new Consultation(); GlobalHelpers.Transfer <ConsultationPaymentViewModel, Consultation>(model, c); var cp = new Consultations_Payment(); cp.Consultation = c; GlobalHelpers.Transfer <ConsultationPaymentViewModel, Consultations_Payment>(model, cp); db.Consultations.Add(c); db.Consultations_Payment.Add(cp); var appointment = db.Appointments.FirstOrDefault(a => a.finalStatus == null && a.patientID == model.patientID); if (appointment != null) { appointment.finalStatus = AppointmentStatus.Assisted.ToString(); db.Entry(appointment).State = EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Index", "Consultations")); } ViewBag.patientID = db.Patients .Where(p => p.User1.status == true && p.Appointments.FirstOrDefault(a => a.finalStatus == null) != null && EntityFunctions.TruncateTime(p.Appointments.FirstOrDefault(a => a.finalStatus == null).appointmentDate) == EntityFunctions.TruncateTime(DateTime.Now)).ToList() .ToSelectListItems(p => p.UserAccount.CompleteName, p => p.ID.ToString(), p => p.ID == model.patientID); ViewBag.doctorID = db.Doctors .Where(d => d.User.status == true).ToList() .ToSelectListItems(d => d.User.CompleteName, d => d.ID.ToString(), d => d.ID == model.doctorID); ViewBag.insurerID = db.Insurers .Where(i => i.status == true) .ToSelectListItems(i => i.name, i => i.ID.ToString(), i => i.ID == model.insurerID); ViewBag.paymentForm = (GlobalHelpers.ParseEnum <PaymentForms>(model.paymentForm)).EnumToList(false); ViewBag.patients = db.Patients.Where(p => p.User1.status == true).ToList(); return(View(model)); }
//public static List<TeamMember> GetTeamMemberList(int UserId) //{ // List<TeamMember> memberList = new List<TeamMember>(); // using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) // { // var ProjectIds = dbHrms.UserProjects.Where(x => x.UserID == UserId).Select(x => x.ProjectID).ToList(); // var UserList = dbHrms.UserProjects.Where(x => ProjectIds.Contains(x.ProjectID)).Select(x => x.UserID).Distinct().ToList(); // memberList = dbHrms.Users.Where(x => UserList.Contains(x.UserID)).Select(x => new TeamMember() // { // MemberId = x.EmpID, // MemberName = (x.FirstName + " " + (x.LastName ?? "")).Trim() // }).OrderBy(x => x.MemberName).ToList(); // memberList.Insert(0, new TeamMember() // { // MemberId = "0", // MemberName = "All" // } // ); // return memberList; // } //} #endregion #region Individual work entry public static List <HoursWorkData> GetSingleMemberData(string EmpId, DateTime FromDate, DateTime ToDate, bool IsAscending, int BranchId) { try { using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1()) { var WorkingHoursData = dbHrms.TimeManagements.Where(x => x.EmpID == EmpId && x.BranchId == BranchId && x.Date >= FromDate && x.Date <= ToDate). OrderBy(x => x.Date).Select(x => new WorkData { Date = EntityFunctions.TruncateTime(x.Date) ?? DateTime.Now, minsWorked = x.TotalTime, BranchID = x.BranchId, // minsWorked = x.OutTimeMin == 0 ? null : x.OutTimeMin - x.InTimeMin, IsOutEntry = (x.OutTimeMin != 0), IsAbsent = (x.OutTimeMin == 0 && x.InTimeMin == 0), InTime = x.InTime, OutTime = x.OutTime }).ToList(); ///var lll = dbHrms.TimeManagements.Where(x => x.EmpID.Contains(EmpId)); List <HoursWorkData> JsonWorkedData = new List <HoursWorkData>(); if (IsAscending) { JsonWorkedData = WorkingHoursData.Select(x => new DSRCManagementSystem.Models.HoursWorkData() { Date = (x.IsAbsent) ? x.Date.ToString(DateFormat) + LeaveFormat : (!x.IsOutEntry) ? x.Date.ToString(DateFormat) + NoOutEntryFormat : x.Date.ToString(DateFormat), //hoursWorked = Math.Round((double)((x.minsWorked == null ? 0 : x.IsOutEntry ? (Math.Round(TimeSpan.FromMinutes(x.minsWorked ?? 0).TotalHours, 0) >= 5 ? (Math.Floor(TimeSpan.FromMinutes(x.minsWorked ?? 0).TotalHours) - 1) : Math.Floor(TimeSpan.FromMinutes(x.minsWorked ?? 0).TotalHours)) : 0) + ((x.minsWorked % 60) / 100)), 2), hoursWorked = Math.Round((double)((x.minsWorked == null ? 0 : x.IsOutEntry ? (Math.Floor(TimeSpan.FromMinutes(x.minsWorked ?? 0).TotalHours)) : 0) + ((x.minsWorked % 60) / 100)), 2), Day = x.Date.ToString("dddd"), InTime = x.InTime, OutTime = x.OutTime }).ToList(); } else { JsonWorkedData = WorkingHoursData.Select(x => new DSRCManagementSystem.Models.HoursWorkData() { Date = (x.IsAbsent) ? x.Date.ToString(DateFormat) + LeaveFormat : (!x.IsOutEntry) ? x.Date.ToString(DateFormat) + NoOutEntryFormat : x.Date.ToString(DateFormat), hoursWorked = Math.Round((double)((x.minsWorked == null ? 0 : x.IsOutEntry ? (Math.Floor(TimeSpan.FromMinutes(x.minsWorked ?? 0).TotalHours)) : 0) + ((x.minsWorked % 60) / 100)), 2), Day = x.Date.ToString("dddd"), InTime = x.InTime, OutTime = x.OutTime }).ToList(); } return(JsonWorkedData); } } catch { return(new List <HoursWorkData>()); } }
public List <CheckOut> GetCheckOuts(DateTime date) { List <CheckOut> list = new List <CheckOut>(); try { list.AddRange(hotelDB.CheckOuts.Where(i => EntityFunctions.TruncateTime(i.checkOutDate) <= EntityFunctions.TruncateTime(date))); return(list); } catch (Exception) { return(list); } }
public override void FilaVistoBuenoCambiado(DataGridViewRow Fila, bool bVistoBueno) { if (this.Actualizando) { return; } string sCatTabla = Util.Cadena(Fila.Cells["Tabla"].Value); int iRegistroID = Util.Entero(Fila.Cells["RegistroID"].Value); int iUsuarioVBId = GlobalClass.UsuarioGlobal.UsuarioID; // Se obtiene el visto bueno a marcar/desmarcar, si es que ya existe DateTime dHoy = DateTime.Today; var oVistoBueno = Datos.GetEntity <CajaVistoBueno>(q => q.CatTabla == sCatTabla && q.TablaRegistroID == iRegistroID && EntityFunctions.TruncateTime(q.Fecha) == dHoy); if (bVistoBueno) { if (oVistoBueno == null) { // Se guarda el dato de visto bueno oVistoBueno = new CajaVistoBueno() { CatTabla = sCatTabla, TablaRegistroID = iRegistroID, UsuarioVistoBuenoID = iUsuarioVBId, Fecha = DateTime.Now }; Datos.Guardar <CajaVistoBueno>(oVistoBueno); } else { UtilLocal.MensajeAdvertencia("Ya existe un Visto Bueno para el registro especificado."); } Fila.Cells["TextoCheck"].Value = oVistoBueno.Fecha.ToString(CajaDetalleCorte.FormatoHora); } else { // Se borra el dato de visto bueno if (oVistoBueno == null) { UtilLocal.MensajeAdvertencia("No se encontró el Visto Bueno especificado, en la base de datos."); } else { Datos.Eliminar <CajaVistoBueno>(oVistoBueno, false); } Fila.Cells["TextoCheck"].Value = ""; } }
public ActionResult Index() { DateTime currentDate = DateTime.Now; DateTime date = DateTime.Now.AddDays(45); Console.WriteLine(currentDate); System.Diagnostics.Debug.WriteLine(currentDate); System.Diagnostics.Debug.WriteLine(date); System.Diagnostics.Debug.WriteLine(date.Subtract(currentDate)); var data = db.DVDDetails.Where(d => EntityFunctions.DiffDays(d.DateAdded, currentDate) > 365).ToList(); return(View(data)); }
public List <MeterUnitCollect> MeterUnitCollect(DateTime fromDate, DateTime toDate, string transformerID, string QuarterID) { List <MeterUnitCollect> data; if (!string.IsNullOrEmpty(transformerID)) { data = mBMSEntities.MeterUnitCollects.Where(x => EntityFunctions.TruncateTime(x.FromDate) >= fromDate.Date && EntityFunctions.TruncateTime(x.ToDate) <= toDate.Date && x.TransformerID == transformerID).ToList(); } else { data = mBMSEntities.MeterUnitCollects.Where(x => EntityFunctions.TruncateTime(x.FromDate) >= fromDate.Date && EntityFunctions.TruncateTime(x.ToDate) <= toDate.Date).ToList(); } return(data); }
private StatusData.Status GetCurrentDeviceCounterStatus(DeviceCounterBase counter) { var result = _context.Results .Where(r => r.DeviceCounter.Id == counter.Id) .Where(r => r.LogDate >= EntityFunctions.AddMinutes(DateTime.Now, -5)) .Select(r => r.AverageRead) .FirstOrDefault(); if (result <= counter.MinThreshold) { return(StatusData.Status.Green); } return(result >= counter.MaxThreshold ? StatusData.Status.Red : StatusData.Status.Yellow); }
public void FindPaymentNumber() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { lblAll.Text = (from u in db.Orders where u.IsDelete == false select new { u.OrderID }).Count().ToString(); lblpay.Text = (from u in db.Orders where u.IsDelete == false && u.IsPaid == true select new { u.OrderID }).Count().ToString(); lblFinal.Text = (from u in db.Orders where u.IsDelete == false && u.IsPaid == false && u.IsFinalized == true select new { u.OrderID }).Count().ToString(); lblNotFinal.Text = (from u in db.Orders where u.IsDelete == false && u.IsFinalized == false select new { u.OrderID }).Count().ToString(); //var n = (from u in db.Orders // where u.IsDelete == false && u.IsNewOrder == false // select new {u.OrderID}); //if (n != null) //{ // int a = n.Count(); //} string notCheckedOrderCount = (from u in db.Orders where u.IsDelete == false && (u.IsNewOrder == true || u.IsNewOrder == null) select new { u.OrderID }).Count().ToString(); lblNotChecked.Text = notCheckedOrderCount; lblNotification.Text = notCheckedOrderCount; lblNotiNotCheck.Text = notCheckedOrderCount; lblCounttotal.Text = notCheckedOrderCount; DateTime yesterday = DateTime.Today.AddDays(-1).Date; DateTime today = DateTime.Now.Date; //var yesterdayPaidOrders =db.Orders.Where(x => DateTime.Compare(x.PaymentDate.Value.Date, yesterday.Date) == 0).Count(); var yesterdayPaidOrders = (from u in db.Orders where u.IsPaid == true && u.IsDelete == false && EntityFunctions.TruncateTime(u.PaymentDate) == yesterday select u).Count(); lblYesterdayPay.Text = yesterdayPaidOrders.ToString(); var todayPaidOrders = (from u in db.Orders where u.IsPaid == true && u.IsDelete == false && EntityFunctions.TruncateTime(u.PaymentDate) == today select u).Count(); lblTodayPay.Text = todayPaidOrders.ToString(); } }
public JsonResult GetDailyRequestCount() { var List = oDBContext.CCMEMOMASTERs.Where(x => x.ISACTIVE).GroupBy(t => EntityFunctions.TruncateTime(t.CREATEDON)).Select(x => new ChartDailyRequestCount { requestDate = x.Key.Value, MemoCount = x.Count() }); return(Json(List.AsEnumerable().OrderBy(x => x.requestDate).Select(r => new { date = r.requestDate.GetValueOrDefault().ToString("dd.MM.yyyy"), count = r.MemoCount }), JsonRequestBehavior.AllowGet)); }
public List <int> TongLuotVanChuyenThucTe() { QLVanTai_2017 dbc = new QLVanTai_2017(); List <int> lis = new List <int>(); for (int item = 1; item <= DateTime.Now.Day; item++) { DateTime a = new DateTime(DateTime.Now.Year, DateTime.Now.Month, item); var temp = dbc.NhatTrinhXes.Where(ptr => EntityFunctions.TruncateTime(ptr.GioCapXuatBen) == a.Date && ptr.XeXepKhach.Value == true).ToList(); lis.Add(temp.Count); } return(lis); }
public IQueryable <DOCUMENTO_SISTEMA> SeleccionarMensajes(short id_anio, short id_centro, int id_imputado, short id_ingreso, short tipoMensaje, string nuc = "", string causapenal = "", DateTime?fechaInicio = null, DateTime?fechaFinal = null) { var _res = (from n in this.Context.NUC from m in this.Context.MENSAJE from cp in this.Context.CAUSA_PENAL where m.ID_MEN_TIPO == tipoMensaje && n.ID_ANIO == id_anio && n.ID_CENTRO == id_centro && n.ID_IMPUTADO == id_imputado && n.ID_INGRESO == id_ingreso && n.ID_NUC == m.NUC && cp.ID_CENTRO == n.ID_CENTRO && cp.ID_ANIO == n.ID_ANIO && cp.ID_IMPUTADO == n.ID_IMPUTADO && cp.ID_INGRESO == n.ID_INGRESO && cp.ID_CAUSA_PENAL == n.ID_CAUSA_PENAL select new DOCUMENTO_SISTEMA { CP_ANIO = cp.CP_ANIO, CP_FOLIO = cp.CP_FOLIO, DOCUMENTO = m.INTER_DOCTO.DOCTO, FORMATO_DOCUMENTO = m.INTER_DOCTO.ID_FORMATO, MENSAJE = m.CONTENIDO, NUC = m.NUC.Trim(), REGISTRO_FEC = m.REGISTRO_FEC, CAUSA_PENAL = cp }); if (!string.IsNullOrWhiteSpace(nuc) || (!string.IsNullOrWhiteSpace(causapenal) && causapenal.Length > 5 && causapenal.Length <= 10) || fechaInicio.HasValue || fechaFinal.HasValue) { var predicate = PredicateBuilder.True <DOCUMENTO_SISTEMA>(); if (!string.IsNullOrWhiteSpace(nuc)) { predicate = predicate.And(w => w.NUC == nuc); } if (!string.IsNullOrWhiteSpace(causapenal) && causapenal.Length > 5 && causapenal.Length <= 10) { int _anio = 0; int _folio = 0; _anio = int.Parse(causapenal.Substring(0, 4)); _folio = int.Parse(causapenal.Substring(5, causapenal.Length - 5)); predicate = predicate.And(w => w.CP_ANIO == _anio && w.CP_FOLIO == _folio); } if (fechaInicio.HasValue) { predicate = predicate.And(w => EntityFunctions.TruncateTime(w.REGISTRO_FEC) >= fechaInicio.Value); } if (fechaFinal.HasValue) { predicate = predicate.And(w => EntityFunctions.TruncateTime(w.REGISTRO_FEC) <= fechaFinal.Value); } return(_res.Where(predicate.Expand())); } else { return(_res); } }
public ActionResult Report(FamilyReportInfo familyReportInfo) { var entityContext = new EntityContext(); var fromDate = Convert.ToDateTime(familyReportInfo.FromDate); var toDate = Convert.ToDateTime(familyReportInfo.ToDate); var reports = new List <FamilyInfo>(); if (fromDate != DateTime.MinValue || toDate != DateTime.MinValue) { reports = entityContext.familyInfos.Where(q => EntityFunctions.TruncateTime(q.CreateDate) >= fromDate && EntityFunctions.TruncateTime(q.CreateDate) <= toDate).ToList(); } familyReportInfo.ReportInfo = reports; return(View(familyReportInfo)); }
protected internal Room GetAlternateRoom(TimeSpan startTime, TimeSpan endTime, int numberOfAttendees, int locationId, bool orderAsc) { Location location = _locationRepository.GetLocationById(locationId); var availableRooms = _roomRepository.GetByLocationAndSeatCount(location, numberOfAttendees) .Where(x => x.Bookings.Where(b => startTime <EntityFunctions.CreateTime(b.EndDate.Hour, b.EndDate.Minute, b.EndDate.Second) && endTime> EntityFunctions.CreateTime(b.StartDate.Hour, b.StartDate.Minute, b.StartDate.Second)).Count() == 0); availableRooms = (orderAsc) ? availableRooms.OrderBy(r => r.SeatCount) : availableRooms.OrderByDescending(r => r.SeatCount); Room alternateRoom = availableRooms.FirstOrDefault(); _logger.Trace(LoggerHelper.ExecutedFunctionMessage(alternateRoom, startTime, endTime, numberOfAttendees, locationId, orderAsc)); return(alternateRoom); }
public int?GetNextIndexOfDay() { DateTime d = DateTime.Now; int? max = DataProvider.Instant.DB.HealthRecords.Where(x => EntityFunctions.TruncateTime(x.CreateAt) == d.Date).Select(x => x.IndexOfDay).Max(); if (max == null) { return(1); } else { return(max + 1); } }
public List <TblBankDeposit> SearchTblBankDeposit(string iserial, string storeName, DateTime?Date, string Code, List <int> Storeiserial, string company) { using (var db = new ccnewEntities(GetSqlConnectionString(company))) { var tbl = db.TblBankDeposits.Include("TblStore1").Where(m => (m.TblStore1.ENAME.StartsWith(storeName) || storeName == null || storeName == "") && (m.Iserial.StartsWith(iserial) || iserial == null) && (m.TblStore1.code.StartsWith(Code) || Code == null || Code == "") && ((EntityFunctions.TruncateTime(m.FromDate) >= Date && EntityFunctions.TruncateTime(m.ToDate) >= Date) || Date == null) && Storeiserial.Any(l => m.TblStore1.iserial == l)) .ToList(); return(tbl); } }
public void ActualizarDatos() { // Se cargan las ventas pendientes en el Grid DateTime dHoy = DateTime.Today; var oPagos = Datos.GetListOf <VentasPagosView>(q => q.SucursalID == GlobalClass.SucursalID && (q.VentaEstatusID != Cat.VentasEstatus.Cancelada && q.VentaEstatusID != Cat.VentasEstatus.CanceladaSinPago) && EntityFunctions.TruncateTime(q.Fecha) == dHoy && q.Importe > 0).OrderBy(q => q.Folio); this.dgvDatos.Rows.Clear(); foreach (var oPago in oPagos) { this.dgvDatos.Rows.Add(oPago.VentaPagoID, oPago.VentaID, oPago.ClienteID, oPago.Facturada, oPago.Folio, oPago.Cliente, oPago.Vendedor, oPago.Importe); } }
/// <summary> /// Finds meetings that clash with a certain time on specific dates. /// </summary> /// <param name="room">Room to check for meetings in. Provided as this allows us to specify the room, rather than riskly grabbing the room of a random booking</param> /// <param name="startTime">Time for which the meetings will begin</param> /// <param name="endTime">Time for which the meetings will end</param> /// <param name="dates">Dates for to check for meeting clashes</param> /// <param name="clashedBookings">OUT bookings which clash with the given parameters</param> /// <returns>Boolean based on whether there were any clashes</returns> bool DoMeetingsClashRecurringly(Room room, TimeSpan startTime, TimeSpan endTime, DateTime date, out IEnumerable <Booking> clashedBookings) { ////Get dates only as we are checking against only the date portion in the DB //var datesOnly = dates.Select(x => x.Date); var totalBookingsClashed = _bookingRepository.GetByDateOnlyAndRoom(date, room) //Only bookings on the days that intersect our given time period .Where(z => startTime <= EntityFunctions.CreateTime(z.StartDate.Hour, z.StartDate.Minute, z.StartDate.Second) && endTime > EntityFunctions.CreateTime(z.StartDate.Hour, z.StartDate.Minute, z.StartDate.Second) || startTime >= EntityFunctions.CreateTime(z.StartDate.Hour, z.StartDate.Minute, z.StartDate.Second) && startTime < EntityFunctions.CreateTime(z.EndDate.Hour, z.EndDate.Minute, z.EndDate.Second)) .ToList(); // bug fix clashedBookings = totalBookingsClashed; // WORKING return(totalBookingsClashed.Count > 0); }
public List <Customer> _RecentCustomers() { List <Customer> objCustomerlst = new List <Customer>(); try { using (var db = new DBContext()) { var objCustomer = (from c in db.Customers join m in db.MachineDetails on c.CustomerId equals m.CustomerId join am in db.AdminScheduleReport on m.MachineDetailId equals am.MachineDetailId where EntityFunctions.TruncateTime(m.CreatedDate) == EntityFunctions.TruncateTime(DateTime.Now) && am.bSend == false select new { c.FirstName, c.LastName, c.CustomerId, c.Email, c.OrganizationName, m.CreatedDate, }).ToList(); foreach (var item in objCustomer) { var MachineCount = db.MachineDetails.Where(a => a.CustomerId == item.CustomerId).Count(); var Downloads = db.CustomerDownloadHistory.Where(a => a.CustomerId == item.CustomerId).Count(); objCustomerlst.Add(new Customer { CustomerId = item.CustomerId, LastName = item.LastName, FirstName = item.FirstName, Email = item.Email, OrganizationName = item.OrganizationName, count = MachineCount, Downloads = Downloads, CreateDate = item.CreatedDate, }); } return(objCustomerlst); } } catch (Exception e) { ExceptionHandler handler = new ExceptionHandler(); handler.HandleException(e); } return(null); }
public static CallRegistryCollection GetCallRegistries(string connectionString, string searchName, DateTime?callDate) { try { using (var context = new CallRegistryDBContext(connectionString)) { var callRegCollection = new CallRegistryCollection(); IQueryable <CallRegistry> items = null; if (callDate.HasValue && !string.IsNullOrEmpty(searchName)) { items = context.CallRegistries.Where( x => EntityFunctions.TruncateTime(x.CallDate) == EntityFunctions.TruncateTime(callDate.Value) && x.Name.Contains(searchName)); } else if (!string.IsNullOrEmpty(searchName)) { items = context.CallRegistries.Where(x => x.Name.Contains(searchName)); } else if (callDate.HasValue) { items = context.CallRegistries.Where( x => EntityFunctions.TruncateTime(x.CallDate) == EntityFunctions.TruncateTime(callDate.Value)); } else { items = context.CallRegistries; } if (items != null) { foreach (var callReg in items) { callRegCollection.Add(callReg); } } return(new CallRegistryCollection(callRegCollection.ObservableList.OrderByDescending(x => x.CallDate).ToList())); } } catch (Exception exception) { NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured, ExceptionResources.ExceptionOccuredLogDetail); return(null); } }
public void InsertData(DateTime holidayDate, string holidayDesc, List <string> branchCodeList, string createdBy) { try { DateTime createdDate = DateTime.Now; List <string> dbBranchCodeList = null; //หา branch ที่มีอยู่ในเบส if (holidayDate.Year != 1) { dbBranchCodeList = slmdb.kkslm_ms_calendar_branch.Where(p => EntityFunctions.TruncateTime(p.slm_HolidayDate) == EntityFunctions.TruncateTime(holidayDate) && p.is_Deleted == false).Select(p => p.slm_BranchCode).ToList(); } else { throw new Exception("Cannot find holiday date"); } //เอา branch ที่มีอยู่ในเบสแล้ว ออกจาก list ที่ต้องการ insert if (dbBranchCodeList.Count > 0) { branchCodeList = branchCodeList.Except <string>(dbBranchCodeList).ToList(); } if (branchCodeList.Count > 0) { foreach (string branchcode in branchCodeList) { kkslm_ms_calendar_branch obj = new kkslm_ms_calendar_branch() { slm_HolidayDate = holidayDate, slm_HolidayDesc = holidayDesc, slm_BranchCode = branchcode, slm_CreatedBy = createdBy, slm_CreatedDate = createdDate, slm_UpdatedBy = createdBy, slm_UpdatedDate = createdDate, is_Deleted = false }; slmdb.kkslm_ms_calendar_branch.AddObject(obj); } slmdb.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public override void Execute(IJobExecutionContext context) { // Get the list of users who have an active trial and have not logged in for more than 5 days List <IUser> inactiveUsers = (from user in _database.GetUsers where !user.SubscriptionId.HasValue && user.TrialExpiryDate > DateTime.UtcNow && EntityFunctions.DiffDays(user.LastLoginDate, DateTime.UtcNow) >= 5 && !user.SentInactiveReminder select user).ToList(); // Generate email for inactive members // TODO: EmailResult emailContents = _accountEmailFactory.InactiveTrialAccount(); IEmail inactiveUserEmail = _emailFactory.CreateEmail( contents: this.GetEmailContents(), subject: "Inactive Trial Account", recipients: inactiveUsers); // Send the email to users inactiveUserEmail.Send(); // Mark the users so that they don't get duplicate notifications foreach (var user in inactiveUsers) { user.SentInactiveReminder = true; } _database.SaveChanges(); // Notify dear admins StringBuilder adminEmailContents = new StringBuilder(); adminEmailContents.Append("<html><head></head><body>Fellow admins, your server over here speaking. I just reminded "); adminEmailContents.Append(inactiveUsers.Count); adminEmailContents.Append(" users that they have been inactive for more than 5 days. Here is who I sent email to:<br/><br/>"); foreach (IUser user in inactiveUsers) { adminEmailContents.Append(user.FirstName); adminEmailContents.Append(" "); adminEmailContents.Append(user.LastName); adminEmailContents.Append(" "); adminEmailContents.Append(user.EmailAddress); adminEmailContents.Append("<br/>"); } adminEmailContents.Append("I'm going to go sleep for another day now.</body></html>"); IEmail adminNotificationEmail = _emailFactory.CreateEmailForAdministrators(adminEmailContents.ToString(), "Inactive Users Report " + DateTime.UtcNow.ToShortDateString()); adminNotificationEmail.Send(); }
public static int CountDelayingOrders(this HtmlHelper htmlHelper, int companyId) { using (OrdersRepository ordersRep = new OrdersRepository(companyId)) { DateTime CurrentTime = DateTime.Now; return(ordersRep.GetList("Orders_Statuses", "Supplier", "User") .Where(x => EntityFunctions.DiffHours(x.CreationDate, CurrentTime) >= 48 && x.StatusId < (int)StatusType.ApprovedPendingInvoice && x.StatusId != (int)StatusType.Declined && x.StatusId != (int)StatusType.OrderCancelled ) .Count()); } }
// GET: ServicesStatus public ActionResult ServiceStatus() { ViewBag.SunSystems = Common.Helpers.parameters.Sunsys; ViewBag.GIS = Common.Helpers.parameters.Gis; ViewBag.BIPServer1 = Common.Helpers.parameters.billpayments1; ViewBag.sics = Common.Helpers.parameters.sics; ViewBag.tds = Common.Helpers.parameters.tds; ViewBag.sybrin = Common.Helpers.parameters.sybrin; // ViewBag.billpayments = Common.Helpers.parameters.billpayments; DateTime date = DateTime.Today; var services = db.ServiceMonitors.Include(d => d.Application).Include(d => d.Server).Include(d => d.Service) .Where(d => EntityFunctions.TruncateTime(d.RunDate) == date); return(View(services.ToList())); }