public void TextEmpID_TextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(DropDownEmployeeID.Text))
{
alert_box.Visible = false;
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from NRC_USER where EMP_ID = '" + DropDownEmployeeID.Text + "'";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
CheckEmpID.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> This Employee is already include user list</label>";
CheckEmpID.ForeColor = System.Drawing.Color.Red;
DropDownEmployeeID.Focus();
BtnAdd.Attributes.Add("aria-disabled", "false");
BtnAdd.Attributes.Add("class", "btn btn-primary disabled");
}
else
{
CheckEmpID.Text = "<label class='control-label'><i class='fa fa fa-check'></i> This Employee has not user list</label>";
CheckEmpID.ForeColor = System.Drawing.Color.Green;
DropDownEmployeeID.Focus();
BtnAdd.Attributes.Add("aria-disabled", "true");
BtnAdd.Attributes.Add("class", "btn btn-primary active");
}
}
else
{
CheckEmpID.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Select Employee is not blank</label>";
CheckEmpID.ForeColor = System.Drawing.Color.Red;
DropDownEmployeeID.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER_NAME"] != null)
{
string requestedFile = Path.GetFileName(Request.Path);
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE, NUPP.IS_REPORT_ACTIVE, NUPP.IS_PRINT_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' ";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString();
IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString();
IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString();
IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString();
IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString();
IS_REPORT_ACTIVE = dt.Rows[i]["IS_REPORT_ACTIVE"].ToString();
IS_PRINT_ACTIVE = dt.Rows[i]["IS_PRINT_ACTIVE"].ToString();
}
if (IS_PAGE_ACTIVE == "Enable")
{
if (!IsPostBack)
{
DataTable dtEmployeeID = new DataTable();
DataSet dse = new DataSet();
string makeEmployeeSQL = " SELECT EMP_ID, EMP_FNAME || ' ' ||EMP_LNAME AS EMP_NAME FROM HR_EMPLOYEES WHERE IS_ACTIVE = 'Enable' ORDER BY EMP_ID ASC";
dse = ExecuteBySqlString(makeEmployeeSQL);
dtEmployeeID = (DataTable)dse.Tables[0];
DropDownEmployeeID.DataSource = dtEmployeeID;
DropDownEmployeeID.DataValueField = "EMP_ID";
DropDownEmployeeID.DataTextField = "EMP_NAME";
DropDownEmployeeID.DataBind();
DropDownEmployeeID.Items.Insert(0, new ListItem("Select Petty Cash Holder", "0"));
DataTable dtClaimID = new DataTable();
DataSet dsc = new DataSet();
string makeClaimSQL = " SELECT * FROM WP_PURCHASE_CLAIM WHERE IS_ACTIVE = 'Enable' AND IS_CHECK = 'Incomplete' ORDER BY CLAIM_NO ASC";
dsc = ExecuteBySqlString(makeClaimSQL);
dtClaimID = (DataTable)dsc.Tables[0];
DropDownClaimID.DataSource = dtClaimID;
DropDownClaimID.DataValueField = "CLAIM_NO";
DropDownClaimID.DataTextField = "CLAIM_NO";
DropDownClaimID.DataBind();
DropDownClaimID.Items.Insert(0, new ListItem("Select Claim ID ", "0"));
DataTable dtPaymentTypeID = new DataTable();
DataSet ds = new DataSet();
string makeRoleSQL = " SELECT PAYMENT_TYPE_ID, PAYMENT_TYPE_NAME FROM NRC_PAYMENT_TYPE WHERE IS_ACTIVE = 'Enable' ORDER BY PAYMENT_TYPE_ID ASC ";
ds = ExecuteBySqlString(makeRoleSQL);
dtPaymentTypeID = (DataTable)ds.Tables[0];
DropDownPaymentTypeID.DataSource = dtPaymentTypeID;
DropDownPaymentTypeID.DataValueField = "PAYMENT_TYPE_ID";
DropDownPaymentTypeID.DataTextField = "PAYMENT_TYPE_NAME";
DropDownPaymentTypeID.DataBind();
// DropDownPaymentTypeID.Items.Insert(0, new ListItem("Select User Role", "0"));
TextClaimNo.Enabled = false;
DropDownEmployeeID.Enabled = false;
TextMonthYear4.Enabled = false;
EntryDate.Enabled = false;
DropDownPaymentTypeID.Enabled = false;
DropDownSlipNo.Enabled = false;
TextTotalAmount.Enabled = false;
// CheckIsActive.Enabled = false;
QueryCmo.Visible = false;
BtnUpdate.Attributes.Add("aria-disabled", "false");
BtnUpdate.Attributes.Add("class", "btn btn-success disabled");
Display();
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER_NAME"] != null)
{
string requestedFile = Path.GetFileName(Request.Path);
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' ";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString();
IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString();
IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString();
IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString();
IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString();
}
if (IS_PAGE_ACTIVE == "Enable")
{
// lb1.Text = "<b><font color=Brown>" + "WELLCOME :: " + "</font>" + "<b><font color=red>" + Session["USER_NAME"] + " User ID:" + Session["USER_ID"] + "</font>";
if (!IsPostBack)
{
DataTable dtEmployeeID = new DataTable();
DataSet dse = new DataSet();
string makeEmployeeSQL = " SELECT EMP_ID, EMP_FNAME || ' ' ||EMP_LNAME AS EMP_NAME FROM HR_EMPLOYEES WHERE IS_ACTIVE = 'Enable' ORDER BY EMP_ID ASC";
dse = ExecuteBySqlStringUserType(makeEmployeeSQL);
dtEmployeeID = (DataTable)dse.Tables[0];
DropDownEmployeeID.DataSource = dtEmployeeID;
DropDownEmployeeID.DataValueField = "EMP_ID";
DropDownEmployeeID.DataTextField = "EMP_NAME";
DropDownEmployeeID.DataBind();
DropDownEmployeeID.Items.Insert(0, new ListItem("Select Employee", "0"));
DataTable dtUserRoleID = new DataTable();
DataSet ds = new DataSet();
string makeRoleSQL = " SELECT USER_ROLE_ID, USER_ROLE_SHORT_NAME || ' - ' ||USER_ROLE_NAME AS USER_ROLE_SNAME FROM NRC_USER_ROLE WHERE IS_ACTIVE = 'Enable' ";
ds = ExecuteBySqlStringUserType(makeRoleSQL);
dtUserRoleID = (DataTable)ds.Tables[0];
DropDownUserRoleID.DataSource = dtUserRoleID;
DropDownUserRoleID.DataValueField = "USER_ROLE_ID";
DropDownUserRoleID.DataTextField = "USER_ROLE_SNAME";
DropDownUserRoleID.DataBind();
DropDownUserRoleID.Items.Insert(0, new ListItem("Select User Role", "0"));
Display();
TextPassword.TextMode = TextBoxMode.Password;
TextPasswordConfirm.Text = "";
ChangeOpen.Visible = false;
alert_box.Visible = false;
BtnUpdate.Attributes.Add("aria-disabled", "false");
BtnUpdate.Attributes.Add("class", "btn btn-success disabled");
BtnDelete.Attributes.Add("aria-disabled", "false");
BtnDelete.Attributes.Add("class", "btn btn-danger disabled");
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER_NAME"] != null)
{
string requestedFile = Path.GetFileName(Request.Path);
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' ";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString();
IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString();
IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString();
IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString();
IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString();
}
if (IS_PAGE_ACTIVE == "Enable")
{
if (!IsPostBack)
{
DataTable dtEmpID = new DataTable();
DataSet ds = new DataSet();
string makeEmpSQL = " SELECT EMP_ID, EMP_ID || ' - ' || EMP_FNAME || ' ' || EMP_LNAME AS EMP_NAME from HR_EMPLOYEES WHERE IS_ACTIVE = 'Enable' ORDER BY EMP_ID ASC";
ds = ExecuteBySqlString(makeEmpSQL);
dtEmpID = (DataTable)ds.Tables[0];
DropDownEmployeeID.DataSource = dtEmpID;
DropDownEmployeeID.DataValueField = "EMP_ID";
DropDownEmployeeID.DataTextField = "EMP_NAME";
DropDownEmployeeID.DataBind();
DropDownEmployeeID.Items.Insert(0, new ListItem("Select Employee", "0"));
DataTable dtItemID = new DataTable();
DataSet di = new DataSet();
string makeItemSQL = " SELECT IAEI.EMP_ITEMS_ID, AI.ITEM_NAME || ' - ' || AI.ITEM_TYPE || ' ' || AI.ITEM_BRAND AS ITEM_NAME_ALL from IT_ASSET_EMP_ITEMS IAEI LEFT JOIN IT_ASSET_ITEMS AI ON AI.ITEM_ID = IAEI.ITEM_ID LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AI.ITEM_CATEGORY_ID WHERE AI.IS_ACTIVE = 'Enable' AND (AIC.ITEM_CAT_QR_PRI_CODE = 'CPU' OR AIC.ITEM_CAT_QR_PRI_CODE = 'ITD') ORDER BY AI.ITEM_ID ASC";
di = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)di.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "EMP_ITEMS_ID";
DropDownItemID.DataTextField = "ITEM_NAME_ALL";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
DataTable dtItemExpID = new DataTable();
DataSet die = new DataSet();
string makeItemExpSQL = " SELECT AIE.ITEM_EXP_ID, AIE.ITEM_EXP_NAME from IT_ASSET_ITEM_EXPIRES AIE LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AIE.ITEM_CATEGORY_ID WHERE AIE.IS_ACTIVE = 'Enable' ORDER BY AIE.ITEM_EXP_ID ASC";
die = ExecuteBySqlString(makeItemExpSQL);
dtItemExpID = (DataTable)die.Tables[0];
DropDownItemExpID.DataSource = dtItemExpID;
DropDownItemExpID.DataValueField = "ITEM_EXP_ID";
DropDownItemExpID.DataTextField = "ITEM_EXP_NAME";
DropDownItemExpID.DataBind();
DropDownItemExpID.Items.Insert(0, new ListItem("Select Item Expire", "0"));
DataTable dtDepartmentID = new DataTable();
DataSet dep = new DataSet();
string makeDepartmentSQL = " SELECT * FROM HR_EMP_DEPARTMENTS WHERE IS_ACTIVE = 'Enable' ORDER BY DEPARTMENT_ID ASC";
dep = ExecuteBySqlString(makeDepartmentSQL);
dtDepartmentID = (DataTable)dep.Tables[0];
DropDownDepartmentID.DataSource = dtDepartmentID;
DropDownDepartmentID.DataValueField = "DEPARTMENT_ID";
DropDownDepartmentID.DataTextField = "DEPARTMENT_NAME";
DropDownDepartmentID.DataBind();
DropDownDepartmentID.Items.Insert(0, new ListItem("Select Department", "0"));
DataTable dtDivisionID = new DataTable();
DataSet dsd = new DataSet();
string makeDivisionSQL = " SELECT * FROM HR_EMP_DIVISIONS WHERE IS_ACTIVE = 'Enable' ORDER BY DIVISION_ID ASC";
dsd = ExecuteBySqlString(makeDivisionSQL);
dtDivisionID = (DataTable)dsd.Tables[0];
DropDownDivisionID.DataSource = dtDivisionID;
DropDownDivisionID.DataValueField = "DIVISION_ID";
DropDownDivisionID.DataTextField = "DIVISION_NAME";
DropDownDivisionID.DataBind();
DropDownDivisionID.Items.Insert(0, new ListItem("Select Division", "0"));
DataTable dtLocationID = new DataTable();
DataSet dsl = new DataSet();
string makeLocationSQL = " SELECT * FROM HR_EMP_LOCATIONS WHERE IS_ACTIVE = 'Enable' ORDER BY LOCATION_ID ASC";
dsl = ExecuteBySqlString(makeLocationSQL);
dtLocationID = (DataTable)dsl.Tables[0];
DropDownLocationID.DataSource = dtLocationID;
DropDownLocationID.DataValueField = "LOCATION_ID";
DropDownLocationID.DataTextField = "LOCATION_NAME";
DropDownLocationID.DataBind();
DropDownLocationID.Items.Insert(0, new ListItem("Select Location", "0"));
DataTable dtPlacementID = new DataTable();
DataSet depl = new DataSet();
string makePlacementSQL = " SELECT * FROM IT_ASSET_ITEMS_PLACEMENT WHERE IS_ACTIVE = 'Enable' ORDER BY PLACEMENT_ID ASC";
depl = ExecuteBySqlString(makePlacementSQL);
dtPlacementID = (DataTable)depl.Tables[0];
DropDownPlacementID.DataSource = dtPlacementID;
DropDownPlacementID.DataValueField = "PLACEMENT_ID";
DropDownPlacementID.DataTextField = "PLACEMENT_NAME";
DropDownPlacementID.DataBind();
DropDownPlacementID.Items.Insert(0, new ListItem("Select Placement", "0"));
// Display();
DropDownItemID.Attributes.Add("disabled", "disabled");
// TextQrImage.Visible = false;
alert_box.Visible = false;
ExpDept.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
