private void RegisterProjectUptimes()
{
ProjectUptimesHelper dbHelper = new ProjectUptimesHelper(_appSettings.Secrets.DbConnectionString);
try
{
foreach (var item in ProjectList)
{
ProjectUptimesData data = new ProjectUptimesData();
data.WorkDate = DateTime.Parse(TargetDay);
data.ProjectId = item.ProjectId;
data.UserId = HttpContext.Session.GetString(Constants.Session.EmployeeId);
data.WorkMinute = (int)(item.WorkMinute * 60);
data.Remarks = item.Remarks;
if (item.PrimaryId.Equals(null))
{
dbHelper.InsertData(data);
}
else
{
var key = (int)item.PrimaryId;
dbHelper.UpdateData(data, key);
}
}
}
catch (Exception ex)
{
_logger.LogError("Error RegisterProjectUptimes: {0}", ex.Message);
}
}
private List <ProjectUptimesData> GetProjectUptimesList(string projectId)
{
List <ProjectUptimesData> dataList = new List <ProjectUptimesData>();
try
{
ProjectUptimesHelper dbHelper = new ProjectUptimesHelper(_appSettings.Secrets.DbConnectionString);
dataList = dbHelper.SelectProjectData(projectId);
}
catch (Exception ex)
{
_logger.LogError("Error GetProjectUptimes: {0}", ex.Message);
}
return(dataList);
}
