private void btnSave_Click(object sender, EventArgs e)
{
if (IsCorrectData())
{
using (OfficialBusiness ob = new OfficialBusiness())
{
ob.UserName = cmbRequestor.SelectedValue.ToString();
ob.DateFile = clsDateTime.CombineDateTime(dtpFileDate.Value, dtpFileTime.Value);
ob.Reason = txtReason.Text;
ob.OBType = cmbOBType.SelectedValue.ToString();
ob.DepartmentCode = cmbRender.SelectedValue.ToString();
if (cmbOBType.SelectedValue.ToString() == "1")
{
ob.RAName = cmbRApprover.SelectedValue.ToString();
ob.RADate = clsDateTime.CombineDateTime(dtpRDate.Value, dtpRTime.Value);
ob.RARemarks = txtRRemarks.Text;
ob.RAStatus = cmbRStatus.SelectedValue.ToString();
}
ob.HAName = cmbHApprover.SelectedValue.ToString();
ob.HADate = clsDateTime.CombineDateTime(dtpHDate.Value, dtpHTime.Value);
ob.HARemarks = txtHRemarks.Text;
ob.HAStatus = cmbHStatus.SelectedValue.ToString();
ob.Status = cmbStatus.SelectedValue.ToString();
if (ob.InsertAdmin() > 0)
{
frmOBEdit pForm = new frmOBEdit();
pForm.FormOBList = _frmOBList;
pForm.FormOBNew = this;
pForm.OBCode = ob.OBCode;
pForm.FormCaller = FormCallers.OBNew;
pForm.ShowDialog();
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
using (OfficialBusiness ob = new OfficialBusiness())
{
ob.OBCode = _strOBCode;
ob.Fill();
ob.DateFile = clsDateTime.CombineDateTime(dtpFileDate.Value, dtpFileTime.Value);
ob.Reason = txtReason.Text;
if (_strOBType == "1")
{
ob.RADate = clsDateTime.CombineDateTime(dtpRDate.Value, dtpRTime.Value);
ob.RARemarks = txtRRemarks.Text;
ob.RAStatus = cmbRStatus.SelectedValue.ToString();
}
ob.HADate = clsDateTime.CombineDateTime(dtpHDate.Value, dtpHTime.Value);
ob.HARemarks = txtHRemarks.Text;
ob.HAStatus = cmbHStatus.SelectedValue.ToString();
ob.Status = cmbStatus.SelectedValue.ToString();
if (ob.UpdateAdmin() > 0)
{
_frmOBList.BindOBList();
this.Close();
MessageBox.Show("Official Business Leave has been filed successfully", "OB Leave", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void BindOBDetails(string pObCode)
{
using (OfficialBusiness ob = new OfficialBusiness(pObCode))
{
ob.Fill();
lblOBCode.Text = pObCode;
lblOBType.Text = OfficialBusiness.GetOBTypeDesc(ob.OBType);
lblOBDepartment.Text = Department.GetName(ob.DepartmentCode);
lblOBRequestor.Text = Employee.GetName(ob.UserName);
lblOBDateFile.Text = ob.DateFile.ToString("MMM dd, yyyy hh:mm tt");
lblOBReason.Text = ob.Reason;
lblOBRApprover.Text = (ob.OBType == "1" ? Employee.GetName(ob.RAName) : "NA");
lblOBRDate.Text = (ob.OBType == "1" ? ob.RADate.ToString("MM-dd-yyyy") : "NA");
lblOBRRemarks.Text = (ob.OBType == "1" ? ob.RARemarks : "NA");
lblOBHApprover.Text = Employee.GetName(ob.HAName);
lblOBHDate.Text = ob.HADate.ToString("MM-dd-yyyy");
lblOBHRemarks.Text = ob.HARemarks;
lblOBStatus.Text = LeaveApplication.ToLeaveStatusDesc(ob.Status);
}
lvOBDetails.Items.Clear();
DataTable tblOBDetails = OfficialBusinessDetails.DataTableByOBCode(pObCode);
foreach (DataRow drw in tblOBDetails.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = clsValidator.CheckDate(drw["focsdate"].ToString()).ToString("MMM dd, yyyy");
lvi.SubItems.Add(clsValidator.CheckDate(drw["keyin"].ToString()).ToString("MMM dd, yyyy hh:mm tt"));
lvi.SubItems.Add(clsValidator.CheckDate(drw["keyout"].ToString()).ToString("MMM dd, yyyy hh:mm tt"));
lvOBDetails.Items.Add(lvi);
}
}
///////////////////////////////
///////// Form Events /////////
///////////////////////////////
private void frmTimesheetApplication_Load(object sender, EventArgs e)
{
// Initialize Time Card Details
BindTimeCardList();
// Initialize Leave Tab
cmbLeave.DataSource = LeaveApplication.GetDSLApproveFilter();
cmbLeave.ValueMember = "pvalue";
cmbLeave.DisplayMember = "ptext";
LoadLeaveList();
// Initialize Undertime Tab
cmbUndertime.DataSource = clsUndertime.DdlDsApproveFilter();
cmbUndertime.ValueMember = "pvalue";
cmbUndertime.DisplayMember = "ptext";
LoadUndertimeList();
// Initialize OB Tab
cmbOB.DataSource = OfficialBusiness.DdlDsApproveFilter();
cmbOB.ValueMember = "pvalue";
cmbOB.DisplayMember = "ptext";
LoadOBList();
// Initialize Overtime Tab
cmbOvertime.DataSource = clsOvertime.DdlDsApproveFilter();
cmbOvertime.ValueMember = "pvalue";
cmbOvertime.DisplayMember = "ptext";
LoadOvertimeList();
}
private void btnSave_Click(object sender, EventArgs e)
{
using (OfficialBusiness ob = new OfficialBusiness())
{
ob.OBCode = _strOBCode;
ob.Fill();
ob.DateFile = clsDateTime.CombineDateTime(dtpFileDate.Value, dtpFileTime.Value);
ob.Reason = txtReason.Text;
if (_strOBType == "1")
{
ob.RADate = clsDateTime.CombineDateTime(dtpRDate.Value, dtpRTime.Value);
ob.RARemarks = txtRRemarks.Text;
ob.RAStatus = cmbRStatus.SelectedValue.ToString();
}
ob.HADate = clsDateTime.CombineDateTime(dtpHDate.Value, dtpHTime.Value);
ob.HARemarks = txtHRemarks.Text;
ob.HAStatus = cmbHStatus.SelectedValue.ToString();
ob.Status = cmbStatus.SelectedValue.ToString();
if (ob.UpdateAdmin() > 0)
{
_frmOBList.BindOBList();
this.Close();
}
}
}
private void frmOBApplications_Load(object sender, EventArgs e)
{
cmbFilter.DataSource = OfficialBusiness.DdlDsApproveFilter();
cmbFilter.ValueMember = "pvalue";
cmbFilter.DisplayMember = "ptext";
BindOBList();
}
private void BindDetails()
{
cmbStatus.DataSource = OfficialBusiness.DdlDsStatus();
cmbStatus.ValueMember = "pvalue";
cmbStatus.DisplayMember = "ptext";
cmbRStatus.DataSource = OfficialBusiness.DdlDsStatusApprover();
cmbRStatus.ValueMember = "pvalue";
cmbRStatus.DisplayMember = "ptext";
cmbHStatus.DataSource = OfficialBusiness.DdlDsStatusApprover();
cmbHStatus.ValueMember = "pvalue";
cmbHStatus.DisplayMember = "ptext";
txtOBCode.Text = _strOBCode;
using (OfficialBusiness objOfficialBusiness = new OfficialBusiness())
{
objOfficialBusiness.OBCode = _strOBCode;
objOfficialBusiness.Fill();
txtRequestor.Text = Employee.GetName(objOfficialBusiness.UserName);
_strOBType = objOfficialBusiness.OBType;
txtOBtype.Text = OfficialBusiness.GetOBTypeDesc(objOfficialBusiness.OBType);
txtRenderTo.Text = Department.GetName(objOfficialBusiness.DepartmentCode);
dtpFileDate.Value = objOfficialBusiness.DateFile;
dtpFileTime.Value = objOfficialBusiness.DateFile;
txtReason.Text = objOfficialBusiness.Reason;
if (objOfficialBusiness.OBType == "1")
{
txtRApprover.Text = Employee.GetName(objOfficialBusiness.RAName);
dtpRDate.Value = objOfficialBusiness.RADate;
dtpRTime.Value = objOfficialBusiness.RADate;
cmbRStatus.SelectedValue = objOfficialBusiness.RAStatus;
txtRRemarks.Text = objOfficialBusiness.RARemarks;
}
else
{
txtRApprover.Visible = false;
dtpRDate.Visible = false;
dtpRTime.Visible = false;
cmbRStatus.Visible = false;
txtRRemarks.Visible = false;
lblRApprover.Visible = false;
lblRStatus.Visible = false;
lblRRemarks.Visible = false;
}
txtHApprover.Text = Employee.GetName(objOfficialBusiness.HAName);
dtpHDate.Value = objOfficialBusiness.HADate;
dtpHTime.Value = objOfficialBusiness.HADate;
cmbHStatus.SelectedValue = objOfficialBusiness.HAStatus;
txtHRemarks.Text = objOfficialBusiness.HARemarks;
cmbStatus.SelectedValue = objOfficialBusiness.Status;
}
LoadOBDetails();
}
private void dgOBList_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
try
{
foreach (DataGridViewRow drw in dgOBList.Rows)
{
drw.DefaultCellStyle.BackColor = OfficialBusiness.GetLVBGColor(drw.Cells[1].Value.ToString());
}
}
catch { }
}
private void InitializeFields()
{
dtpFocusDate.Value = DateTime.Now;
dtpInDate.Value = DateTime.Now;
dtpOutDate.Value = DateTime.Now;
using (clsShift shift = new clsShift())
{
shift.ShiftCode = clsShift.GetDayShiftCode(OfficialBusiness.GetRequestor(_strOBCode), DateTime.Now);
shift.Fill();
dtpInTime.Value = shift.TimeStart;
dtpOutTime.Value = shift.TimeEnd;
}
}
private void tbtnDelete_Click(object sender, EventArgs e)
{
if (dgOBList.SelectedRows.Count > 0)
{
if (MessageBox.Show(clsMessageBox.MessageBoxDeleteAsk, clsMessageBox.MessageBoxText, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
OfficialBusiness ob = new OfficialBusiness();
ob.OBCode = dgOBList.SelectedRows[0].Cells[0].Value.ToString();
if (ob.DeleteAdmin() > 0)
{
BindOBList();
}
}
}
}
private void dtpFocusDate_ValueChanged(object sender, EventArgs e)
{
try
{
dtpInDate.Value = dtpFocusDate.Value;
dtpOutDate.Value = dtpFocusDate.Value;
using (clsShift shift = new clsShift())
{
shift.ShiftCode = clsShift.GetDayShiftCode(OfficialBusiness.GetRequestor(_strOBCode), dtpFocusDate.Value);
shift.Fill();
dtpInTime.Value = shift.TimeStart;
dtpOutTime.Value = shift.TimeEnd;
}
}
catch { }
}
private void InitializeFields()
{
OB_Code();
dtpFileDate.Value = DateTime.Now;
dtpFileTime.Value = DateTime.Now;
dtpRDate.Value = DateTime.Now;
dtpRTime.Value = DateTime.Now;
dtpHDate.Value = DateTime.Now;
dtpHTime.Value = DateTime.Now;
txtReason.Text = "";
txtRRemarks.Text = "";
txtHRemarks.Text = "";
cmbStatus.DataSource = OfficialBusiness.DdlDsStatus();
cmbStatus.ValueMember = "pvalue";
cmbStatus.DisplayMember = "ptext";
cmbRequestor.DataSource = Employee.DSLActive();
cmbRequestor.ValueMember = "pvalue";
cmbRequestor.DisplayMember = "ptext";
_strDepartmentCode = Employee.GetDepartmentCode(cmbRequestor.SelectedValue.ToString());
cmbOBType.DataSource = OfficialBusiness.DdlDsOBType();
cmbOBType.ValueMember = "pvalue";
cmbOBType.DisplayMember = "ptext";
cmbRender.DataSource = Department.GetDSL();
cmbRender.ValueMember = "pvalue";
cmbRender.DisplayMember = "ptext";
cmbRStatus.DataSource = OfficialBusiness.DdlDsStatusApprover();
cmbRStatus.ValueMember = "pvalue";
cmbRStatus.DisplayMember = "ptext";
cmbHStatus.DataSource = OfficialBusiness.DdlDsStatusApprover();
cmbHStatus.ValueMember = "pvalue";
cmbHStatus.DisplayMember = "ptext";
BindApprovers();
CheckRender();
}
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());
}
public void BindOBList()
{
lvwOB.Items.Clear();
DataTable tblOB = OfficialBusiness.GetDSGApplications(_dteFocusDate, _strUsername, cmbFilter.SelectedValue.ToString());
foreach (DataRow drw in tblOB.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = drw["obcode"].ToString();
lvi.Tag = drw["obcode"].ToString();
lvwOB.Items.Add(lvi);
}
if (lvwOB.Items.Count > 0)
{
lvwOB.Items[0].Selected = true;
}
else
{
ClearFields();
}
}
private void frmOBList_Load(object sender, EventArgs e)
{
cmbOBType.DataSource = OfficialBusiness.DdlDsOBTypeAll();
cmbOBType.ValueMember = "pvalue";
cmbOBType.DisplayMember = "ptext";
// Load the current time sheet period
string strCurrentTimeSheetPeriod = clsTimeSheetPeriod.GetCurrentTimeSheetPeriod();
using (clsTimeSheetPeriod tsp = new clsTimeSheetPeriod(strCurrentTimeSheetPeriod))
{
tsp.Fill();
dtpFrom.Value = tsp.PeriodFrom;
dtpTo.Value = tsp.PeriodTo;
}
cmbStatus.DataSource = LeaveApplication.DdlDsStatusAll();
cmbStatus.ValueMember = "pvalue";
cmbStatus.DisplayMember = "ptext";
BindOBList();
this.WindowState = FormWindowState.Maximized;
}
private void BindDetails()
{
cmbStatus.DataSource = OfficialBusiness.DdlDsStatus();
cmbStatus.ValueMember = "pvalue";
cmbStatus.DisplayMember = "ptext";
cmbRStatus.DataSource = OfficialBusiness.DdlDsStatusApprover();
cmbRStatus.ValueMember = "pvalue";
cmbRStatus.DisplayMember = "ptext";
cmbHStatus.DataSource = OfficialBusiness.DdlDsStatusApprover();
cmbHStatus.ValueMember = "pvalue";
cmbHStatus.DisplayMember = "ptext";
txtOvertimeCode.Text = _strOvertimeCode;
using (clsOvertime overtime = new clsOvertime())
{
overtime.OvertimeCode = _strOvertimeCode;
overtime.Fill();
txtRequestor.Text = Employee.GetName(overtime.Username);
_strChargeType = overtime.ChargeType;
txtChargeType.Text = clsOvertime.GetChargeTypeDesc(overtime.ChargeType);
txtRenderedTo.Text = Department.GetName(overtime.DepartmentCode);
dtpFileDate.Value = overtime.DateFile;
dtpFileTime.Value = overtime.DateFile;
dtpStartDate.Value = overtime.DateStart;
dtpStartTime.Value = overtime.DateStart;
dtpEndDate.Value = overtime.DateEnd;
dtpEndTime.Value = overtime.DateEnd;
txtReason.Text = overtime.Reason;
if (overtime.ChargeType == "1")
{
txtRApprover.Text = Employee.GetName(overtime.RequestorApproverName);
dtpRDate.Value = overtime.RequestorApproverDate;
dtpRTime.Value = overtime.RequestorApproverDate;
cmbRStatus.SelectedValue = overtime.RequestorApproverStatus;
txtRRemarks.Text = overtime.RequestorApproverRemarks;
dtpRDate.Checked = (overtime.RequestorApproverDate != clsDateTime.SystemMinDate);
dtpRTime.Checked = (overtime.RequestorApproverDate != clsDateTime.SystemMinDate);
}
else
{
txtRApprover.Visible = false;
dtpRDate.Visible = false;
dtpRTime.Visible = false;
cmbRStatus.Visible = false;
txtRRemarks.Visible = false;
lblRApprover.Visible = false;
lblRStatus.Visible = false;
lblRRemarks.Visible = false;
}
txtHApprover.Text = Employee.GetName(overtime.HeadApproverName);
dtpHDate.Value = overtime.HeadApproverDate;
dtpHTime.Value = overtime.HeadApproverDate;
cmbHStatus.SelectedValue = overtime.HeadApproverStatus;
txtHRemarks.Text = overtime.HeadApproverRemarks;
cmbStatus.SelectedValue = overtime.Status;
dtpHDate.Checked = (overtime.HeadApproverDate != clsDateTime.SystemMinDate);
dtpHTime.Checked = (overtime.HeadApproverDate != clsDateTime.SystemMinDate);
}
}
