/// <summary> /// Gets all StatusUpdate objects which came from a particular ProjectUpdate(email) /// </summary> /// <param name="projectUpdateID">Guid which is the unique identifer for the ProjectUpdate being queried</param> /// <returns>List of StatusUpdate objects</returns> public List<StatusUpdate> GetAllUpdatesFromEmail(Guid projectUpdateID) { var updates = new List<StatusUpdate>(); updates = context.StatusUpdates.Where(su => su.ProjectUpdateID == projectUpdateID).ToList(); if (updates.Count > 0) { Guid projectID = updates.First().ProjectID; string projectName = context.Projects.FirstOrDefault(p => p.ProjectID == projectID).ProjectName; foreach (StatusUpdate update in updates) { update.ProjectName = projectName;//__now also write ProjectName to each update } } return updates; }
private void worker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { IList<ArbitrageItem> resultsToDataGrid = new List<ArbitrageItem>(); foreach (var item in background.arbitrageList.OrderByDescending(x => x.PercentBenefit)) { resultsToDataGrid.Add(item); } if (resultsToDataGrid.Count > 0) dataGridView1.ColumnHeadersVisible = true; dataGridView1.Columns["PercentBenefit"].DefaultCellStyle.Format = "###.##########"; dataGridView1.DataSource = resultsToDataGrid; toolStripStatusInfo.Text = Resources.Ready; if (isLoop != true) { button1.Enabled = true; button2.Enabled = true; } else { button1.Enabled = false; button2.Enabled = true; } if (background.arbitrageList.Count > 0) { dataGridView1.Visible = true; if (Options.Instance.SoundNotification == true && FormWindowState.Normal == this.WindowState) { var player = new System.Media.SoundPlayer(); player.Stream = Resources.doorbell; player.Play(); } if (Options.Instance.DisplayBalloonWhenPercentChanges == true && FormWindowState.Minimized == this.WindowState) { var BallonText = String.Format("Best offer brings you {0}% of benefit",resultsToDataGrid.First().PercentBenefit.ToString("##.######")); if (earlierBallonText.Equals(BallonText) == false) { notifyIcon1.BalloonTipText = BallonText; earlierBallonText = BallonText; if(Options.Instance.HideBalloonAfter5thDisplay==false && balloonCounter<5) if (Options.Instance.SoundNotification == true) { var player = new System.Media.SoundPlayer(); player.Stream = Resources.doorbell; player.Play(); notifyIcon1.ShowBalloonTip(1500); } else notifyIcon1.ShowBalloonTip(1500); balloonCounter++; } } } }
public static void agregarFacturas(List<FactUI> facturas) { // if (facturas.Count > 0) CatalogoFacturas.addFacturas(facturas, facturas.First().edificio, DateTime.Parse(facturas.First().fecha)); }
private static void PopulateTimelineData(List<ItemsViewModel> itemsDataP11, List<ItemsViewModel> itemsDataP14, List<DataItemViewModel> timelineData) { #region Rabadon IList<DataItemViewModelAux> divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP11) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Rabadon")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP14) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Rabadon")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); #endregion #region Needlessly divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP11) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Needlessly")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP14) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Needlessly")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); #endregion #region Zhonya divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP11) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Zhonya")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP14) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Zhonya")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); #endregion #region Luden's Echo divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP11) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Luden")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); divm = new List<DataItemViewModelAux>(); foreach (var item in itemsDataP14) { var raba = item.Items.FirstOrDefault(i => i.Name.StartsWith("Luden")); var pickrate = int.Parse(raba.PickRate.Replace("%", string.Empty)); if (pickrate > 15) divm.Add(new DataItemViewModelAux { Minute = item.Minute, Name = raba.Name, Pickrate = pickrate }); } timelineData.Add(new DataItemViewModel { Name = divm.First().Name, Patch = "5.11", MinuteFrom = divm.First().Minute, MinuteTo = divm.Last().Minute }); #endregion }
public static void addFacturas(List<FactUI> facturas, string edificio, DateTime periodo) { try { admEntities db = Datos.getDB(); //List<factura> facturasExistentes = db.factura.ToList(); //foreach (FactUI f in facturas) //{ // bool update = false; // foreach (factura fEx in facturasExistentes) // { // if (f.id != null) // { // if (fEx.idfactura == int.Parse(f.id)) // { // fEx.detalle = f.detalle; // fEx.fecha = DateTime.Parse(f.fecha); // fEx.id_sector = f.sector.idsector; // fEx.id_tipogasto = f.gasto.idtipo_gasto; // fEx.importe = double.Parse(f.importe); // fEx.numero_factura = f.nroFactura; // if (f.provedor != null) // fEx.razon_provedor = f.provedor.razon_social; // db.Entry(fEx).State = System.Data.EntityState.Modified; // update = true; // break; // } // } // } // if (update == false) // { // factura fact = new factura(); // fact.dir_edificio = f.edificio; // fact.fecha = DateTime.Parse(f.fecha); // fact.id_sector = f.sector.idsector; // fact.id_tipogasto = f.gasto.idtipo_gasto; // fact.importe = double.Parse(f.importe); // fact.numero_factura = f.nroFactura; // if (f.provedor != null) // fact.razon_provedor = f.provedor.razon_social; // fact.detalle = f.detalle; // db.factura.Add(fact); // } //} List<factura> facturasExistentes = db.factura.Where(x => x.dir_edificio == edificio && x.fecha.Month == periodo.Month && x.fecha.Year == periodo.Year).ToList(); foreach (factura f in facturasExistentes) db.factura.Remove(f); if (facturas.First().sector == null) { db.SaveChanges(); return; } foreach (FactUI f in facturas) { factura fact = new factura(); fact.dir_edificio = f.edificio; fact.fecha = DateTime.Parse(f.fecha); fact.id_sector = f.sector.idsector; fact.id_tipogasto = f.gasto.idtipo_gasto; fact.importe = double.Parse(f.importe); fact.numero_factura = f.nroFactura; if (f.provedor != null) fact.razon_provedor = f.provedor.razon_social; fact.detalle = f.detalle; db.factura.Add(fact); } db.SaveChanges(); } catch (Exception e) { Logger.Log.write(e.InnerException == null ? e.Message : e.InnerException.Message); throw e; } }