public void ScatterData()
{
ServiceAdvanceRequest _service = new ServiceAdvanceRequest();
try
{
TBL_MP_HR_AdvanceRequestApplication model = _service.GetAdvanceRequestInfoDbRecord(this.AdvanceRequestID);
if (model != null)
{
txtAdvanceRequestNo.Text = model.AdvanceRequestNo;
dtRequestDate.Value = model.RequestDate;
cboEmployees.SelectedItem = ((List <SelectListItem>)cboEmployees.DataSource).Where(x => x.ID == model.FK_EmployeeID).FirstOrDefault();
cboRequestTo.SelectedItem = ((List <SelectListItem>)cboRequestTo.DataSource).Where(x => x.ID == model.FK_RequestTo).FirstOrDefault();
txtRemarks.Text = model.Remarks;
txtRequestedAmount.Text = model.RequestedAmount.ToString();
if (model.ExpectedDate != null)
{
dtExpectedDate.Value = (DateTime)model.ExpectedDate;
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditAdvanceRequest::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridAdvanceRequests_RowEnter(object sender, DataGridViewCellEventArgs e)
{
try
{
this.SelectedAdvanceRequestID = (int)(gridAdvanceRequests.Rows[e.RowIndex].Cells["PK_AdvancRequestID"].Value);
int approvalStatusID = (int)(gridAdvanceRequests.Rows[e.RowIndex].Cells["ApprovalStatus"].Value);
ServiceAdvanceRequest service = new ServiceAdvanceRequest();
if (approvalStatusID != service.REQUEST_STATUS_PENDING_ID)
{
btnEditAdvanceRequest.Enabled = btnDeleteAdvanceRequests.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
}
else
{
btnEditAdvanceRequest.Enabled = btnDeleteAdvanceRequests.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "PageUserInfo::gridAdvanceRequests_RowEnter", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
TBL_MP_HR_AdvanceRequestApplication model = null;
ServiceAdvanceRequest service = new ServiceAdvanceRequest();
try
{
if (!this.ValidateChildren())
{
return;
}
if (this.AdvanceRequestID == 0)
{
model = new TBL_MP_HR_AdvanceRequestApplication();
}
else
{
model = service.GetAdvanceRequestInfoDbRecord(this.AdvanceRequestID);
}
#region GATHER DATA INTO MODEL FROM VIEW
model.AdvanceRequestNo = txtAdvanceRequestNo.Text.Trim();
model.RequestDate = dtRequestDate.Value;
model.ExpectedDate = dtExpectedDate.Value;
model.FK_EmployeeID = ((SelectListItem)cboEmployees.SelectedItem).ID;
model.FK_RequestTo = ((SelectListItem)cboRequestTo.SelectedItem).ID;
model.RequestedAmount = decimal.Parse(txtRequestedAmount.Text.Trim());
model.Remarks = txtRemarks.Text.Trim();
#endregion
if (this.AdvanceRequestID == 0)
{
model.Fk_YearID = Program.CURR_USER.FinYearID;
model.Fk_BranchID = Program.CURR_USER.BranchID;
model.FK_CompanyID = Program.CURR_USER.CompanyID;
this.AdvanceRequestID = service.AddNewAdvanceRequest(model);
}
else
{
service.UpdateAdvanceRequest(model);
}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditAdvanceRequest::btnOk_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
errorProvider1.Clear();
if (!this.ValidateChildren())
{
return;
}
ServiceAdvanceRequest service = new ServiceAdvanceRequest();
TBL_MP_HR_AdvanceRequestApplication model = service.GetAdvanceRequestInfoDbRecord(this.AdvanceRequestID);
if (model != null)
{
model.RemarksApproved = txtApprovalRemarks.Text.Trim();
model.FK_ApprovedBy = Program.CURR_USER.EmployeeID;
if (rbtnApproveAdvanceRequest.Checked)
{
model.ApprovalStatus = service.REQUEST_STATUS_APPROVED_ID;
}
if (rbtnRejectAdvanceRequest.Checked)
{
model.ApprovalStatus = service.REQUEST_STATUS_REJECTED_ID;
}
model.ApprovalDate = dtApprovalDate.Value;
model.ApprovedAmount = decimal.Parse(txtApprovedAmount.Text.Trim());
// put validation on this
service.UpdateAdvanceRequest(model);
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmApproveRejectAdvanceRequest::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDeleteAdvanceRequests_Click(object sender, EventArgs e)
{
try
{
// TBL_MP_HR_LeaveApplication model = new TBL_MP_HR_LeaveApplication();
ServiceAdvanceRequest service = new ServiceAdvanceRequest();
TBL_MP_HR_AdvanceRequestApplication dbModel = service.GetAdvanceRequestInfoDbRecord(SelectedAdvanceRequestID);
{
string msg = "Are you sure to Delete selected advanced request Permanently";
DialogResult res = MessageBox.Show(msg, "Caution", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
if (dbModel.ApprovalStatus == service.REQUEST_STATUS_PENDING_ID)
{
(new ServiceAdvanceRequest()).DeleteAdvancedRequest(this.SelectedAdvanceRequestID);
PopulateAdvanceRequestGrid();
}
else
{
msg = "Unable to delete selected advanced request..";
MessageBox.Show(msg, "Caution", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
}
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "PageMyAdvanceRequests::btnDeleteAdvanceRequests_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridAdvanceRegister_RowEnter(object sender, DataGridViewCellEventArgs e)
{
try
{
ServiceAdvanceRequest service = new ServiceAdvanceRequest();
this.AdvanceRequestID = (int)(gridAdvanceRegister.Rows[e.RowIndex].Cells["PK_AdvancRequestID"].Value);
TBL_MP_HR_AdvanceRequestApplication model = service.GetAdvanceRequestInfoDbRecord(this.AdvanceRequestID);
//if (AppCommon.GetServerDateTime() < model.RequestDate)
// btnApproveReject.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
//else
// btnApproveReject.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "PageAdvanceRequestsRegister::gridAdvanceRegister_RowEnter", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmApproveRejectAdvanceRequest_Load(object sender, EventArgs e)
{
try
{
ServiceAdvanceRequest service = new ServiceAdvanceRequest();
vAdvanceRequestApplication model = service.GetAdvanceRequestViewDbRecord(this.AdvanceRequestID);
if (model != null)
{
txtAdvanceRequestNo.Text = string.Format("{0} dt. {1}", model.AdvanceRequestNo, model.RequestDate.ToString("dd MMM yy"));
dtApprovalDate.Value = model.RequestDate;
txtAdvanceRequestDescription.Text = model.EmployeeName;
txtAdvanceRequestDescription.Text += string.Format("\nAmount: {0:0.00}\nRemarks: {1}", model.RequestedAmount, model.Remarks);
if (model.ApprovalStatus == service.REQUEST_STATUS_APPROVED_ID)
{
rbtnApproveAdvanceRequest.Checked = true;
}
if (model.ApprovalStatus == service.REQUEST_STATUS_REJECTED_ID)
{
rbtnRejectAdvanceRequest.Checked = true;
}
txtApprovedAmount.Text = model.ApprovedAmount.ToString();
txtApprovalRemarks.Text = model.RemarksApproved;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmApproveRejectAdvanceRequest::frmApproveRejectAdvanceRequest_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
