public void AddCalculatedRules() { using (PmsEteckContext _context = new PmsEteckContext()) { _context.Database.SetCommandTimeout(300); _context.Database.OpenConnection(); using (DbCommand _command = _context.Database.GetDbConnection().CreateCommand()) { _command.CommandTimeout = 300; _command.CommandText = "budget.GetCalculatedDimensionRules"; _command.CommandType = CommandType.StoredProcedure; _command.Parameters.Add(new SqlParameter("@budgetDimensionId", iBudgetDimensionKey)); using (DbDataReader reader = _command.ExecuteReader()) { while (reader.Read()) { ReportingStructure reportingStructure = db.ReportingStructure.Find((int)reader["iReportingStructureKey"]); BudgetDimensionRules.Add( new BudgetDimensionRule() { iReportingStructureKey = reportingStructure.iReportingStructureKey, iRecNo = reportingStructure.RecNo.Value, dTotal = reader["dTotal"] != DBNull.Value ? (decimal)reader["dTotal"] : 0, dJanuary = reader["dJanuary"] != DBNull.Value ? (decimal)reader["dJanuary"] : 0, dFebruary = reader["dFebruary"] != DBNull.Value ? (decimal)reader["dFebruary"] : 0, dMarch = reader["dMarch"] != DBNull.Value ? (decimal)reader["dMarch"] : 0, dApril = reader["dApril"] != DBNull.Value ? (decimal)reader["dApril"] : 0, dMay = reader["dMay"] != DBNull.Value ? (decimal)reader["dMay"] : 0, dJune = reader["dJune"] != DBNull.Value ? (decimal)reader["dJune"] : 0, dJuly = reader["dJuly"] != DBNull.Value ? (decimal)reader["dJuly"] : 0, dAugust = reader["dAugust"] != DBNull.Value ? (decimal)reader["dAugust"] : 0, dSeptember = reader["dSeptember"] != DBNull.Value ? (decimal)reader["dSeptember"] : 0, dOctober = reader["dOctober"] != DBNull.Value ? (decimal)reader["dOctober"] : 0, dNovember = reader["dNovember"] != DBNull.Value ? (decimal)reader["dNovember"] : 0, dDecember = reader["dDecember"] != DBNull.Value ? (decimal)reader["dDecember"] : 0, PercentJanuary = reader["PercentJan"] != DBNull.Value ? (decimal)reader["PercentJan"] : (decimal)1 / 12, PercentFebruary = reader["PercentFeb"] != DBNull.Value ? (decimal)reader["PercentFeb"] : (decimal)1 / 12, PercentMarch = reader["PercentMar"] != DBNull.Value ? (decimal)reader["PercentMar"] : (decimal)1 / 12, PercentApril = reader["PercentApr"] != DBNull.Value ? (decimal)reader["PercentApr"] : (decimal)1 / 12, PercentMay = reader["PercentMay"] != DBNull.Value ? (decimal)reader["PercentMay"] : (decimal)1 / 12, PercentJune = reader["PercentJun"] != DBNull.Value ? (decimal)reader["PercentJun"] : (decimal)1 / 12, PercentJuly = reader["PercentJul"] != DBNull.Value ? (decimal)reader["PercentJul"] : (decimal)1 / 12, PercentAugust = reader["PercentAug"] != DBNull.Value ? (decimal)reader["PercentAug"] : (decimal)1 / 12, PercentSeptember = reader["PercentSep"] != DBNull.Value ? (decimal)reader["PercentSep"] : (decimal)1 / 12, PercentOctober = reader["PercentOct"] != DBNull.Value ? (decimal)reader["PercentOct"] : (decimal)1 / 12, PercentNovember = reader["PercentNov"] != DBNull.Value ? (decimal)reader["PercentNov"] : (decimal)1 / 12, PercentDecember = reader["PercentDec"] != DBNull.Value ? (decimal)reader["PercentDec"] : (decimal)1 / 12, bSpatie = reader["bSpatie"] != DBNull.Value ? (bool)reader["bSpatie"] : false, bSubtotaal = reader["bSubtotaal"] != DBNull.Value ? (bool)reader["bSubtotaal"] : false, }); } ; } } } }
static void Main(string[] args) { try { PmsEteckContext db = new PmsEteckContext(); Console.WriteLine("We starten nu met het downloaden van de documenten per entiteit"); CustomerDocument _customerDocument = new CustomerDocument(); List <CustomerDocument> documentsForDownload = db.CustomerDocuments.Where(w => !w.bDownloaded && w.sUrl.StartsWith("http://dms.eteck.nl/ufc")).ToList(); Console.WriteLine(string.Format("De lijst met documenten is opgehaald en bevat {0} items", documentsForDownload.Count)); foreach (var item in documentsForDownload) { Console.WriteLine(string.Format("Gestart met het downloaden van document: {0}", item.sDocumentName)); bool result = _customerDocument.SaveFile(item.iCustomerDocumentKey); if (!result) { Console.WriteLine(string.Format("Er heeft zich een fout voorgedaan bij het downloaden van document {0}", item.sDocumentName)); } else { Console.WriteLine(string.Format("Het downloaden van het bestand is voltooid: {0}", item.sDocumentName)); } } Console.WriteLine("We starten met het downloaden van alle documenten."); Hyperlink _hyperlink = new Hyperlink(); List <Hyperlink> hyperlinksForDownload = db.Hyperlinks.Where(w => !w.bDownloaded && w.sUrl.StartsWith("http://dms.eteck.nl/ufc")).ToList(); Console.WriteLine(string.Format("De lijst met hyperlinks is opgehaald. Dit zijn er {0}", hyperlinksForDownload.Count)); foreach (Hyperlink hyperlink in hyperlinksForDownload) { Console.WriteLine(string.Format("Gestart met het downloaden van document: {0}", hyperlink.sLinkName)); bool result = _hyperlink.SaveFile(hyperlink.iHyperlinkKey); if (!result) { Console.WriteLine(string.Format("Er heeft zich een fout voorgedaan bij het downloaden van document {0}", hyperlink.sLinkName)); } else { Console.WriteLine(string.Format("Het downloaden van het bestand is voltooid: {0}", hyperlink.sLinkName)); } } Console.WriteLine("Alle bestanden zijn gedownload."); } catch (Exception e) { Console.WriteLine(e.Message); throw; } }
public void Delete(PmsEteckContext context, bool save) { if (Counters.Count > 0) { //foreach (Consumption consumption in Counters.SelectMany(s => s.Consumption)) //{ // context.Consumption.Attach(consumption); // context.Consumption.Remove(consumption); //} context.Consumption.RemoveRange(Counters.SelectMany(s => s.Consumption)); context.BlindConsumptions.RemoveRange(Counters.SelectMany(s => s.BlindConsumption)); context.MaximumPowers.RemoveRange(Counters.SelectMany(s => s.MaximumPowers)); context.CounterChangeLogs.RemoveRange(Counters.SelectMany(s => s.ChangeLogs)); context.Counters.RemoveRange(Counters); } context.MeterChangeLogs.RemoveRange(MeterChangeLogs); context.ConsumptionMeters.Remove(this); if (save) { context.SaveChanges(_httpContextAccessor.HttpContext.User.Identity.GetUserID()); } }
public void Delete(PmsEteckContext context, bool save) { if (ConsumptionMeters != null) { ConsumptionMeters.ToList().ForEach(f => f.Delete(context, false)); } if (Tickets != null) { foreach (Ticket ticket in Tickets) { ticket.iAddressID = null; context.Entry(ticket).State = EntityState.Modified; } } context.Addresses.Remove(this); //if (save) // context.SaveChanges(_httpContextAccessor.HttpContext.User.Identity.GetUserID()); }
static void Main(string[] args) { Console.WriteLine("Service is gestart."); PmsEteckContext context = new PmsEteckContext(); Console.WriteLine("Verbinding met de database is tot stand gebracht."); Console.WriteLine(string.Format("De volgende argumenten hebben we binnen gekregen: {0}.", string.Join(", ", args))); List <string> serviceNames = args.ToList(); Console.WriteLine("De omzetting van de argumenten is gelukt."); Console.WriteLine("Alle services worden opgehaald vanuit de databases."); List <Service> services = context.Services.Where(w => serviceNames.Contains(w.sServiceName)).ToList(); Console.WriteLine("Voor de volgende services ({0}) wordt er een nieuwe servicerun gestart", string.Join(", ", services.Select(s => s.sServiceName))); foreach (Service service in services) { Console.WriteLine("We zijn gestart met de servicerun voor service " + service.sServiceName); ServiceRun serviceRun = new ServiceRun(); switch (service.iServiceKey) { case 16: case 19: List <Counter> countersForUpdate = context.Counters .Where(w => w.iConsumptionMeterKey.HasValue && w.ConsumptionMeter.iConsumptionMeterSupplierKey == 6 && w.ConsumptionMeter.iAddressKey.HasValue && w.CounterType.bCanExchange).ToList(); Console.WriteLine("In totaal zullen er " + countersForUpdate.Count + " telwerken bijgewerkt moeten worden."); service.NewServiceRunAsync(countersForUpdate, context).Wait(); serviceRun = service.NewServiceRunAsync(countersForUpdate, context).Result; break; case 20: countersForUpdate = context.Counters .Where(w => w.iConsumptionMeterKey.HasValue && w.ConsumptionMeter.iConsumptionMeterSupplierKey == 4 && w.ConsumptionMeter.iAddressKey.HasValue && w.ConsumptionMeter.Address.ObjectID.HasValue) .ToList(); Console.WriteLine("In totaal zullen er " + countersForUpdate.Count + " bijgewerkt moeten worden."); service.NewServiceRunAsync(countersForUpdate, context).Wait(); serviceRun = service.NewServiceRunAsync(countersForUpdate, context).Result; break; default: break; } Console.WriteLine("Moment voor de volgende servicerun wordt ingesteld."); service.dtNextServiceRun = service.iServiceKey == 16 ? DateTime.Today.AddHours(38).ToUniversalTime() : DateTime.Today.AddHours(44).ToUniversalTime(); context.Entry(service).State = EntityState.Modified; Console.WriteLine("De servicerun voor " + service.sServiceName + " is afgerond."); Console.WriteLine("De volgende run voor " + service.sServiceName + " is" + service.dtNextServiceRun + " ."); } Console.WriteLine("Alle serviceruns zijn aangemaakt en verwerkt. De gegevens worden opgeslagen in de database."); try { context.SaveChanges(); Console.WriteLine("Gegevens zijn goed opgeslagen"); } catch (Exception ex) { Console.WriteLine("Het ging niet goed met het opslaan van de gegevens. De volgende melding hebben we ontvangen: " + ex.Message); } }