protected void ddl_emp_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "";
str = "select ESS.ECODE,ESS.BASIC,ESS.PAY_BAND,ESS.CUR_PAY_GRADE,ESS.IT_Amount,MEM.Emp_Name,MEM.DATE_OF_BIRTH,ESS.GPF_ACCT_NO from M_Emp_mast MEM inner join EMP_SALARY_STRUCTURE ESS ON MEM.ECODE=ESS.ECODE Where ESS.ECODE='" + ddl_emp.SelectedValue + "'";
DataTable dt = SQL_DBCS.ExecuteDataTable(str);
if (dt.Rows.Count > 0)
{
lblShowName.Text = dt.Rows[0]["EMP_NAME"].ToString();
lblPersonalNo.Text = dt.Rows[0]["ECODE"].ToString();
lblBasicPay.Text = dt.Rows[0]["BASIC"].ToString();
lblPayAccount.Text = dt.Rows[0]["GPF_ACCT_NO"].ToString();
//lblGPFNo.Text = dt.Rows[0]["GPF_ACCT_NO"].ToString();
// lblRank.Text = ddlEmpType.SelectedItem.ToString();
cc.FillDDL(ref ddlHdtrOffice, "---Select Department---", "DepartmentName", "DepartmentCode", "M_Department");
ddlHdtrOffice.SelectedIndex = 1;
lblCorpOffice.Text = ddlHdtrOffice.SelectedItem.ToString();
BindRefrenceno();
}
else
{
lblShowName.Visible = false;
}
BindRefrenceno();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.Add("NameOfPlace_Arrived_At");
dt.Columns.Add("Arvl_Date");
dt.Columns.Add("Arvl_Hrs");
dt.Columns.Add("Distance_by_Road");
dt.Columns.Add("ConveyMode");
dt.Columns.Add("ConveyClass");
dt.Columns.Add("Departure_Date");
dt.Columns.Add("Departure_Hrs");
dt.Columns.Add("NoOfDA");
dt.Columns.Add("Rate_RMA_DA");
dt.Columns.Add("Amount");
dt.Columns.Add("Remark");
ViewState["dt"] = dt;
bind_FinancialYear();
binddesig_type();
bindchildgrd();
bindgrdData();
cc.FillDDL(ref ddlHdtrOffice, "---Select Department---", "DepartmentName", "DepartmentCode", "M_Department");
ddlHdtrOffice.SelectedIndex = 1;
}
}
