public async Task <bool> AddLogTimeAsync(LogTimeModel LogTime)
{
using (SqlConnection conn = GetConnection())
{
conn.Open();
var transaction = conn.BeginTransaction();
try
{
var list = new List <ProjectTaskModel>();
DynamicParameters param = new DynamicParameters();
if (LogTime.LogId > 0)
{
param.Add("@LogId", LogTime.LogId);
}
param.Add("@UserId", LogTime.UserId);
param.Add("@LogDate", LogTime.LogDate);
param.Add("@StartTime", LogTime.StartTime);
param.Add("@EndTime", LogTime.EndTime);
param.Add("@CreatedBy", LogTime.CreatedBy);
int TaskId = await transaction.Connection.ExecuteScalarAsync <int>("sp_AddLogTime", param, transaction : transaction, commandType : CommandType.StoredProcedure);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
return(false);
}
}
}
public async Task LogStart(string userName, LogTimeModel logTimeModel)
{
var timeStamp = logTimeModel.Timestamp !.Value;
var workTime = await GetWorkTime(userName, timeStamp);
workTime.StartTimes.Add(timeStamp);
await InsertOrUpdateWorkTimes(workTime);
}
public async Task <IActionResult> AddLogTime()
{
LogTimeModel logTimeModel = new LogTimeModel();
var result = await this._repository.GetUsersAsync(null);
logTimeModel.Users = result.Select(x => new SelectListItem {
Text = x.FirstName + " " + x.LastName, Value = x.Id.ToString()
}).ToList();
return(View(logTimeModel));
}
public IActionResult LogTime(LogTimeModel model)
{
if (ModelState.IsValid)
{
var res = _userService.LogTime(model);
return(res ? Ok(true) : Ok("Server error"));
}
return(Ok("Please, fill in all fields"));
}
public ActionResult Add(LogTimeModel model)
{
try
{
var logtime = LogTimeModelIMapper.MapToLogTime(model);
LogTimeHandler.Add(logtime);
}
catch (Exception ex)
{
model.Error = ex.Message;
return(View("Add", model));
}
return(RedirectToAction("Index"));
}
public bool LogTime(LogTimeModel model)
{
var projectPerfomrer = from pp in _context.ProjectPerformers
join p in _context.Projects on model.ProjectPK equals p.ProjectPK
join u in _context.Users on model.UserPK equals u.Id
where pp.Performer.Id == u.Id && pp.Project.ProjectPK == p.ProjectPK
select pp;
var result = _context.ProjectPerformerHistories.Add(new ProjectPerformerHistory
{
ProjectPerformer = projectPerfomrer.First(),
SpentHours = model.LoggedTime,
WorkDay = model.Date
});
_context.SaveChanges();
return(result != null);
}
public async Task <IActionResult> AddLogTime(LogTimeModel logTimeModel)
{
logTimeModel.CreatedBy = this.UserId;
if (await this._repository.AddLogTimeAsync(logTimeModel))
{
logTimeModel = new LogTimeModel();
var result = await this._repository.GetUsersAsync(null);
ModelState.Clear();
logTimeModel.Users = result.Select(x => new SelectListItem {
Text = x.FirstName + " " + x.LastName, Value = x.Id.ToString()
}).ToList();
ViewBag.Success = "Time has been logged";
}
else
{
ViewBag.Error = "There are error while saving";
}
return(View(logTimeModel));
}
private async Task OnActivityStateChanged(ActivityEventArgs eventArgs)
{
_retryCancellationTokenSource.Cancel();
_retryCancellationTokenSource = new CancellationTokenSource();
var logTimeModel = new LogTimeModel()
{
IsActive = eventArgs.IsActive,
Timestamp = eventArgs.TimeStamp,
};
var httpContent = new StringContent(
JsonSerializer.Serialize(logTimeModel),
Encoding.UTF8,
"application/json");
await _retryPolicy.ExecuteAsync(
(ctx, ct) => _httpClient.PostAsync(FunctionMap.Get(Function.LogTime), httpContent, ct),
_retryContext,
_retryCancellationTokenSource.Token);
}
public ActionResult NewLogTime()
{
var l = new LogTimeModel();
return(View(l));
}
public LogTimeModel TestPerformance()
{
LogTimeModel model = new LogTimeModel();
Stopwatch timer = new Stopwatch();
var lstProduct1510 = productDal.GetListProduct15(10);
var lstProduct15100 = productDal.GetListProduct15(100);
var lstProduct151000 = productDal.GetListProduct15(1000);
var lstProduct1510000 = productDal.GetListProduct15(10000);
var lstProduct15100000 = productDal.GetListProduct15(100000);
var lstProduct151000000 = productDal.GetListProduct15(1000000);
var lstProduct5010 = productDal.GetListProduct50(10);
var lstProduct50100 = productDal.GetListProduct50(100);
var lstProduct501000 = productDal.GetListProduct50(1000);
var lstProduct5010000 = productDal.GetListProduct50(10000);
var lstProduct50100000 = productDal.GetListProduct50(100000);
var lstProduct501000000 = productDal.GetListProduct50(1000000);
// Case 1: Manual - 15 - 10
timer.Start();
var resultMap1510 = lstProduct1510.Select(x => new ProductModel15(x));
timer.Stop();
model.Manual15_10 = timer.ElapsedTicks;
timer.Reset();
// Case 2: Normal - 15 - 10
timer.Start();
var resultMapNormal1510 = mapper.Map <List <ProductDto15>, List <ProductModel15> >(lstProduct1510);
timer.Stop();
model.Normal15_10 = timer.ElapsedTicks;
timer.Reset();
// Case 3: Complex - 15 - 10
timer.Start();
var resultMapComplex1510 = mapper.Map <List <ProductDto15>, List <ProductModelComplex15> >(lstProduct1510);
timer.Stop();
model.Complex15_10 = timer.ElapsedTicks;
timer.Reset();
// Case 4: Manual - 15 - 100
timer.Start();
var resultMapManual15100 = lstProduct15100.Select(x => new ProductModel15(x));
timer.Stop();
model.Manual15_100 = timer.ElapsedTicks;
timer.Reset();
// Case 5: Normal - 15 - 100
timer.Start();
var resultMapNormal15100 = mapper.Map <List <ProductDto15>, List <ProductModel15> >(lstProduct15100);
timer.Stop();
model.Normal15_100 = timer.ElapsedTicks;
timer.Reset();
// Case 6: Complex - 15 - 100
timer.Start();
var resultMapComplex15100 = mapper.Map <List <ProductDto15>, List <ProductModelComplex15> >(lstProduct15100);
timer.Stop();
model.Complex15_100 = timer.ElapsedTicks;
timer.Reset();
// Case 7: Manual - 15 - 1000
timer.Start();
var resultMapManual151000 = lstProduct151000.Select(x => new ProductModel15(x));
timer.Stop();
model.Manual15_1000 = timer.ElapsedTicks;
timer.Reset();
// Case 8: Normal - 15 - 1000
timer.Start();
var resultMapNormal151000 = mapper.Map <List <ProductDto15>, List <ProductModel15> >(lstProduct151000);
timer.Stop();
model.Normal15_1000 = timer.ElapsedTicks;
timer.Reset();
// Case 9: Complex - 15 - 1000
timer.Start();
var resultMapComplex151000 = mapper.Map <List <ProductDto15>, List <ProductModelComplex15> >(lstProduct151000);
timer.Stop();
model.Complex15_1000 = timer.ElapsedTicks;
timer.Reset();
// Case 10: Manual - 15 - 10000
timer.Start();
var resultMapManual1510000 = lstProduct1510000.Select(x => new ProductModel15(x));
timer.Stop();
model.Manual15_10000 = timer.ElapsedTicks;
timer.Reset();
// Case 11: Normal - 15 - 10000
timer.Start();
var resultMapNormal1510000 = mapper.Map <List <ProductDto15>, List <ProductModel15> >(lstProduct1510000);
timer.Stop();
model.Normal15_10000 = timer.ElapsedTicks;
timer.Reset();
// Case 12: Complex - 15 - 10000
timer.Start();
var resultMapComplex1510000 = mapper.Map <List <ProductDto15>, List <ProductModelComplex15> >(lstProduct1510000);
timer.Stop();
model.Complex15_10000 = timer.ElapsedTicks;
timer.Reset();
// Case 13: Manual - 15 - 100000
timer.Start();
var resultMapManual15100000 = lstProduct15100000.Select(x => new ProductModel15(x));
timer.Stop();
model.Manual15_100000 = timer.ElapsedTicks;
timer.Reset();
// Case 14: Normal - 15 - 100000
timer.Start();
var resultMapNormal15100000 = mapper.Map <List <ProductDto15>, List <ProductModel15> >(lstProduct15100000);
timer.Stop();
model.Normal15_100000 = timer.ElapsedTicks;
timer.Reset();
// Case 15: Complex - 15 - 100000
timer.Start();
var resultMapComplex15100000 = mapper.Map <List <ProductDto15>, List <ProductModelComplex15> >(lstProduct15100000);
timer.Stop();
model.Complex15_100000 = timer.ElapsedTicks;
timer.Reset();
// Case 16: Manual - 15 - 1000000
timer.Start();
var resultMapManual151000000 = lstProduct151000000.Select(x => new ProductModel15(x));
timer.Stop();
model.Manual15_1000000 = timer.ElapsedTicks;
timer.Reset();
// Case 17: Normal - 15 - 1000000
timer.Start();
var resultMapNormal151000000 = mapper.Map <List <ProductDto15>, List <ProductModel15> >(lstProduct151000000);
timer.Stop();
model.Normal15_1000000 = timer.ElapsedTicks;
timer.Reset();
// Case 18: Complex - 15 - 100000
timer.Start();
var resultMapComplex151000000 = mapper.Map <List <ProductDto15>, List <ProductModelComplex15> >(lstProduct151000000);
timer.Stop();
model.Complex15_1000000 = timer.ElapsedTicks;
timer.Reset();
/////////////////// 50 ////////////////////////////
// Case 1: Manual - 50 - 10
timer.Start();
var resultMap5010 = lstProduct5010.Select(x => new ProductModel50(x));
timer.Stop();
model.Manual50_10 = timer.ElapsedTicks;
timer.Reset();
// Case 2: Normal - 50 - 10
timer.Start();
var resultMapNormal5010 = mapper.Map <List <ProductDto50>, List <ProductModel50> >(lstProduct5010);
timer.Stop();
model.Normal50_10 = timer.ElapsedTicks;
timer.Reset();
// Case 3: Complex - 50 - 10
timer.Start();
var resultMapComplex5010 = mapper.Map <List <ProductDto50>, List <ProductModelComplex50> >(lstProduct5010);
timer.Stop();
model.Complex50_10 = timer.ElapsedTicks;
timer.Reset();
// Case 4: Manual - 50 - 100
timer.Start();
var resultMapManual50100 = lstProduct50100.Select(x => new ProductModel50(x));
timer.Stop();
model.Manual50_100 = timer.ElapsedTicks;
timer.Reset();
// Case 5: Normal - 50 - 100
timer.Start();
var resultMapNormal50100 = mapper.Map <List <ProductDto50>, List <ProductModel50> >(lstProduct50100);
timer.Stop();
model.Normal50_100 = timer.ElapsedTicks;
timer.Reset();
// Case 6: Complex - 50 - 100
timer.Start();
var resultMapComplex50100 = mapper.Map <List <ProductDto50>, List <ProductModelComplex50> >(lstProduct50100);
timer.Stop();
model.Complex50_100 = timer.ElapsedTicks;
timer.Reset();
// Case 7: Manual - 50 - 1000
timer.Start();
var resultMapManual501000 = lstProduct501000.Select(x => new ProductModel50(x));
timer.Stop();
model.Manual50_1000 = timer.ElapsedTicks;
timer.Reset();
// Case 8: Normal - 50 - 1000
timer.Start();
var resultMapNormal501000 = mapper.Map <List <ProductDto50>, List <ProductModel50> >(lstProduct501000);
timer.Stop();
model.Normal50_1000 = timer.ElapsedTicks;
timer.Reset();
// Case 9: Complex - 50 - 1000
timer.Start();
var resultMapComplex501000 = mapper.Map <List <ProductDto50>, List <ProductModelComplex50> >(lstProduct501000);
timer.Stop();
model.Complex50_1000 = timer.ElapsedTicks;
timer.Reset();
// Case 10: Manual - 50 - 10000
timer.Start();
var resultMapManual5010000 = lstProduct5010000.Select(x => new ProductModel50(x));
timer.Stop();
model.Manual50_10000 = timer.ElapsedTicks;
timer.Reset();
// Case 11: Normal - 50 - 10000
timer.Start();
var resultMapNormal5010000 = mapper.Map <List <ProductDto50>, List <ProductModel50> >(lstProduct5010000);
timer.Stop();
model.Normal50_10000 = timer.ElapsedTicks;
timer.Reset();
// Case 12: Complex - 50 - 10000
timer.Start();
var resultMapComplex5010000 = mapper.Map <List <ProductDto50>, List <ProductModelComplex50> >(lstProduct5010000);
timer.Stop();
model.Complex50_10000 = timer.ElapsedTicks;
timer.Reset();
// Case 13: Manual - 50 - 100000
timer.Start();
var resultMapManual50100000 = lstProduct50100000.Select(x => new ProductModel50(x));
timer.Stop();
model.Manual50_100000 = timer.ElapsedTicks;
timer.Reset();
// Case 14: Normal - 50 - 100000
timer.Start();
var resultMapNormal50100000 = mapper.Map <List <ProductDto50>, List <ProductModel50> >(lstProduct50100000);
timer.Stop();
model.Normal50_100000 = timer.ElapsedTicks;
timer.Reset();
// Case 50: Complex - 50 - 100000
timer.Start();
var resultMapComplex50100000 = mapper.Map <List <ProductDto50>, List <ProductModelComplex50> >(lstProduct50100000);
timer.Stop();
model.Complex50_100000 = timer.ElapsedTicks;
timer.Reset();
// Case 16: Manual - 50 - 1000000
timer.Start();
var resultMapManual501000000 = lstProduct501000000.Select(x => new ProductModel50(x));
timer.Stop();
model.Manual50_1000000 = timer.ElapsedTicks;
timer.Reset();
// Case 17: Normal - 50 - 1000000
timer.Start();
var resultMapNormal501000000 = mapper.Map <List <ProductDto50>, List <ProductModel50> >(lstProduct501000000);
timer.Stop();
model.Normal50_1000000 = timer.ElapsedTicks;
timer.Reset();
// Case 18: Complex - 50 - 100000
timer.Start();
var resultMapComplex501000000 = mapper.Map <List <ProductDto50>, List <ProductModelComplex50> >(lstProduct501000000);
timer.Stop();
model.Complex50_1000000 = timer.ElapsedTicks;
timer.Reset();
return(model);
}
