private void AddJVAccountDetails_Load(object sender, EventArgs e)
{
txtSiNo.Text = (((JournalVoucher)objJournalVoucher).gvBillDetails.Rows.Count + 1).ToString();
DataTable dtAccMas;
objDB = new SQLDB();
//lblMajorCost.Visible = true;
//cmbMajorCost.Visible = true;
dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_COSTCENTRE_FLAG='Y' and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName");
if (dtAccMas.Rows.Count > 0)
{
DataRow dr = dtAccMas.NewRow();
cmbAccounts.DataSource = dtAccMas;
cmbAccounts.DisplayMember = "AccName";
cmbAccounts.ValueMember = "AM_ACCOUNT_ID";
}
if (drs != null)
{
txtSiNo.Text = drs[0]["SL_NO"].ToString();
cmbAccounts.SelectedValue = drs[0]["ACC_ID"].ToString();
//cmbMajorCost.SelectedValue = drs[0]["MAJCOST_ID"].ToString();
//cbPaymentMode.SelectedItem = drs[0]["PAYMENT_MODE"].ToString();
//txtChqDDNo.Text = drs[0]["CHQ_DD_NO"].ToString();
txtReceivedAmt.Text = drs[0]["AMOUNT"].ToString();
//txtRemarks.Text = drs[0]["REMARKS"].ToString();
}
}
private void OpeningBranchBalances_Load(object sender, EventArgs e)
{
cbCrDr.SelectedIndex = 0;
txtComanpanyName.Text = CommonData.CompanyName;
txtBranch.Text = CommonData.BranchName;
txtFinYear.Text = CommonData.FinancialYear;
startDate = new DateTime(Convert.ToInt32(txtFinYear.Text.Split('-')[0]), 4, 1);
SQLDB objDB = new SQLDB();
DataTable dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode +
"' AND AM_ACCOUNT_TYPE_ID IN('CASH','BANK') and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName");
if (dtAccMas.Rows.Count > 0)
{
DataRow dr = dtAccMas.NewRow();
cmbAccounts.DataSource = dtAccMas;
cmbAccounts.DisplayMember = "AccName";
cmbAccounts.ValueMember = "AM_ACCOUNT_ID";
}
FillGrid();
FillDocMonths();
}
private void FillFCOProducts()
{
objSQLdb = new SQLDB();
cbProbuct.DataSource = null;
//DataTable dt = new DataTable();
try
{
DataTable dtProducts = objSQLdb.ExecuteDataSet("SELECT DISTINCT PM_PRODUCT_NAME,PM_PRODUCT_ID FROM PRODUCT_MAS where PM_PRODUCT_TYPE = 'SNGPK' "
+ " and PM_BRAND_ID in('VIJETHA','SUPREME','WARRIOR') ORDER BY PM_PRODUCT_NAME").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cbProbuct, dtProducts, "", "PM_PRODUCT_NAME");
if (dtProducts.Rows.Count > 0)
{
DataRow row = dtProducts.NewRow();
row[0] = "ALL";
row[1] = "ALL";
dtProducts.Rows.InsertAt(row, 0);
cbProbuct.DataSource = dtProducts;
cbProbuct.DisplayMember = "PM_PRODUCT_NAME";
cbProbuct.ValueMember = "PM_PRODUCT_ID";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objSQLdb = null;
}
}
private void FillBranchData()
{
objSQLdb = new SQLDB();
try
{
DataTable dtUnits = objSQLdb.ExecuteDataSet("SELECT BRANCH_NAME,BRANCH_CODE FROM BRANCH_MAS " +
" WHERE ACTIVE='T' Order by BRANCH_NAME ").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cbUnit, dtUnits, "", "BRANCH_NAME");
if (dtUnits.Rows.Count > 0)
{
DataRow dr = dtUnits.NewRow();
dr[0] = "ALL";
dr[1] = "ALL";
dtUnits.Rows.InsertAt(dr, 0);
cbUnit.DataSource = dtUnits;
cbUnit.DisplayMember = "BRANCH_NAME";
cbUnit.ValueMember = "BRANCH_CODE";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
//dt = null;
}
}
private void FillMajorCostDetails()
{
DataTable dtMajorCost = objDB.ExecuteDataSet(" SELECT MCC_MAJOR_COST_CENTRE_ID,MCC_MAJOR_COST_CENTRE_NAME+' ('+MCC_MAJOR_COST_CENTRE_ID+')' MajorCost FROM FA_MAJOR_COST_CENTRE " +
" WHERE MCC_COMPANY_CODE='" + CommonData.CompanyCode + "'").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cmbMajorCost, dtMajorCost, "MCC_MAJOR_COST_CENTRE_ID", "MajorCost");
if (dtMajorCost.Rows.Count > 0)
{
DataRow dr = dtMajorCost.NewRow();
cmbMajorCost.DataSource = dtMajorCost;
cmbMajorCost.DisplayMember = "MajorCost";
cmbMajorCost.ValueMember = "MCC_MAJOR_COST_CENTRE_ID";
}
}
private void FillTrainerDetails()
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
string strCommand = "";
cbTrainerNames.DataBindings.Clear();
try
{
strCommand = "SELECT DISTINCT(MEMBER_NAME+'-'+CAST(HTAH_TRAINER_ECODE AS VARCHAR)) EmpName ,HTAH_TRAINER_ECODE EmpEcode " +
" FROM HR_TRAINING_ACTUAL_HEAD " +
" inner JOIN EORA_MASTER ON ECODE=HTAH_TRAINER_ECODE " +
" WHERE HTAH_TRAINER_FLAG='INTERNAL' " +
" ORDER BY EmpName asc";
if (strCommand.Length > 5)
{
dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0];
}
UtilityLibrary.AutoCompleteComboBox(cbTrainerNames, dt, "", "EmpName");
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dr[0] = "--Select--";
dr[1] = "0";
dt.Rows.InsertAt(dr, 0);
cbTrainerNames.DataSource = dt;
cbTrainerNames.DisplayMember = "EmpName";
cbTrainerNames.ValueMember = "EmpEcode";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
dt = null;
}
}
private void FillEmployeeData(string strSearch)
{
objData = new InvoiceDB();
DataSet dsEmp = null;
try
{
dsEmp = objData.InvLevelEmpNameSearch(strSearch);
DataTable dtEmp = dsEmp.Tables[0];
if (dtEmp.Rows.Count > 0)
{
UtilityLibrary.AutoCompleteComboBox(cbEcode, dtEmp, "", "ENAME");
cbEcode.DataSource = dtEmp;
cbEcode.DisplayMember = "ENAME";
cbEcode.ValueMember = "ECODE";
}
else
{
cbEcode.DataSource = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cbEcode.SelectedIndex > -1)
{
cbEcode.SelectedIndex = 0;
strECode = ((System.Data.DataRowView)(cbEcode.SelectedItem)).Row.ItemArray[0].ToString();
}
objData = null;
Cursor.Current = Cursors.Default;
}
}
private void PaymentVoucher_Load(object sender, EventArgs e)
{
txtBranch.Text = CommonData.BranchName;
txtDocMonth.Text = CommonData.DocMonth;
cbPaymentMode.SelectedIndex = 0;
//FillMachineDetails();
//FillPunchDetails();
FillCashAcc();
DataTable dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName");
if (dtAccMas.Rows.Count > 0)
{
DataRow dr = dtAccMas.NewRow();
cmbAccounts.DataSource = dtAccMas;
cmbAccounts.DisplayMember = "AccName";
cmbAccounts.ValueMember = "AM_ACCOUNT_ID";
}
GenerateVoucherId();
}
private void AddAccountDetails_Load(object sender, EventArgs e)
{
if (sType == "RECEIPT")
{
lblAmt.Text = "Received Amt";
txtSiNo.Text = (((ReceiptVoucher)objRecieptVoucher).gvBillDetails.Rows.Count + 1).ToString();
DataTable dtAccMas;
objDB = new SQLDB();
if (((ReceiptVoucher)objRecieptVoucher).cbEmpType.SelectedIndex == 1)
{
//lblMajorCost.Visible = false;
//cmbMajorCost.Visible = false;
dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode
+ "' and AM_ACCOUNT_ID <> '" + ((ReceiptVoucher)objRecieptVoucher).cmbCashAccount.SelectedValue
+ "' AND AM_COSTCENTRE_FLAG IS NULL and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
}
else
{
//lblMajorCost.Visible = true;
//cmbMajorCost.Visible = true;
dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_COSTCENTRE_FLAG='Y' and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
}
UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName");
if (dtAccMas.Rows.Count > 0)
{
DataRow dr = dtAccMas.NewRow();
cmbAccounts.DataSource = dtAccMas;
cmbAccounts.DisplayMember = "AccName";
cmbAccounts.ValueMember = "AM_ACCOUNT_ID";
}
if (drs != null)
{
txtSiNo.Text = drs[0]["SL_NO"].ToString();
cmbAccounts.SelectedValue = drs[0]["ACC_ID"].ToString();
//cmbMajorCost.SelectedValue = drs[0]["MAJCOST_ID"].ToString();
//cbPaymentMode.SelectedItem = drs[0]["PAYMENT_MODE"].ToString();
//txtChqDDNo.Text = drs[0]["CHQ_DD_NO"].ToString();
txtReceivedAmt.Text = drs[0]["AMOUNT"].ToString();
//txtRemarks.Text = drs[0]["REMARKS"].ToString();
}
}
else
{
lblAmt.Text = "Paid Amount";
objDB = new SQLDB();
DataTable dtRemarks = objDB.ExecuteDataSet(" SELECT TOP 5 VC_BRANCH_CODE,VC_REMARKS,COUNT(*) FROM FA_VOUCHER WHERE VC_BRANCH_CODE ='" + CommonData.BranchCode + "' " +
"AND VC_DEBIT_CREDIT='D' GROUP BY VC_REMARKS,VC_BRANCH_CODE ORDER BY COUNT(*) DESC").Tables[0];
//UtilityLibrary.AutoCompleteTextBox(txtRemarks, dtRemarks, "", "VC_REMARKS");
//cbPaymentMode.SelectedIndex = 0;
txtSiNo.Text = (((PaymentVouchers)objPaymentVoucher).gvBillDetails.Rows.Count + 1).ToString();
DataTable dtAccMas;
//if (((PaymentVouchers)objPaymentVoucher).cmbEmpType.SelectedIndex == 1)
//{
// //lblMajorCost.Visible = false;
// //cmbMajorCost.Visible = false;
// dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode
// + "' and AM_ACCOUNT_ID <> '" + ((PaymentVouchers)objPaymentVoucher).cmbCashAccount.SelectedValue
// + "' AND AM_COSTCENTRE_FLAG IS NULL and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
//}
//else
//{
//lblMajorCost.Visible = true;
//cmbMajorCost.Visible = true;
dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_COSTCENTRE_FLAG='Y' and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
//}
UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName");
if (dtAccMas.Rows.Count > 0)
{
DataRow dr = dtAccMas.NewRow();
cmbAccounts.DataSource = dtAccMas;
cmbAccounts.DisplayMember = "AccName";
cmbAccounts.ValueMember = "AM_ACCOUNT_ID";
}
if (drs != null)
{
txtSiNo.Text = drs[0]["SL_NO"].ToString();
cmbAccounts.SelectedValue = drs[0]["ACC_ID"].ToString();
//cmbMajorCost.SelectedValue = drs[0]["MAJCOST_ID"].ToString();
//cbPaymentMode.SelectedItem = drs[0]["PAYMENT_MODE"].ToString();
//txtChqDDNo.Text = drs[0]["CHQ_DD_NO"].ToString();
txtReceivedAmt.Text = drs[0]["AMOUNT"].ToString();
//txtRemarks.Text = drs[0]["REMARKS"].ToString();
}
}
}