protected void viewTimeSheet_RowCommand(object sender, GridViewCommandEventArgs e)
{
//Allow manager to select a timesheet and view selected
//Accesses Unsigned Timesheets
btnUpdateMV.Visible = true;
btnAccept1MV.Visible = true;
empinfo.Visible = true;
DataTable unsignedTimesheets = Session["MangV"] as DataTable;
List <Global.DataFileInfo> UnapprovedFiles = Global.UnapprovedFiles;
if (e.CommandName == "ViewTimeSheet")
{
DataFile df = new DataFile();
int index = Convert.ToInt32(e.CommandArgument);
string usrName = Global.ReadDataString($"SELECT RESOURCENAME FROM EMPLOYEES WHERE EMPNAME='{unsignedTimesheets.Rows[index].Field<string>(0)}';");
string date = unsignedTimesheets.Rows[index].Field <string>(1);
string managerName = Session["ManagerName"].ToString();
ManagerView.Columns[0].Visible = false;
df.Read($"{usrName} {date} {managerName}");
DataTable FileData = df;
ManagerView.DataSource = FileData;
ManagerView.DataBind();
Tuple <string, float> DT = df.GetDateAndTime();
string employeeName = unsignedTimesheets.Rows[index].Field <string>(0);
string dateSub = DT.Item1;
string hoursWorked = Global.TimeToString(DT.Item2);
NameViewLabel.Text = "Employee Name: " + employeeName;
DateViewLabel.Text = "Date Submited: " + dateSub;
TotalHoursLabel.Text = "Total Time Worked: " + hoursWorked;
List <string> empData = new List <string>();
empData.Add(employeeName);
empData.Add(dateSub);
empData.Add(hoursWorked);
Session["DataFile"] = df;
Session["empData"] = empData;
//Server.Transfer("ManagerFileUpdate.aspx", true);
}
}
private void ShowFiles(string manager)
{
List <Global.DataFileInfo> UnapprovedFiles = Global.UnapprovedFiles;
DataTable unsignedTimesheets = Session["MangV"] as DataTable;
foreach (Global.DataFileInfo data in UnapprovedFiles)
{
if (data.manager == manager)
{
DataRow dr = unsignedTimesheets.NewRow();
dr["Name"] = Global.ReadDataString($"SELECT EMPNAME FROM EMPLOYEES WHERE RESOURCENAME='{data.name}';");
dr["Date Submitted"] = data.date;
unsignedTimesheets.Rows.Add(dr);
ManagerView.DataSource = unsignedTimesheets;
ManagerView.DataBind();
Session["MangV"] = unsignedTimesheets;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["MangV"] = "";
//Functions that run on page load
string ManagerNameData = Session["ManagerName"].ToString();
ManagerName.InnerText = Global.ReadDataString($"SELECT EMPNAME FROM EMPLOYEES WHERE RESOURCENAME='{ManagerNameData}';");
DataTable unsignedTimesheets = new DataTable();
unsignedTimesheets.Columns.Add("Name");
unsignedTimesheets.Columns.Add("Date Submitted");
ManagerView.DataSource = unsignedTimesheets;
ManagerView.DataBind();
Session["MangV"] = unsignedTimesheets;
ShowFiles(ManagerNameData);
}
}