private void BankEntry_Load(object sender, EventArgs e)
{
//ADDED BY DHRUB ON 07/05/2014
ViewGrid.Size = new Size(1000, 506);
lblMode.Text = J_Mode.View;
cmnService.J_StatusButton(this, lblMode.Text);
lblTitle.Text = this.Text;
//Populating Payment Type Combo
strSQL = "SELECT PAYMENT_TYPE_ID," +
" PAYMENT_TYPE_DESCRIPTION " +
"FROM MST_PAYMENT_TYPE " +
"ORDER BY PAYMENT_TYPE_ID ";
if (dmlService.J_PopulateComboBox(strSQL, ref cmbFilterPaymentType) == false)
{
return;
}
strSQL = "SELECT COMPANY_ID," +
" COMPANY_NAME " +
"FROM MST_COMPANY " +
"WHERE BRANCH_ID = " + J_Var.J_pBranchId + " " +
"AND COMPANY_ID = " + BS_CompanyId.PDSInfotech + " " +
"ORDER BY COMPANY_NAME ";
if (dmlService.J_PopulateComboBox(strSQL, ref cmbCompany, 1) == false)
{
return;
}
chkIncompleteRecords.Checked = true;
}
private void ClearControls()
{
txtPartyName.Text = "";
txtAddress1.Text = "";
txtAddress2.Text = "";
txtAddress3.Text = "";
txtCity.Text = "";
txtPin.Text = "";
txtContactPersonName.Text = "";
txtMobileNo.Text = "";
txtPhone.Text = "";
txtFaxNo.Text = "";
txtEmailID.Text = "";
txtVatNo.Text = "";
grpSort.Visible = false;
grpSearch.Visible = false;
txtPartyNameSearch.Text = "";
strSQL = "SELECT PARTY_CATEGORY_ID, " +
" PARTY_CATEGORY_DESCRIPTION " +
"FROM MST_PARTY_CATEGORY " +
"WHERE INACTIVE_FLAG = 0 " +
"ORDER BY PARTY_CATEGORY_ID ";
dmlService.J_PopulateComboBox(strSQL, ref cmbPartyCategory, J_ComboBoxDefaultText.NO);
}
private void ClearControls()
{
strSQL = "SELECT USER_ID," +
" LOGIN_ID " +
" FROM MST_USER " +
" WHERE BRANCH_ID = " + J_Var.J_pBranchId + " " +
" AND " + cmnService.J_SQLDBFormat("LOGIN_ID", J_SQLColFormat.UCase) + " <> 'ADMIN' " +
" AND USER_ID <> " + J_Var.J_pUserId + " " +
" ORDER BY LOGIN_ID ";
dmlService.J_PopulateComboBox(strSQL, ref cmbUserId);
PopulateDetailGrid();
}
private void BankEntry_Load(object sender, EventArgs e)
{
//Added By dhrub on 03/05/2014 for Set the Grid Size
ViewGrid.Size = new Size(1000, 510);
lblMode.Text = J_Mode.View;
cmnService.J_StatusButton(this, lblMode.Text);
lblTitle.Text = this.Text;
strSQL = "SELECT COMPANY_ID," +
" COMPANY_NAME " +
"FROM MST_COMPANY " +
"WHERE BRANCH_ID = " + J_Var.J_pBranchId + " " +
"AND COMPANY_ID = " + BS_CompanyId.PDSInfotech + " " +
"ORDER BY COMPANY_NAME ";
if (dmlService.J_PopulateComboBox(strSQL, ref cmbCompany, 1) == false)
{
return;
}
strSQL = "SELECT BANK_ID," +
" BANK_NAME " +
"FROM MST_BANK " +
"ORDER BY BANK_NAME ";
if (dmlService.J_PopulateComboBox(strSQL, ref cmbSelectBank) == false)
{
return;
}
cmbCompany.Enabled = true;
BtnSort.BackColor = Color.LightGray;
BtnSort.Enabled = false;
BtnPrint.BackColor = Color.LightGray;
BtnPrint.Enabled = false;
chkCancelledEntry.Checked = false;
}
//
#endregion
#region User Defined Events
#region BankEntry_Load
private void BankEntry_Load(object sender, EventArgs e)
{
//Added By dhrub on 03/05/2014 for Set the Grid Size
//ViewGrid.Size = new Size(1000, 510);
//
lblMode.Text = J_Mode.View;
cmnService.J_StatusButton(this, lblMode.Text);
//
BtnAdd.Enabled = false;
BtnEdit.Enabled = false;
BtnDelete.Enabled = false;
BtnRefresh.Enabled = false;
BtnSearch.Enabled = false;
BtnSort.Enabled = false;
BtnSave.Enabled = false;
BtnCancel.Enabled = false;
BtnPrint.Enabled = false;
BtnAdd.BackColor = Color.LightGray;
BtnEdit.BackColor = Color.LightGray;
BtnSave.BackColor = Color.LightGray;
BtnCancel.BackColor = Color.LightGray;
BtnSort.BackColor = Color.LightGray;
BtnSearch.BackColor = Color.LightGray;
BtnDelete.BackColor = Color.LightGray;
BtnRefresh.BackColor = Color.LightGray;
BtnPrint.BackColor = Color.LightGray;
lblTitle.Text = this.Text;
string strSQL1 = "SELECT ITEM_ID," +
" ITEM_NAME " +
"FROM MST_ITEM " +
"WHERE ONLINE_FLAG = 1 " +
"ORDER BY DEFAULT_ITEM_ONLINE_OFFLINE_BILLING DESC ";
blnExit = false;
if (dmlService.J_PopulateComboBox(strSQL1, ref cmbItemName) == false)
{
return;
}
blnExit = true;
cmbItemName.Enabled = true;
BtnSort.BackColor = Color.LightGray;
BtnSort.Enabled = false;
BtnPrint.BackColor = Color.LightGray;
BtnPrint.Enabled = false;
chkCancelledEntry.Checked = false;
cmbItemName.Select();
}
private void ClearControls()
{
strSQL = "SELECT BRANCH_ID," +
" BRANCH_NAME " +
"FROM MST_SETUP " +
"ORDER BY BRANCH_NAME ";
dmlService.J_PopulateComboBox(strSQL, ref cmbBranch, J_ComboBoxDefaultText.NO);
// 1. Table Name
// 2. Column Name
// 3. Column Data Type
// 4. No. of space
string[,] strArray = { { "MST_FAYEAR", "FA_BEG_DATE", "D", "3" },
{ "MST_FAYEAR", "FA_END_DATE", "D", "3" } };
strSQL = "SELECT FAYEAR_ID," +
" " + dmlService.J_ConcateColumns(strArray) + " AS FA_DATE " +
"FROM MST_FAYEAR " +
"WHERE INACTIVE_FLAG = 0 " +
"ORDER BY FA_BEG_DATE DESC";
dmlService.J_PopulateComboBox(strSQL, ref cmbFAYear, J_ComboBoxDefaultText.NO);
txtPassword.Text = "";
}
private void ClearControls()
{
txtInvAmount.Text = "";
txtAddress1.Text = "";
txtAddress2.Text = "";
txtAddress3.Text = "";
txtCity.Text = "";
txtPin.Text = "";
txtContactPersonName.Text = "";
txtMobileNo.Text = "";
txtEmailID.Text = "";
strSQL = @" SELECT PARTY_CATEGORY_ID,
PARTY_CATEGORY_DESCRIPTION
FROM MST_PARTY_CATEGORY
WHERE INACTIVE_FLAG = 0
ORDER BY PARTY_CATEGORY_ID ";
dmlService.J_PopulateComboBox(strSQL, ref cmbPartyCategory, J_ComboBoxDefaultText.NO);
}
private void ClearControls()
{
strSQL = "SELECT COMPANY_ID," +
" COMPANY_NAME " +
" FROM MST_COMPANY " +
" ORDER BY COMPANY_NAME ";
if (dmlService.J_PopulateComboBox(strSQL, ref cmbCompanyName) == false)
{
return;
}
txtPrefix.Text = "";
txtStartNo.Text = "0";
//txtLastNo.Text = "0";
mskLastDate.Text = "";
txtDisplayText.Text = "";
grpSort.Visible = false;
grpSearch.Visible = false;
txtPrefixSearch.Text = "";
txtStartNoSearch.Text = "0";
txtLastNoSearch.Text = "0";
mskLastDateSearch.Text = "";
}
