public void BindResignationReasonList()
{
dgResignationReasonList.AutoGenerateColumns = false;
dgResignationReasonList.DataSource = clsResignationReason.DSGResignationReasonList();;
dgResignationReasonList.Columns[0].DataPropertyName = "rsgncode";
dgResignationReasonList.Columns[1].DataPropertyName = "rsgnname";
dgResignationReasonList.Columns[2].DataPropertyName = "enabled";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgResignationReasonList.Rows.Count.ToString());
}
public void BindEmployeeTypeList()
{
dgEmployeeTypeList.AutoGenerateColumns = false;
dgEmployeeTypeList.DataSource = clsEmployeeType.DSGEmployeeTypeList();
dgEmployeeTypeList.Columns[0].DataPropertyName = "etypcode";
dgEmployeeTypeList.Columns[1].DataPropertyName = "etypname";
dgEmployeeTypeList.Columns[2].DataPropertyName = "etypdesc";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgEmployeeTypeList.Rows.Count.ToString());
}
public void BindDivisionList()
{
dgDivisionList.AutoGenerateColumns = false;
dgDivisionList.DataSource = Division.GetDSGFormDivisionList();
dgDivisionList.Columns[0].DataPropertyName = "divicode";
dgDivisionList.Columns[1].DataPropertyName = "division";
dgDivisionList.Columns[2].DataPropertyName = "divihead";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgDivisionList.Rows.Count.ToString());
}
public void BindGroupList()
{
dgGroupList.AutoGenerateColumns = false;
dgGroupList.DataSource = Group.DSGFormGroupList();
dgGroupList.Columns[0].DataPropertyName = "GroupCode";
dgGroupList.Columns[1].DataPropertyName = "GroupName";
dgGroupList.Columns[2].DataPropertyName = "Division";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgGroupList.Rows.Count.ToString());
}
public void BindDepartmentList()
{
dgDepartmentList.AutoGenerateColumns = false;
dgDepartmentList.DataSource = Department.GetDSGFormDepartmentList();
dgDepartmentList.Columns[0].DataPropertyName = "DepartmentCode";
dgDepartmentList.Columns[1].DataPropertyName = "DepartmentName";
dgDepartmentList.Columns[2].DataPropertyName = "Group";
dgDepartmentList.Columns[3].DataPropertyName = "Division";
dgDepartmentList.Columns[4].DataPropertyName = "Enabled";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgDepartmentList.Rows.Count.ToString());
}
public void BindHolidayList()
{
dgHolidayList.AutoGenerateColumns = false;
dgHolidayList.DataSource = Holiday.DSGFormHolidayList();
dgHolidayList.Columns[0].DataPropertyName = "holicode";
dgHolidayList.Columns[1].DataPropertyName = "dateapp";
dgHolidayList.Columns[2].DataPropertyName = "shftcode";
dgHolidayList.Columns[3].DataPropertyName = "holidesc";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgHolidayList.Rows.Count.ToString());
}
public void BindEmployeeList() //edited Jan 12, 2018 by calvin cavite (UPDATE Frm: private void, UPDATE To: public void)
{
string strWhere = "";
strWhere = "WHERE lastname LIKE '" + txtLastName.Text.Replace("'", "") + "%' ";
if (cmbJobGrade.SelectedValue.ToString() != "ALL")
{
strWhere += "AND jgcode='" + cmbJobGrade.SelectedValue.ToString() + "' ";
}
if (cmbStatus.SelectedValue.ToString() != "ALL")
{
strWhere += "AND pstatus='" + cmbStatus.SelectedValue.ToString() + "' ";
}
if (cmbEmployeeType.SelectedValue.ToString() != "ALL")
{
strWhere += "AND etypcode='" + cmbEmployeeType.SelectedValue.ToString() + "' ";
}
if (cmbEmployeeStatus.SelectedValue.ToString() != "ALL")
{
strWhere += "AND esttcode='" + cmbEmployeeStatus.SelectedValue.ToString() + "' ";
}
if (cmbDivision.SelectedValue.ToString() != "ALL")
{
strWhere += "AND divicode='" + cmbDivision.SelectedValue.ToString() + "' ";
}
if (cmbGroup.SelectedValue.ToString() != "ALL")
{
strWhere += "AND grpcode='" + cmbGroup.SelectedValue.ToString() + "' ";
}
if (cmbDepartment.SelectedValue.ToString() != "ALL")
{
strWhere += "AND deptcode='" + cmbDepartment.SelectedValue.ToString() + "' ";
}
if (cmbGender.SelectedValue.ToString() != "ALL")
{
strWhere += "AND gender='" + cmbGender.SelectedValue.ToString() + "' ";
}
System.Data.DataTable tblEmployeeList = Employee.DSGEmployeeList(strWhere);
dgEmployeeList.AutoGenerateColumns = false;
dgEmployeeList.DataSource = tblEmployeeList;
dgEmployeeList.Columns[0].DataPropertyName = "Username";
dgEmployeeList.Columns[1].DataPropertyName = "EmployeeNumber";
dgEmployeeList.Columns[2].DataPropertyName = "Lastname";
dgEmployeeList.Columns[3].DataPropertyName = "Firstname";
dgEmployeeList.Columns[4].DataPropertyName = "JGCode";
dgEmployeeList.Columns[5].DataPropertyName = "EmployeeType";
dgEmployeeList.Columns[6].DataPropertyName = "EmploymentStatus";
dgEmployeeList.Columns[7].DataPropertyName = "Division";
dgEmployeeList.Columns[8].DataPropertyName = "Group";
dgEmployeeList.Columns[9].DataPropertyName = "Department";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgEmployeeList.Rows.Count.ToString());
}
public void BindClusterGrid()
{
DataTable tblCluster = clsCluster.GetDataTable();
dgClusterList.AutoGenerateColumns = false;
dgClusterList.DataSource = tblCluster;
dgClusterList.Columns[0].DataPropertyName = "cluscode";
dgClusterList.Columns[1].DataPropertyName = "clusname";
dgClusterList.Columns[2].DataPropertyName = "penabled";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgClusterList.Rows.Count.ToString());
}
public void BindRCList()
{
dgRCList.AutoGenerateColumns = false;
dgRCList.DataSource = clsRC.DSGMainForm();
dgRCList.Columns[0].DataPropertyName = "RCCode";
dgRCList.Columns[1].DataPropertyName = "RCName";
dgRCList.Columns[2].DataPropertyName = "Division";
dgRCList.Columns[3].DataPropertyName = "GPCode";
dgRCList.Columns[4].DataPropertyName = "Company";
dgRCList.Columns[5].DataPropertyName = "Status";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgRCList.Rows.Count.ToString());
}
public void BindChangeShiftGrid()
{
DataTable tblChangeShift = clsChangeShiftBatch.GetDataTable();
dgChangeShiftList.AutoGenerateColumns = false;
dgChangeShiftList.DataSource = tblChangeShift;
dgChangeShiftList.Columns[0].DataPropertyName = "csbcode";
dgChangeShiftList.Columns[1].DataPropertyName = "shftcode";
dgChangeShiftList.Columns[2].DataPropertyName = "appdate";
dgChangeShiftList.Columns[3].DataPropertyName = "preason";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgChangeShiftList.Rows.Count.ToString());
}
public void BindShiftList()
{
dgShiftList.AutoGenerateColumns = false;
dgShiftList.DataSource = clsShift.DSGFormShiftList();;
dgShiftList.Columns[0].DataPropertyName = "ShiftCode";
dgShiftList.Columns[1].DataPropertyName = "ShiftMode";
dgShiftList.Columns[2].DataPropertyName = "TotalHours";
dgShiftList.Columns[3].DataPropertyName = "TimeStart";
dgShiftList.Columns[4].DataPropertyName = "TimeHalf";
dgShiftList.Columns[5].DataPropertyName = "TimeEnd";
dgShiftList.Columns[6].DataPropertyName = "BreakStart";
dgShiftList.Columns[7].DataPropertyName = "BreakEnd";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgShiftList.Rows.Count.ToString());
}
public void BindScheduleList()
{
dgScheduleList.AutoGenerateColumns = false;
dgScheduleList.DataSource = clsSchedule.DSGScheduleList();
dgScheduleList.Columns[0].DataPropertyName = "schdcode";
dgScheduleList.Columns[1].DataPropertyName = "monshift";
dgScheduleList.Columns[2].DataPropertyName = "tueshift";
dgScheduleList.Columns[3].DataPropertyName = "wedshift";
dgScheduleList.Columns[4].DataPropertyName = "thushift";
dgScheduleList.Columns[5].DataPropertyName = "frishift";
dgScheduleList.Columns[6].DataPropertyName = "satshift";
dgScheduleList.Columns[7].DataPropertyName = "sunshift";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgScheduleList.Rows.Count.ToString());
}
public void BindLeaveTypeList()
{
DataTable tblCluster = LeaveApplicationTypes.DSGLeaveTypeList();
dgLeaveTypeList.AutoGenerateColumns = false;
dgLeaveTypeList.DataSource = tblCluster;
dgLeaveTypeList.Columns[0].DataPropertyName = "leavtype";
dgLeaveTypeList.Columns[1].DataPropertyName = "ltdesc";
dgLeaveTypeList.Columns[2].DataPropertyName = "withpay";
dgLeaveTypeList.Columns[3].DataPropertyName = "maxbal";
dgLeaveTypeList.Columns[4].DataPropertyName = "hasbal";
dgLeaveTypeList.Columns[5].DataPropertyName = "pstatus";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgLeaveTypeList.Rows.Count.ToString());
}
public void BindLeaveList()
{
dgLeaveList.AutoGenerateColumns = false;
dgLeaveList.DataSource = LeaveApplication.GetDSGFormLeaveList(txtRequestor.Text, txtReason.Text, cmbStatus.SelectedValue.ToString(), cmbLeaveType.SelectedValue.ToString(), dtpFrom.Value.Date, clsDateTime.ChangeTimeToEnd(dtpTo.Value));
dgLeaveList.Columns[0].DataPropertyName = "leavcode";
dgLeaveList.Columns[1].DataPropertyName = "status";
dgLeaveList.Columns[2].DataPropertyName = "requestor";
dgLeaveList.Columns[3].DataPropertyName = "leavtype";
dgLeaveList.Columns[4].DataPropertyName = "datefile";
dgLeaveList.Columns[5].DataPropertyName = "datestart";
dgLeaveList.Columns[6].DataPropertyName = "dateend";
dgLeaveList.Columns[7].DataPropertyName = "unit";
dgLeaveList.Columns[8].DataPropertyName = "approver";
dgLeaveList.Columns[9].DataPropertyName = "reason";
dgLeaveList.Columns[10].DataPropertyName = "statuscode";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgLeaveList.Rows.Count.ToString());
}
public void BindOffenseList()
{
dgOffenseList.AutoGenerateColumns = false;
dgOffenseList.DataSource = clsOffense.GetDSGMainForm();
dgOffenseList.Columns[0].DataPropertyName = "OffenseCode";
dgOffenseList.Columns[1].DataPropertyName = "Name";
dgOffenseList.Columns[2].DataPropertyName = "Details";
dgOffenseList.Columns[3].DataPropertyName = "Class";
dgOffenseList.Columns[4].DataPropertyName = "DateStart";
dgOffenseList.Columns[5].DataPropertyName = "DateEnd";
dgOffenseList.Columns[6].DataPropertyName = "Enabled";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgOffenseList.Rows.Count.ToString());
if (_strIndicator == "1")
{
_mdiIpanema.LoadDSGOffenseNotification();
}
}
public void BindTimesheetPeriodList()
{
dgTSPList.AutoGenerateColumns = false;
dgTSPList.DataSource = clsTimeSheetPeriod.DSGTimeSheetPeriodList();
dgTSPList.Columns[0].DataPropertyName = "tspcode";
dgTSPList.Columns[1].DataPropertyName = "tspfrom";
dgTSPList.Columns[2].DataPropertyName = "tspto";
dgTSPList.Columns[3].DataPropertyName = "tspdesc";
dgTSPList.Columns[4].DataPropertyName = "tspmode";
dgTSPList.Columns[5].DataPropertyName = "postdata";
dgTSPList.Columns[6].DataPropertyName = "pstatus";
foreach (DataGridViewRow dgvr in dgTSPList.Rows)
{
dgvr.Cells[5].Value = (dgvr.Cells[5].Value.ToString() == "1" ? true : false);
dgvr.Cells[6].Value = (dgvr.Cells[6].Value.ToString() == "1" ? true : false);
}
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgTSPList.Rows.Count.ToString());
}
public void BindOBList()
{
dgOBList.AutoGenerateColumns = false;
dgOBList.DataSource = OfficialBusiness.GetDSGOBMainForm(txtRequestor.Text, txtReason.Text, dtpFrom.Value, dtpTo.Value, cmbOBType.SelectedValue.ToString(), cmbStatus.SelectedValue.ToString());
dgOBList.Columns[0].DataPropertyName = "OBCode";
dgOBList.Columns[1].DataPropertyName = "StatusCode";
dgOBList.Columns[2].DataPropertyName = "StatusDesc";
dgOBList.Columns[3].DataPropertyName = "Requestor";
dgOBList.Columns[4].DataPropertyName = "OBTypeDesc";
dgOBList.Columns[5].DataPropertyName = "DateFile";
dgOBList.Columns[6].DataPropertyName = "DateStart";
dgOBList.Columns[7].DataPropertyName = "DateEnd";
dgOBList.Columns[8].DataPropertyName = "RenderedTo";
dgOBList.Columns[9].DataPropertyName = "Reason";
dgOBList.Columns[10].DataPropertyName = "RApprover";
dgOBList.Columns[11].DataPropertyName = "HApprover";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgOBList.Rows.Count.ToString());
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (HRMSCore.Login(txtUsername.Text, txtPassword.Text))
{
HRMSCore.Username = txtUsername.Text;
HRMSCore.LoginDate = DateTime.Now;
HRMSCore.Password = txtPassword.Text;
mdiIpanema pForm = new mdiIpanema();
pForm.FormLogin = this;
pForm.Show();
this.Hide();
txtPassword.Text = "";
}
else
{
MessageBox.Show("Invalid username/password", clsMessageBox.MessageBoxText, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtUsername.Focus();
}
}
public void BindLeaveBalanceList()
{
Cursor.Current = Cursors.WaitCursor;
string strWhere = "WHERE username IN (SELECT username FROM HR.Employees WHERE lastname LIKE '" + txtLastName.Text.Replace("'", "") + "%') ";
if (cmbLeaveType.Items.Count > 0)
{
if (cmbLeaveType.SelectedValue.ToString() != "ALL")
{
strWhere += "AND leavtype='" + cmbLeaveType.SelectedValue.ToString() + "' ";
}
}
if (cmbStatus.Items.Count > 0)
{
if (cmbStatus.SelectedValue.ToString() != "ALL")
{
strWhere += "AND pstatus='" + cmbStatus.SelectedValue.ToString() + "' ";
}
}
dgEntitlementList.AutoGenerateColumns = false;
dgEntitlementList.DataSource = LeaveApplicationBalance.DSGFormLeaveEntitlementList(strWhere);
dgEntitlementList.Columns[0].DataPropertyName = "Username";
dgEntitlementList.Columns[1].DataPropertyName = "LeaveTypeCode";
dgEntitlementList.Columns[2].DataPropertyName = "EmployeeName";
dgEntitlementList.Columns[3].DataPropertyName = "LeaveType";
dgEntitlementList.Columns[4].DataPropertyName = "Entitled";
dgEntitlementList.Columns[5].DataPropertyName = "Used";
dgEntitlementList.Columns[6].DataPropertyName = "Balance";
dgEntitlementList.Columns[7].DataPropertyName = "Status";
foreach (DataGridViewRow dgvr in dgEntitlementList.Rows)
{
dgvr.Cells[7].Value = (dgvr.Cells[7].Value.ToString() == "1" ? "Enabled" : "Disabled");
}
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgEntitlementList.Rows.Count.ToString());
Cursor.Current = Cursors.Default;
}
public void BindUndertimeList()
{
string strWhere = "WHERE username IN (SELECT username FROM HR.Employees WHERE lastname LIKE '" + txtRequestor.Text.Replace("'", "") + "%') AND (dateapp BETWEEN '" + clsDateTime.ChangeTimeToStart(dtpFrom.Value).ToString() + "' AND '" + clsDateTime.ChangeTimeToEnd(dtpTo.Value).ToString() + "') AND reason LIKE '%" + txtReason.Text.Replace("'", "") + "%' ";
if (cmbStatus.SelectedValue.ToString() != "ALL")
{
strWhere = strWhere + "AND utstat='" + cmbStatus.SelectedValue + "' ";
}
dgUndertimeList.AutoGenerateColumns = false;
dgUndertimeList.DataSource = clsUndertime.DSGFormUndertimeList(strWhere);
dgUndertimeList.Columns[0].DataPropertyName = "utcode";
dgUndertimeList.Columns[1].DataPropertyName = "statuscode";
dgUndertimeList.Columns[2].DataPropertyName = "status";
dgUndertimeList.Columns[3].DataPropertyName = "requestor";
dgUndertimeList.Columns[4].DataPropertyName = "datefile";
dgUndertimeList.Columns[5].DataPropertyName = "dateapp";
dgUndertimeList.Columns[6].DataPropertyName = "approver";
dgUndertimeList.Columns[7].DataPropertyName = "reason";
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgUndertimeList.Rows.Count.ToString());
}
public void BindUsersList()
{
string strWhere = "";
if (cmbStatus.SelectedValue.ToString() != "ALL")
{
strWhere = "WHERE Users.Users.pstatus='" + cmbStatus.SelectedValue + "' ";
}
dgPortalUsersList.AutoGenerateColumns = false;
dgPortalUsersList.DataSource = clsUsers.GetDSG(strWhere);
dgPortalUsersList.Columns[0].DataPropertyName = "username";
dgPortalUsersList.Columns[1].DataPropertyName = "pname";
dgPortalUsersList.Columns[2].DataPropertyName = "emptitle";
dgPortalUsersList.Columns[3].DataPropertyName = "pstatus";
foreach (DataGridViewRow dgvr in dgPortalUsersList.Rows)
{
dgvr.Cells[3].Value = (dgvr.Cells[3].Value.ToString() == "1" ? "Enabled" : "Disabled");
}
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgPortalUsersList.Rows.Count.ToString());
}
private void frmOBList_Deactivate(object sender, EventArgs e)
{
HRMSCore.UpdateStatusBarFormInfo("");
}
private void frmOBList_Activated(object sender, EventArgs e)
{
HRMSCore.UpdateStatusBarFormInfo("Total Records: " + dgOBList.Rows.Count.ToString());
}
private void frmChangeShiftBatchList_Deactivate(object sender, EventArgs e)
{
HRMSCore.UpdateStatusBarFormInfo("");
}