private void ChangeBtnStatus() { AttendanceRecordsHelper dbHelper = new AttendanceRecordsHelper(_appSettings.Secrets.DbConnectionString); AttendanceRecordsData data = dbHelper.SelectData(HttpContext.Session.GetString(Constants.Session.EmployeeId), CurrentDate); DisabledBtnStart = data.StartFlg; DisabledBtnEnd = data.EndFlg; }
public AttendanceRecordsData SelectData(string employeeId, string currentDate) { var data = new AttendanceRecordsData(); using var dataTable = dbHelper.GetDataTable($"select * from AttendanceRecords where UserId = '{employeeId}' and WorkDate = '{currentDate}'"); foreach (var row in dataTable.Rows.Cast <DataRow>()) { data.PrimaryId = int.Parse(row["PrimaryId"].ToString()); data.UserId = row["UserId"].ToString(); data.WorkDate = row["WorkDate"].ToString(); data.StartDate = row["StartDate"].ToString(); data.EndDate = row["EndDate"].ToString(); data.StartFlg = bool.Parse(row["StartFlg"].ToString()); data.EndFlg = bool.Parse(row["EndFlg"].ToString()); } return(data); }
public List <AttendanceRecordsData> SelectFullData(string employeeId) { var dataList = new List <AttendanceRecordsData>(); using var dataTable = dbHelper.GetDataTable($"select * from AttendanceRecords where UserId = '{employeeId}'"); foreach (var row in dataTable.Rows.Cast <DataRow>()) { AttendanceRecordsData data = new AttendanceRecordsData(); data.PrimaryId = int.Parse(row["PrimaryId"].ToString()); data.UserId = row["UserId"].ToString(); data.WorkDate = row["WorkDate"].ToString(); data.StartDate = row["StartDate"].ToString(); data.EndDate = row["EndDate"].ToString(); data.StartFlg = bool.Parse(row["StartFlg"].ToString()); data.EndFlg = bool.Parse(row["EndFlg"].ToString()); dataList.Add(data); } return(dataList); }