private void fmEmpEdit_Load(object sender, EventArgs e)
{
LoadUSStates();
lblEmpID.Text = empID;
string sql = "SELECT * FROM Employee WHERE EmployeeID = " + empID;
Employee emp = new ReaderToModel <Employee>().CreateModel(sql, CommonProcs.WCompanyConnStr);
this.tbFirstName.Text = emp.FirstName;
this.tbMiddleName.Text = emp.MiddleName;
this.tbLastName.Text = emp.LastName;
this.tbAddress1.Text = emp.Address1;
this.tbAddress2.Text = emp.Address2;
this.tbCity.Text = emp.City;
this.cbState.Text = emp.State;
this.tbZip.Text = emp.Zip;
this.tbPhone.Text = emp.Phone;
this.tbEmail.Text = emp.Email;
this.tbSSN.Text = emp.SSN;
this.cbBranch.SelectedIndex = GetBranchIndex(emp.Branch);
this.cbCompany.SelectedIndex = GetCompIndex(emp.QBFile);
cbActive.Checked = emp.IsActive;
cbApprove.Checked = emp.TSApprover;
cbSubmit.Checked = emp.TSSubmitter;
if (emp.FirstName == "New")
{
btnClose.Text = "Cancel";
}
else
{
btnClose.Text = "Close";
}
}
private void LoadLoginGrid()
{
string sql = "SELECT * FROM Login";
List <Login> logins = new ReaderToModel <Login>().CreateList(sql, CommonProcs.WCompanyConnStr);
gvLogins.DataSource = logins;
}
private Login readLoginRecord()
{
string username = tbUser.Text;
string password = tbPass.Text;
string sql = "SELECT * FROM Login WHERE userName = '******' ";
sql += "AND password = '******'";
Login login = new ReaderToModel <Login>().CreateModel(sql, CommonProcs.WCompanyConnStr);
return(login);
}
private void ShowAreaGrid()
{
string sql = "SELECT * FROM Area ";
if (cbFac.SelectedValue != null)
{
sql += "WHERE facId = " + cbFac.SelectedValue.ToString();
}
List <Area> areas = new ReaderToModel <Area>().CreateList(sql, CommonProcs.WCompanyConnStr);
gvArea.DataSource = areas;
}
private void ShowFacGrid()
{
string branch = GetCurrentBranch();
string sql = "SELECT * FROM Facility ";
if (branch != "AA")
{
sql += "WHERE Branch='" + branch + "'";
}
List <Facility> facs = new ReaderToModel <Facility>().CreateList(sql, CommonProcs.WCompanyConnStr);
gvFacility.DataSource = facs;
}
private void fmRequestApproval_Load(object sender, EventArgs e)
{
List <ApprRequest> requests = new List <ApprRequest>();
string sql = "SELECT * FROM Employee WHERE TSApprover = 1";
List <Employee> emps = new ReaderToModel <Employee>().CreateList(sql, CommonProcs.WCompanyConnStr);
foreach (var emp in emps)
{
ApprRequest req = new ApprRequest();
req.EmployeeID = emp.EmployeeID;
req.employeeName = emp.LastName + "," + emp.FirstName;
lbRequest.Items.Add(req.employeeName);
}
}
private void FillGridView(bool fillTimeGrid)
{
string sql = "SELECT TimesheetID,Customer,Facility,Area,";
sql += "ClassEquip,PayrollItem,WorkDate,";
sql += "WorkDay,RegHours,OTHours,Notes ";
sql += "FROM TimesheetEntryGrid WHERE EmployeeID = " + cbEmployee.SelectedValue;
List <TimesheetEntryGrid> gridRows = new ReaderToModel <TimesheetEntryGrid>().CreateList(sql, CommonProcs.WCompanyConnStr);
gvTimesheet.DataSource = gridRows;
if (gridRows.Count > 0)
{
if (fillTimeGrid)
{
lvTime.Items.Clear();
FillTimeGrid(gridRows);
}
}
if (tbTabs.SelectedIndex == 1)
{
FillTotalsView();
}
}
private void FillTotalsView()
{
gvRecap.Columns.Clear();
string branchStr = GetCurrentBranch();
string sql = "SELECT EmployeeID,EmpName,WeekEnding,RegHours,OTHours ";
sql += "FROM TimesheetTotals WHERE WeekEnding = '" + dtpWeekEnding.Value.ToShortDateString() + "'";
if (branchStr != "AA")
{
sql += "AND branch = '" + branchStr.Trim() + "' ";
}
List <TimesheetTotals> totals = new ReaderToModel <TimesheetTotals>().CreateList(sql, CommonProcs.WCompanyConnStr);
foreach (var tot in totals)
{
if (CheckApproved(tot, "SUP"))
{
tot.SupApproved = true;
}
if (CheckApproved(tot, "OM"))
{
tot.OMApproved = true;
}
//if (CheckApproved(tot, "HO"))
// tot.HOApproved = true;
}
gvRecap.DataSource = totals;
DataGridViewButtonColumn viewColumn = new DataGridViewButtonColumn();
viewColumn.HeaderText = "View";
viewColumn.Text = "Timesheet";
viewColumn.Name = "view";
gvRecap.Columns.Add(viewColumn);
viewColumn.UseColumnTextForButtonValue = true;
}