public void GetPopupContrpls()
{
objHRInfo = new HRInfo();
DataTable dtBranch = objHRInfo.GetAllBranchList(CommonData.CompanyCode, "BR", "").Tables[0];
UtilityLibrary.PopulateControl(cmbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objHRInfo = null;
}
private void cbCompany_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbCompany.SelectedIndex > 0)
{
objHRInfo = new HRInfo();
UtilityLibrary.PopulateControl(cbBranch, objHRInfo.GetAllBranchList(cbCompany.SelectedValue.ToString(), "BR", "").Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
objHRInfo = null;
}
}
private void cmbCompany_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbCompany.SelectedIndex > 0)
{
objHrInfo = new HRInfo();
DataTable dtBranch = objHrInfo.GetAllBranchList(cmbCompany.SelectedValue.ToString(), "BR", "").Tables[0];
UtilityLibrary.PopulateControl(cmbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objHrInfo = null;
}
}
private void cbCompany_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbCompany.SelectedIndex > 0)
{
objHRInfo = new HRInfo();
UtilityLibrary.PopulateControl(cbBranch, objHRInfo.GetAllBranchList(cbCompany.SelectedValue.ToString(), "BR", "").Tables[0].DefaultView, 1, 0, "--Please Select--", 0);
objHRInfo = null;
objSQLDB = new SQLDB();
string sqlQry = "SELECT PM_PRODUCT_ID,PM_PRODUCT_NAME from dbo.PRODUCT_MAS a inner join product_mas_company b on a.pm_product_id=b.pmc_product_id where pmc_product_company='" + cbCompany.SelectedValue.ToString() + "'";
UtilityLibrary.PopulateControl(cmbProducts, objSQLDB.ExecuteDataSet(sqlQry).Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
objSQLDB = null;
}
}
public void GetPopup()
{
string sqlQry = "SELECT LevelsDesig_mas.LDM_DESIG_ID as desig_id, LevelsDesig_mas.ldm_designations, LevelsDesig_mas.ldm_elevel_id as elevel_id " +
" FROM [dbo].[LevelsDesig_mas] WHERE dbo.LevelsDesig_mas.ldm_company_code = '" + CommonData.CompanyCode + "' ORDER BY ldm_designations ";
objSQLDB = new SQLDB();
dsDesgLvl = objSQLDB.ExecuteDataSet(sqlQry);
UtilityLibrary.PopulateControl(cbddlEORADesig, objSQLDB.ExecuteDataSet(sqlQry).Tables[0].DefaultView, 1, 0, "--Please Select--", 0);
objSQLDB = null;
objHrInfo = new HRInfo();
DataTable dtBranch = objHrInfo.GetAllBranchList(CommonData.CompanyCode, "", "").Tables[0];
UtilityLibrary.PopulateControl(cbddlBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objHrInfo = null;
}
private void ActivityServiceUpdate_Load(object sender, EventArgs e)
{
btnUpdate.Visible = false;
DataSet dsFinYear = new DataSet();
DataTable dtfinYear = new DataTable();
DataTable dtBranch = new DataTable();
gvProductDetails.DefaultCellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 9,
System.Drawing.FontStyle.Regular);
objHRInfo = new HRInfo();
if (sCompany.Length > 0)
{
dtBranch = objHRInfo.GetAllBranchList(sCompany, "BR", "").Tables[0];
}
else
{
dtBranch = objHRInfo.GetAllBranchList(CommonData.CompanyCode, "BR", "").Tables[0];
}
UtilityLibrary.PopulateControl(cmbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objHRInfo = null;
objServiceDB = new ServiceDB();
dsEmployee = objServiceDB.GetInvocieInfoforService("", "", "", "", 103);
objServiceDB = null;
objSQLdb = new SQLDB();
dsFinYear = objSQLdb.ExecuteDataSet("SELECT DISTINCT FY_FIN_YEAR FROM FIN_YEAR");
dtfinYear = dsFinYear.Tables[0];
cmbFinYear.DataSource = null;
if (dtfinYear.Rows.Count > 0)
{
cmbFinYear.DataSource = dtfinYear;
cmbFinYear.DisplayMember = "FY_FIN_YEAR";
cmbFinYear.ValueMember = "FY_FIN_YEAR";
cmbFinYear.SelectedIndex = 0;
cmbFinYear.SelectedValue = CommonData.FinancialYear;
if (sFinYear.Length > 0)
{
cmbFinYear.SelectedValue = sFinYear;
}
}
btnUpdate.Enabled = false;
btnClear.Enabled = false;
btnAddReplDetails.Visible = false;
btnAddCountingDetails.Visible = false;
if (sBranCode.Length > 0)
{
cmbBranch.SelectedValue = sBranCode.Split('@')[0];
}
else
{
if (CommonData.BranchType == "BR")
{
cmbBranch.SelectedValue = CommonData.BranchCode;
}
else
{
cmbBranch.SelectedIndex = 0;
}
}
if (strTrnNo.Length > 0)
{
GetAllInvoicdeData(strTrnNo, "");
txtOrderNo_Validated(null, null);
}
}