public void GetAllProgressesTest()
{
ProgressRepository repository = new ProgressRepository(resConnect);
List <Progress> loadList = new List <Progress>();
string query = "SELECT * from dbo.Progress";
using (SqlConnection connection =
new SqlConnection(resConnect))
{
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
loadList.Add(
new Progress(
idProgress: (int)reader[0],
statusProgress: (string)reader[1]
)
);
}
reader.Close();
}
int count = repository.GetAllProgresses().Count;
Assert.AreEqual(count, loadList.Count);
}
public void Post([FromBody] Progress progresUpdate)
{
var identity = HttpContext.User.Identity as ClaimsIdentity;
var userId = identity.FindFirst(ClaimTypes.Name).Value;
if (identity == null)
{
Response.StatusCode = 404;
}
int ID = Int32.Parse(userId);
ProgressRepository.AddProgress(progresUpdate, ID);
}
public List <Progress> Get()
{
var identity = HttpContext.User.Identity as ClaimsIdentity;
var userId = identity.FindFirst(ClaimTypes.Name).Value;
if (identity == null)
{
Response.StatusCode = 404;
}
int ID = Int32.Parse(userId);
return(ProgressRepository.GetProgress(ID));
}
public NoteViewModel(Note note, NoteRepository noteRepository, DateTime selectedDate)
{
this._note = note;
this.noteRepository = noteRepository;
this.selectedDate = selectedDate;
typeJobRepository = new TypeJobRepository(Properties.Resources.ConnectCommand);
progressRepository = new ProgressRepository(Properties.Resources.ConnectCommand);
relevanceRepository = new RelevanceRepository(Properties.Resources.ConnectCommand);
TimeStartHours = note.TimeStart.Hours.ToString();
TimeStartMinutes = note.TimeStart.Minutes.ToString();
TimeFinishHours = note.TimeFinish.Hours.ToString();
TimeFinishMinutes = note.TimeFinish.Minutes.ToString();
}
public void GenerateNotes(
NoteRepository noteRepository,
int countNotes
)
{
if (noteRepository == null || countNotes < 1)
{
throw new ArgumentException("noteRepository is null or countNotes <0");
}
Random saintRandom = new Random();
DateTime dateNote = DateTime.Now.AddDays(-1);
List <TypeJob> typeJobs = new TypeJobRepository(Properties.Resources.ConnectCommand).GetAllTypeJobs();
List <Relevance> relevances = new RelevanceRepository(Properties.Resources.ConnectCommand).GetAllRelevances();
List <Progress> progresses = new ProgressRepository(Properties.Resources.ConnectCommand).GetAllProgresses();
for (int i = 0; i < countNotes; i++)
{
noteRepository.RemoveNotes(dateNote);
int[] timeLines = GetTimeLines();
for (int j = 0; j < timeLines.Length - 1; j += 1)
{
Note note = new Note();
note.NoteDate = dateNote;
note.TypeJob = typeJobs[saintRandom.Next(1, 6)];
note.Relevance = relevances[saintRandom.Next(1, 4)];
note.Progress = progresses[saintRandom.Next(1, 4)];
note.TimeStart = new TimeSpan(timeLines[j], 1, 0);
note.TimeFinish = new TimeSpan(timeLines[j + 1], 0, 0);
noteRepository.AddNote(note);
}
dateNote = dateNote.AddDays(-1);
}
}
public IProgressRepository GetProgressRepository()
{
IProgressRepository progressRepository = new ProgressRepository(_session);
return(progressRepository);
}
static async Task Main(string[] args)
{
Console.CancelKeyPress += (sender, eventArgs) =>
{
Console.WriteLine("Cancel event triggered");
Environment.Exit(-1);
};
string storageConnectionString = Environment.GetEnvironmentVariable("CLIMATE_COMPARISON_STORAGE_ACCOUNT");
var storageAccount = CloudStorageAccount.Parse(storageConnectionString);
var tableClient = storageAccount.CreateCloudTableClient();
var progressRepository = new ProgressRepository(tableClient);
int start = await progressRepository.Get(OPERATION) ?? 0;
Console.WriteLine($"Starting from {start}");
var repository = new PrecipitationRepository(tableClient);
string sqlConnectionString = Environment.GetEnvironmentVariable("CLIMATE_COMPARISON_ConnectionStrings__ConnectionString");
using (var sqlConnection = new SqlConnection(sqlConnectionString))
{
sqlConnection.Open();
for (; ;)
{
var placeIds = GetPlaceIds(start, PLACES_BATCH_SIZE, sqlConnection).ToList();
if (placeIds.Count == 0)
{
break;
}
foreach (int id in placeIds)
{
double[] precipitation;
try
{
precipitation = GetPrecipitation(id, sqlConnection).ToArray();
}
catch (SqlException sqlException) when(sqlException.ErrorCode == -2146232060)
{
Console.WriteLine($"can't get precipitation for {id}");
Console.WriteLine(sqlException);
continue;
}
await repository.Save(id, precipitation);
Console.WriteLine($"Processed {id}");
start = id;
}
await progressRepository.Set(OPERATION, start);
Console.WriteLine($"Saved progress {start}");
}
}
}
public ProgressesController(ProgressRepository progressRepository, AssignmentRepository assignmentRepository, UserRepository userRepository)
{
_progressRepository = progressRepository;
_assignmentRepository = assignmentRepository;
_userRepository = userRepository;
}
static async Task Main(string[] args)
{
Console.CancelKeyPress += (sender, eventArgs) =>
{
Console.WriteLine("Cancel event triggered");
Environment.Exit(-1);
};
string storageConnectionString = Environment.GetEnvironmentVariable("CLIMATE_COMPARISON_STORAGE_ACCOUNT");
var storageAccount = CloudStorageAccount.Parse(storageConnectionString);
var tableClient = storageAccount.CreateCloudTableClient();
var placesTable = tableClient.GetTableReference("places");
var progressRepository = new ProgressRepository(tableClient);
int start = await progressRepository.Get(OPERATION) ?? 0;
Console.WriteLine($"Starting from {start}");
string sqlConnectionString = Environment.GetEnvironmentVariable("CLIMATE_ConnectionStrings__ConnectionString");
using (var sqlConnection = new SqlConnection(sqlConnectionString))
{
sqlConnection.Open();
for (; ;)
{
var places = GetPlaces(start, PLACES_BATCH_SIZE, sqlConnection).ToList();
if (places.Count == 0)
{
break;
}
foreach (var place in places)
{
bool insertedRows = false;
var allNames = place.AltNames.Split(",").Union(new[] { place.Name })
.Select(SanitizeName)
.Select(it => it.ToLowerInvariant())
.Where(it => !string.IsNullOrWhiteSpace(it))
.Distinct();
var tasks = allNames.Select(async altName =>
{
var placeEntity = new PlaceEntity
{
PartitionKey = altName,
RowKey = place.Id.ToString(),
Id = place.Id.ToString(),
Name = place.Name,
AltName = altName,
Latitude = place.Latitude,
Longitude = place.Longitude,
CountryCode = place.CountryCode,
Population = place.Population
};
var getOperation = TableOperation.Retrieve <PlaceEntity>(placeEntity.PartitionKey, placeEntity.RowKey);
var existingRecord = await placesTable.ExecuteAsync(getOperation);
if (existingRecord.Result == null)
{
try
{
var insertOperation = TableOperation.Insert(placeEntity);
await placesTable.ExecuteAsync(insertOperation);
insertedRows = true;
}
catch (Exception exception)
{
Console.WriteLine($"Cannot insert {place.Name} {altName}: {exception}");
}
}
});
await Task.WhenAll(tasks);
if (insertedRows)
{
Console.WriteLine($"{place.Name} imported");
}
else
{
Console.WriteLine($"Skipped {place.Name}");
}
start = place.Id;
}
await progressRepository.Set(OPERATION, start);
Console.WriteLine($"Saved progress {start}");
}
}
Console.WriteLine("Done");
}
