private void TxtUserName_KeyDown(object sender, KeyEventArgs e)
{
//if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Tab)
{
DataSet dsGetUser = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USERMASTER_BY_USER(txtUserName.Text.Trim()));
if (ComparisonUtils.IsNotNull_DataSet(dsGetUser))
{
GlobalVariables.CurrentUser = txtUserName.Text;
DataSet dsUnit = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_UNITS_BY_USER(txtUserName.Text));
if (ComparisonUtils.IsNotNull_DataSet(dsUnit))
{
txtUnit.DataSource = dsUnit.Tables[0];
txtUnit.ValueMember = SQL_COLUMNS.UNITS._UNITID;
txtUnit.DisplayMember = SQL_COLUMNS.UNITS._UNITNAME;
}
DataSet dsFNYear = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USER_FN_ACCESS_BY_USER(txtUserName.Text));
if (ComparisonUtils.IsNotNull_DataSet(dsFNYear))
{
txtFNYear.DataSource = dsFNYear.Tables[0];
txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
}
DataSet dsFNYear2 = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_FN_YEAR_ACTIVE("Y"));
if (ComparisonUtils.IsNotNull_DataSet(dsFNYear2))
{
txtFNYear.SelectedValue = dsFNYear2.Tables[0].Rows[0]["FNYearCode"].ToString();
//txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
//txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
}
}
else
{
ProjectFunctions.SpeakError("Invalid UserName");
}
}
}
