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);
}
}
