private void lblBrowseLoanAccountCode_Click(object sender, EventArgs e)
{
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "AccountList";
frmDataList.ShowDialog();
txtAccountCode.Text = frmDataList._gAccountCode;
}
private void btnBranch_Click(object sender, EventArgs e)
{
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "BranchList";
frmDataList.ShowDialog();
txtBranchCode.Text = frmDataList._gBranchCode;
txtBranchName.Text = frmDataList._gBranchName;
}
private void ms_Main_PaymentsInvoices_Click(object sender, EventArgs e)
{
if (DataList == null || DataList.IsDisposed)
{
DataList = new frmDataList();
DataList.StartPosition = FormStartPosition.CenterScreen;
//DataList.MdiParent = this;
DataList.Show();
}
DataList.BringToFront();
}
private void button1_Click(object sender, EventArgs e)
{
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "EmployeeList";
frmDataList.ShowDialog();
txtEmpCode.Text = frmDataList._gEmployeeNo;
string _sqlList = "";
_sqlList = @"SELECT A.[EmployeeName]
FROM vwsEmployees A WHERE A.EmployeeNo = '" + txtEmpCode.Text + @"'";
txtEmpName.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "EmployeeName");
}
private void btnAccount_Click(object sender, EventArgs e)
{
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "AccountList";
frmDataList.ShowDialog();
txtLoanAccountCode.Text = frmDataList._gAccountCode;
string _ConCompany = clsFunctions.GetCompanyConnectionString(txtCompany.Text);
string _sqlList = "";
_sqlList = @"SELECT A.AccountDesc
FROM vwsAccountCode A WHERE A.AccountCode = '" + txtLoanAccountCode.Text + @"'";
txtDescription.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "AccountDesc");
}
private void btnEmployee_Click(object sender, EventArgs e)
{
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "EmployeeList";
frmDataList.ShowDialog();
txtCompany.Text = frmDataList._gCompany;
txtEmpCode.Text = frmDataList._gEmployeeNo;
string _ConCompany = clsFunctions.GetCompanyConnectionString(txtCompany.Text);
string _sqlList = "";
_sqlList = @"SELECT CONCAT(A.LastName, ', ', A.FirstName, ' ', A.MiddleName) AS [EmployeeName]
FROM vwsEmployees A WHERE A.EmployeeNo COLLATE Latin1_General_CI_AS = '" + txtEmpCode.Text + @"'";
txtEmpName.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "EmployeeName");
}
private void button1_Click(object sender, EventArgs e)
{
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "AccountList2";
frmDataList.ShowDialog();
txtLoanAccountCode.Text = frmDataList._gAccountCode;
string _sqlList = "";
_sqlList = @"SELECT A.AccountDesc
FROM (
SELECT A.AccountCode, A.AccountDesc FROM vwsAccountCode A
UNION ALL
SELECT A.AccountCode, A.Description FROM vwsPayrollRegsCode A WHERE A.AccountCode IN ('004','005','006','007','008','009','010','011')
) A WHERE A.AccountCode = '" + txtLoanAccountCode.Text + @"'";
txtDescription.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "AccountDesc");
}
private void btnEmployee_Click(object sender, EventArgs e)
{
if (cboPayrolPeriod.Text == "")
{
MessageBox.Show("Please Identify Payroll Period");
return;
}
frmDataList frmDataList = new frmDataList();
frmDataList._gPayrollPeriod = cboPayrolPeriod.Text;
frmDataList._gListGroup = "PayrollEntry";
frmDataList.ShowDialog();
txtEmpCode.Text = frmDataList._gEmployeeNo;
string _sqlList = "";
_sqlList = @"SELECT CONCAT(A.LastName, ', ', A.FirstName, ' ', A.MiddleName) AS [EmployeeName]
FROM vwsEmployees A WHERE A.EmployeeNo COLLATE Latin1_General_CI_AS = '" + txtEmpCode.Text + @"'";
txtEmpName.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "EmployeeName");
string strCompany = frmDataList._gCompany;
string _ConCompany = clsFunctions.GetCompanyConnectionString(strCompany);
DataTable _tblList;
_sqlList = @"SELECT A.AccountCode, B.AccountDesc, A.TotalDays, A.TotalHrs, A.Remarks FROM PayrollTrans01 A INNER JOIN AccountCode B ON A.AccountCode = B.AccountCode
WHERE A.EmployeeNo = '" + txtEmpCode.Text + @"' AND A.PayrollPeriod = '" + cboPayrolPeriod.Text + @"'";
_tblList = clsSQLClientFunctions.DataList(_ConCompany, _sqlList);
clsFunctions.DataGridViewSetup(dgvDisplayTimeSheet, _tblList);
_sqlList = @"SELECT A.AccountCode, B.AccountDesc, A.Amount, A.Remarks FROM PayrollTrans02 A INNER JOIN AccountCode B ON A.AccountCode = B.AccountCode
WHERE A.EmployeeNo = '" + txtEmpCode.Text + @"' AND A.PayrollPeriod = '" + cboPayrolPeriod.Text + @"'";
_tblList = clsSQLClientFunctions.DataList(_ConCompany, _sqlList);
clsFunctions.DataGridViewSetup(dgvDisplayOthrs, _tblList);
}
private void button1_Click(object sender, EventArgs e)
{
if (cboPayrolPeriod.Text == "")
{
MessageBox.Show("Please Identify Payroll Period");
return;
}
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "AccountList1";
frmDataList.ShowDialog();
txtLoanAccountCode.Text = frmDataList._gAccountCode;
string _sqlList = "";
_sqlList = @"SELECT A.AccountDesc
FROM vwsAccountCode A WHERE A.AccountCode = '" + txtLoanAccountCode.Text + @"'";
txtDescription.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "AccountDesc");
DataTable _tblList;
_sqlList = @"
SELECT A.EmployeeNo,
C.[EmployeeName],
A.Amount, A.Remarks
FROM vwsPayrollTrans02 A
INNER JOIN vwsAccountCode B ON A.AccountCode = B.AccountCode
INNER JOIN vwsEmployees C ON A.EmployeeNo = C.EmployeeNo
WHERE A.AccountCode = '" + txtLoanAccountCode.Text + @"' AND A.PayrollPeriod = '" + cboPayrolPeriod.Text + @"'";
_tblList = clsSQLClientFunctions.DataList(clsDeclaration.sSystemConnection, _sqlList);
clsFunctions.DataGridViewSetup(dgvDisplay, _tblList);
}
private void btnSearch_Click(object sender, EventArgs e)
{
btnEmployee.Enabled = false;
btnAccount.Enabled = false;
btnSearch.Enabled = true;
btnNew.Enabled = true;
btnSave.Enabled = false;
btnDelete.Enabled = true;
btnCancel.Enabled = true;
frmDataList frmDataList = new frmDataList();
frmDataList._gListGroup = "LoanList";
frmDataList.ShowDialog();
txtCompany.Text = frmDataList._gCompany;
txtEmpCode.Text = frmDataList._gEmployeeNo;
txtLoanAccountCode.Text = frmDataList._gAccountCode;
txtLoanReferenceNo.Text = frmDataList._gLoanRefNo;
if (txtEmpCode.Text == "")
{
return;
}
string _ConCompany = clsFunctions.GetCompanyConnectionString(txtCompany.Text);
string _sqlList = "";
_sqlList = @"SELECT CONCAT(A.LastName, ', ', A.FirstName, ' ', A.MiddleName) AS [EmployeeName]
FROM vwsEmployees A WHERE A.EmployeeNo COLLATE Latin1_General_CI_AS = '" + txtEmpCode.Text + @"'";
txtEmpName.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "EmployeeName");
_sqlList = @"SELECT A.AccountDesc
FROM vwsAccountCode A WHERE A.AccountCode = '" + txtLoanAccountCode.Text + @"'";
txtDescription.Text = clsSQLClientFunctions.GetStringValue(clsDeclaration.sSystemConnection, _sqlList, "AccountDesc");
_DisplayData();
_sqlList = @"SELECT Z.Type, Z.PaymentDate, Z.ORNo, Z.[Principal Amount], Z.[Interest Amount], Z.Amount, Z.Remarks FROM (
SELECT ISNULL([Type],'CASH PAYMENT') AS [Type],CONVERT(nvarchar(30), [PaymentDate], 101) AS [PaymentDate],[ORNo],0 AS [Principal Amount] ,0 AS [Interest Amount],[Amount],[Remarks],[EmployeeNo],[AccountCode],[LoanRefNo] FROM LoanCashPayment
UNION ALL
SELECT 'PAYROLL' AS [Type],CONCAT(A.[PayrollPeriod], ' (', CONVERT(nvarchar(30), B.DateOne, 101),' - ', CONVERT(nvarchar(30), B.DateTwo, 101), ') '),NULL as [ORNo],ISNULL(A.PrincipalAmt,0) AS [Principal Amount] ,ISNULL(A.InterestAmt,0) AS [Interest Amount] ,A.[Amount], NULL as [Remarks],[EmployeeNo],[AccountCode],[LoanRefenceNo] FROM PayrollDetails A INNER JOIN PayrollPeriod B
ON A.PayrollPeriod = B.PayrollPeriod) Z
WHERE Z.EmployeeNo = '" + txtEmpCode.Text + @"' AND Z.AccountCode = '" + txtLoanAccountCode.Text + @"' AND Z.LoanRefNo = '" + txtLoanReferenceNo.Text + @"'";
DataTable _tblList;
_tblList = clsSQLClientFunctions.DataList(_ConCompany, _sqlList);
clsFunctions.DataGridViewSetup(dgvDisplay, _tblList);
txtEmpCode.ReadOnly = true;
txtLoanAccountCode.ReadOnly = true;
txtLoanReferenceNo.ReadOnly = true;
txtBranchCode.ReadOnly = false;
txtBranchName.ReadOnly = false;
btnBranch.Enabled = true;
txtAmountGranted.ReadOnly = false;
txtPayableLoanAmount.ReadOnly = false;
txtAmortization.ReadOnly = false;
txtLoanInterest.ReadOnly = false;
txtStartofDeduction.Enabled = true;
txtTermsOfPayment.Enabled = true;
txtRebateApplication.Enabled = true;
chkActive.Enabled = true;
txtLoanDate.Enabled = true;
txtRebateAmount.ReadOnly = false;
txtParticular.ReadOnly = false;
txtBrand.ReadOnly = false;
txtLCPPrice.ReadOnly = false;
txtSpotCashAmount.ReadOnly = false;
txtDownPayment.ReadOnly = false;
txtTerms.ReadOnly = false;
btnRowAdd.Enabled = true;
btnRowEdit.Enabled = true;
btnRowDelete.Enabled = true;
}
