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