public static void Main()
{
var db = new TelecommunicationProviderMySqlData();
db.ModelsMySqlRepository.Add(new MonthlyNumberOfContracts
{
Date = new DateTime(2015, 05, 05),
NumberOfContracts = 5
});
db.ModelsMySqlRepository.SaveChanges();
}
public void ImportDataToMySql(List<Contract> monthlyList)
{
var db = new TelecommunicationProviderMySqlData();
List<MonthlyNumberOfContracts> monthyContracts = new List<MonthlyNumberOfContracts>();
var grouped = monthlyList.GroupBy(x => x.StartDate.Date);
foreach (var item in grouped)
{
db.ModelsMySqlRepository.Add(new MonthlyNumberOfContracts
{
Date = item.Key.Date,
NumberOfContracts = item.Count()
});
}
Console.WriteLine("Importing data to mysql initialized.");
db.ModelsMySqlRepository.SaveChanges();
Console.WriteLine("Importing data to mysql completed!");
}
public void GenerateCompositeTelecommunicationReport()
{
Console.WriteLine("Generating merged report from SQLite and MySql...");
if (!Directory.Exists(OutputPath))
{
Directory.CreateDirectory(OutputPath);
}
SLDocument excelFile = new SLDocument();
using (var sqliteDbContext = new TelecommunicationProviderDbContext())
{
var mysqlDbContext = new TelecommunicationProviderMySqlData();
var compositeReports = from MySqlData in mysqlDbContext.ModelsMySqlRepository.All().AsEnumerable()
join sqliteData in sqliteDbContext.DifferentUserProviders.AsEnumerable()
on 1 equals 1 // it's magic :D
select
new
{
// MySqlData.Id,
MySqlData.NumberOfContracts,
MySqlData.Date,
// sqliteData.Id,
sqliteData.NumberOfProviders,
sqliteData.UserSsn
};
excelFile.SetCellValue("A1", "User SSN");
excelFile.SetCellValue("B1", "Number of Contracts");
excelFile.SetCellValue("C1", "Number of Providers");
excelFile.SetCellValue("D1", "Date");
//// excelFile.SetCellValue("E1", "From Date");
//// excelFile.SetCellValue("F1", "To Date");
//// excelFile.SetCellValue("G1", "Company Website");
//// excelFile.SetCellValue("H1", "Foundation Year");
int rowCounter = 2;
foreach (var report in compositeReports)
{
excelFile.SetCellValue("A" + rowCounter, report.UserSsn);
excelFile.SetCellValue("B" + rowCounter, report.NumberOfContracts.ToString());
excelFile.SetCellValue("C" + rowCounter, report.NumberOfProviders.ToString());
excelFile.SetCellValue("D" + rowCounter, report.Date.ToString());
// excelFile.SetCellValue("E" + rowCounter, report.StartDate.ToString());
// excelFile.SetCellValue("F" + rowCounter, report.EndDate.ToString());
// excelFile.SetCellValue("G" + rowCounter, report.Website.ToString());
// excelFile.SetCellValue("H" + rowCounter, report.FoundationYear.ToString());
rowCounter++;
}
}
DateTime currentDate = DateTime.Now;
string fileNameSuffix = string.Format(
"-{0}.{1}.{2}-{3}.{4}.{5}",
currentDate.Day,
currentDate.Month,
currentDate.Year,
currentDate.Hour,
currentDate.Minute,
currentDate.Second);
excelFile.SaveAs(string.Format(OutputFileNameFormat, OutputPath, fileNameSuffix));
}