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