private void BindList()
{
DataTable tblIncluded = CDL.GetDSIncludedEmployee(_strCDLCode);
lvIncluded.Items.Clear();
foreach (DataRow drw in tblIncluded.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Tag = drw["username"].ToString();
lvi.Text = drw["lastname"].ToString() + ", " + drw["firname"].ToString();
lvIncluded.Items.Add(lvi);
}
DataTable tblExclude = CDL.GetDSExcludedEmployee(_strCDLCode);
lvExcluded.Items.Clear();
foreach (DataRow drw in tblExclude.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Tag = drw["username"].ToString();
lvi.Text = drw["lastname"].ToString() + ", " + drw["firname"].ToString();
lvi.SubItems.Add(LeaveApplicationBalance.GetRemainingBalance(drw["username"].ToString(), cmbLeaveType.SelectedValue.ToString()).ToString());
lvExcluded.Items.Add(lvi);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsCorrectData())
{
using (LeaveApplicationBalance lb = new LeaveApplicationBalance())
{
lb.Username = cmbEmployee.SelectedValue.ToString();
lb.LeaveTypeCode = _strLeaveTypeCode;
lb.Balance = clsValidator.CheckFloat(txtBalance.Text);
lb.Entitlement = clsValidator.CheckFloat(txtEntitlement.Text);
lb.Status = "1";
lb.Insert();
if (_FormCaller == FormCallers.EmployeeDetails)
{
_frmEmployeeDetails.LoadLeaveTypes();
_frmEmployeeDetails.LoadLeaveEntitlement();
}
else if (_FormCaller == FormCallers.LeaveEntitlementList)
{
_frmLeaveEntitlementList.BindLeaveBalanceList();
}
this.Close();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsCorrectData())
{
using (LeaveApplicationBalance lb = new LeaveApplicationBalance())
{
lb.Username = _strUsername;
lb.LeaveTypeCode = _strLeaveTypeCode;
lb.Balance = clsValidator.CheckFloat(txtBalance.Text);
lb.Entitlement = clsValidator.CheckFloat(txtEntitlement.Text);
lb.Status = (chkStatus.Checked ? "1" : "0");
lb.Update();
if (_FormCaller == FormCallers.EmployeeDetails)
{
_frmEmployeeDetails.LoadLeaveEntitlement();
}
else if (_FormCaller == FormCallers.LeaveEntitlementList)
{
_frmLeaveEntitlementList.BindLeaveBalanceList();
}
_frmMdiCaller.DSGZeroEL();
_frmMdiCaller.DSGZeroVL();
_frmMdiCaller.DSGZeroSL();
this.Close();
}
}
}
//public mdiIpanema MDIIpanema { get { return _mdiIpanema; } set { _mdiIpanema = value; } }
private void InitializeFields()
{
txtEmployee.Text = Employee.GetName(_strUsername);
using (LeaveApplicationTypes lt = new LeaveApplicationTypes())
{
lt.LeaveTypeCode = _strLeaveTypeCode;
lt.Fill();
txtLeaveTypeCode.Text = _strLeaveTypeCode;
txtLeaveType.Text = lt.LeaveType;
txtWithPay.Text = clsValidator.ToYesNo(lt.WithPay);
txtMaxBalance.Text = lt.MaximumBalance.ToString();
txtHasBalance.Text = clsValidator.ToYesNo(lt.HasBalance);
txtBalance.Enabled = (lt.HasBalance == "1");
txtEntitlement.Enabled = (lt.HasBalance == "1");
}
using (LeaveApplicationBalance lb = new LeaveApplicationBalance())
{
lb.LeaveTypeCode = _strLeaveTypeCode;
lb.Username = _strUsername;
lb.Fill();
txtBalance.Text = lb.Balance.ToString();
chkStatus.Checked = (lb.Status == "1" ? true : false);
txtEntitlement.Text = lb.Entitlement.ToString();
}
}
private void btnExcludeAll_Click(object sender, EventArgs e)
{
foreach (ListViewItem itm in lvIncluded.Items)
{
bool blnCancelLeave = false;
bool blnHasBalance = false;
string strLeaveTypeCode = "";
string strUsername = itm.Tag.ToString();
string strLeaveCode = CDL.GetLeaveCode(strUsername, _strCDLCode);
using (LeaveApplication leave = new LeaveApplication())
{
leave.LeaveCode = strLeaveCode;
leave.Fill();
strLeaveTypeCode = leave.LeaveType;
leave.Status = "C";
blnCancelLeave = leave.UpdateAdmin() > 0;
}
blnHasBalance = LeaveApplicationTypes.IsHasBalance(strLeaveTypeCode);
if (blnHasBalance && blnCancelLeave)
{
LeaveApplicationBalance.AddLeaveBalance(1, strUsername, strLeaveTypeCode);
}
if (blnCancelLeave)
{
CDL.RemoveMember(_strCDLCode, strUsername);
}
}
this.BindList();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsCorrectData())
{
using (LeaveApplication leave = new LeaveApplication())
{
leave.LeaveCode = txtLeaveCode.Text;
leave.Fill();
leave.Reason = txtReason.Text;
leave.ApproverDate = clsDateTime.CombineDateTime(dtpApproverDate.Value, dtpApproverTime.Value);
leave.Status = cmbStatus.SelectedValue.ToString();
leave.UpdateAdmin();
if (cmbStatus.SelectedValue.ToString() == "A" && _strStatus != "A" && LeaveApplicationTypes.IsHasBalance(_strLeaveTypeCode))
{
LeaveApplicationBalance.DeductLeaveBalance(clsValidator.CheckFloat(txtUnits.Text), _strUsername, _strLeaveTypeCode);
}
else if (cmbStatus.SelectedValue.ToString() != "A" && _strStatus == "A" && LeaveApplicationTypes.IsHasBalance(_strLeaveTypeCode))
{
LeaveApplicationBalance.AddLeaveBalance(clsValidator.CheckFloat(txtUnits.Text), _strUsername, _strLeaveTypeCode);
}
}
_frmLeaveList.BindLeaveList();
this.Close();
}
}
private void tbtnDeactivate_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow drw in dgEntitlementList.SelectedRows)
{
LeaveApplicationBalance.SetInActive(dgEntitlementList.SelectedRows[0].Cells[0].Value.ToString(), dgEntitlementList.SelectedRows[0].Cells[1].Value.ToString());
}
BindLeaveBalanceList();
}
public void DSGZeroSL()
{
DateTime dt = DateTime.Now;
dgNotify2.AutoGenerateColumns = false;
dgNotify2.DataSource = LeaveApplicationBalance.DSGZeroSL(dt.ToString("yy") + "-" + dt.AddYears(1).ToString("yy") + " Sick leave with pay");
dgNotify2.Columns[0].DataPropertyName = "lastname";
dgNotify2.Columns[1].DataPropertyName = "firname";
}
private void btnInclude_Click(object sender, EventArgs e)
{
if (lvExcluded.SelectedItems.Count > 0)
{
bool blnInsertLeave = false;
bool blnHasBalance = LeaveApplicationTypes.IsHasBalance(cmbLeaveType.SelectedValue.ToString());
string strLeaveCode = "";
string strUsername = lvExcluded.SelectedItems[0].Tag.ToString();
DateTime dteDateStart = DateTime.Now;
DateTime dteDateEnd = DateTime.Now;
using (clsShift shift = new clsShift())
{
shift.ShiftCode = clsShift.GetDayShiftCode(strUsername, clsDateTime.GetDateOnly(dtpDateApplied.Value));
shift.Fill();
dteDateStart = clsDateTime.CombineDateTime(dtpDateApplied.Value, shift.TimeStart);
dteDateEnd = clsDateTime.CombineDateTime(dtpDateApplied.Value, shift.TimeEnd);
}
if ((clsValidator.CheckFloat(lvExcluded.SelectedItems[0].SubItems[1].Text) >= 1) || (!blnHasBalance))
{
using (LeaveApplication leave = new LeaveApplication())
{
leave.LeaveType = cmbLeaveType.SelectedValue.ToString();
leave.Requestor = strUsername;
leave.DateFile = DateTime.Now;
leave.DateStart = dteDateStart;
leave.DateEnd = dteDateEnd;
leave.Units = 1;
leave.Reason = txtReason.Text;
leave.Approver = HRMSCore.Username;
leave.ApproverDate = DateTime.Now;
leave.ApproverRemarks = "CDL Application. Auto-generated";
leave.Status = "A";
blnInsertLeave = leave.InsertAdmin();
strLeaveCode = leave.LeaveCode;
}
if (blnHasBalance && blnInsertLeave)
{
LeaveApplicationBalance.DeductLeaveBalance(1, strUsername, cmbLeaveType.SelectedValue.ToString());
}
if (blnInsertLeave)
{
CDL.InsertMember(_strCDLCode, strUsername, strLeaveCode);
this.BindList();
}
}
else
{
MessageBox.Show(lvExcluded.SelectedItems[0].Tag.ToString() + " has not enough balance.", clsMessageBox.MessageBoxText, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
////////////////////////////////
///////// Forms Events /////////
////////////////////////////////
private void frmLeaveEntitlementList_Load(object sender, EventArgs e)
{
cmbLeaveType.DataSource = LeaveApplicationTypes.GetDSLActiveAll();
cmbLeaveType.ValueMember = "pvalue";
cmbLeaveType.DisplayMember = "ptext";
cmbStatus.DataSource = LeaveApplicationBalance.DdlDsStatusAll();
cmbStatus.ValueMember = "pvalue";
cmbStatus.DisplayMember = "ptext";
BindLeaveBalanceList();
this.WindowState = FormWindowState.Maximized;
}
private void tbtnDelete_Click(object sender, EventArgs e)
{
if (dgEntitlementList.SelectedRows.Count > 0)
{
if (MessageBox.Show(clsMessageBox.MessageBoxDeleteAsk, clsMessageBox.MessageBoxText, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
LeaveApplicationBalance lb = new LeaveApplicationBalance();
lb.Username = dgEntitlementList.SelectedRows[0].Cells[0].Value.ToString();
lb.LeaveTypeCode = dgEntitlementList.SelectedRows[0].Cells[1].Value.ToString();
lb.Delete();
BindLeaveBalanceList();
}
}
}
private void cmbLeaveType_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (LeaveApplicationTypes.GetHasBalance(cmbLeaveType.SelectedValue.ToString()) == "1")
{
txtBalance.Text = LeaveApplicationBalance.GetRemainingBalance(cmbRequestor.SelectedValue.ToString(), cmbLeaveType.SelectedValue.ToString()).ToString();
}
else
{
txtBalance.Text = "NA";
}
}
catch { }
}
private void cmbLeaveType_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (LeaveApplicationTypes.GetHasBalance(_strLeaveTypeCode) == "1")
{
txtBalance.Text = LeaveApplicationBalance.GetRemainingBalance(_strUsername, _strLeaveTypeCode).ToString();
}
else
{
txtBalance.Text = "NA";
}
}
catch { }
}
public void BindBalanceList()
{
lvBalance.Items.Clear();
DataTable tblBalance = LeaveApplicationBalance.GetDataTableEntitlementHasBalance(_strUsername);
foreach (DataRow drw in tblBalance.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = LeaveApplicationTypes.GetDescription(drw["leavtype"].ToString());
lvi.Tag = drw["leavtype"].ToString();
lvi.SubItems.Add(drw["entitle"].ToString());
lvi.SubItems.Add(drw["pbalance"].ToString());
lvBalance.Items.Add(lvi);
}
}
public void LoadEmployee()
{
Cursor.Current = Cursors.WaitCursor;
lvEmployee.Items.Clear();
DataTable tblLeaveBalance = LeaveApplicationBalance.NoBalanceFormListDataSource(cmbLeaveType.SelectedValue.ToString());
foreach (DataRow drw in tblLeaveBalance.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Tag = drw["username"].ToString();
lvi.Text = drw["lastname"].ToString() + ", " + drw["firname"].ToString();
lvi.BackColor = (lvEmployee.Items.Count % 2 == 0 ? Color.White : Color.Ivory);
lvEmployee.Items.Add(lvi);
}
lblRecordsFound.Text = lvEmployee.Items.Count.ToString() + " records found";
Cursor.Current = Cursors.Default;
}
private void cmbLeaveType_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataTable tblExclude = CDL.GetDSExcludedEmployee(_strCDLCode);
lvExcluded.Items.Clear();
foreach (DataRow drw in tblExclude.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Tag = drw["username"].ToString();
lvi.Text = drw["lastname"].ToString() + ", " + drw["firname"].ToString();
lvi.SubItems.Add(LeaveApplicationBalance.GetRemainingBalance(drw["username"].ToString(), cmbLeaveType.SelectedValue.ToString()).ToString());
lvExcluded.Items.Add(lvi);
}
}
catch { }
}
private void btnProcess_Click(object sender, EventArgs e)
{
if (lvEmployee.CheckedItems.Count > 0)
{
LeaveApplicationTypes lt = new LeaveApplicationTypes();
lt.LeaveTypeCode = cmbLeaveType.SelectedValue.ToString();
lt.Fill();
foreach (ListViewItem itm in lvEmployee.CheckedItems)
{
LeaveApplicationBalance lb = new LeaveApplicationBalance();
lb.Username = itm.Tag.ToString();
lb.LeaveTypeCode = lt.LeaveTypeCode;
lb.Entitlement = lt.MaximumBalance;
lb.Balance = lt.MaximumBalance;
lb.Status = "1";
lb.Insert();
}
MessageBox.Show("Leave processing complete.", clsMessageBox.MessageBoxText, MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadEmployee();
}
}
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;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsCorrectData())
{
DateTime dteDateStart = clsDateTime.CombineDateTime(dtpDateStart.Value, cmbTimeFrom.Text);
DateTime dteDateEnd = clsDateTime.CombineDateTime(dtpDateEnd.Value, cmbTimeTo.Text);
if (!LeaveApplication.HasExistingApplication(cmbRequestor.SelectedValue.ToString(), dteDateStart, dteDateEnd))
{
LeaveApplication leave = new LeaveApplication();
leave.LeaveCode = txtLeaveCode.Text;
leave.LeaveType = cmbLeaveType.SelectedValue.ToString();
leave.Requestor = cmbRequestor.SelectedValue.ToString();
leave.DateFile = DateTime.Now;
leave.DateStart = dteDateStart;
leave.DateEnd = dteDateEnd;
leave.Units = clsValidator.CheckFloat(txtUnits.Text);
leave.Reason = txtReason.Text;
leave.Approver = cmbApprover.SelectedValue.ToString();
leave.ApproverDate = clsDateTime.CombineDateTime(dtpDateEnd.Value, dtpApproverTime.Value);
leave.ApproverRemarks = txtARemarks.Text;
leave.Status = cmbStatus.SelectedValue.ToString();
leave.InsertAdmin();
MessageBox.Show("save");
if (cmbStatus.SelectedValue.ToString() == "A" && LeaveApplicationTypes.IsHasBalance(cmbLeaveType.SelectedValue.ToString()))
{
LeaveApplicationBalance.DeductLeaveBalance(clsValidator.CheckFloat(txtUnits.Text), cmbRequestor.SelectedValue.ToString(), cmbLeaveType.SelectedValue.ToString());
}
_frmLeaveList.BindLeaveList();
this.Close();
}
else
{
MessageBox.Show("There is already an existing leave application on specified dates.", clsMessageBox.MessageBoxText, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsCorrectEntries())
{
if (_strStatus == "1" && !chkStatus.Checked)
{
if (MessageBox.Show("You choose to set inactive this leave type.\nThis action will disable " + txtLeaveType.Text + " to all employee.\n\nDo you want to continue", clsMessageBox.MessageBoxText, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (LeaveApplicationTypes lt = new LeaveApplicationTypes())
{
lt.LeaveTypeCode = _strLeaveTypeCode;
lt.LeaveType = txtLeaveType.Text;
lt.WithPay = (chkWithPay.Checked ? "1" : "0");
lt.HasBalance = (chkHasBalance.Checked ? "1" : "0");
lt.MaximumBalance = clsValidator.CheckFloat(txtMaxBalance.Text);
lt.Status = (chkStatus.Checked ? "1" : "0");
lt.Update();
}
LeaveApplicationBalance.DisableRecords(_strLeaveTypeCode);
}
}
else
{
using (LeaveApplicationTypes lt = new LeaveApplicationTypes())
{
lt.LeaveTypeCode = _strLeaveTypeCode;
lt.LeaveType = txtLeaveType.Text;
lt.WithPay = (chkWithPay.Checked ? "1" : "0");
lt.HasBalance = (chkHasBalance.Checked ? "1" : "0");
lt.MaximumBalance = clsValidator.CheckFloat(txtMaxBalance.Text);
lt.Status = (chkStatus.Checked ? "1" : "0");
lt.Update();
}
}
_frmLeaveTypeList.BindLeaveTypeList();
this.Close();
}
}
