protected void Load_menus()
{
CultureInfo culinfo = Thread.CurrentThread.CurrentCulture;
TextInfo txtinfo = culinfo.TextInfo;
DataTable ddicno1_stf = new DataTable();
ddicno1_stf = DBCon.Ora_Execute_table("select * from KK_User_Login where KK_userid='" + Session["New"].ToString() + "'");
DataSet ds = new DataSet();
DataTable FromTable = new DataTable();
List <Protopbaners> details1 = new List <Protopbaners>();
con1.Open();
string cmdstr = "select * from KK_Role_skrins s1 left join KK_PID_presub1_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id and s1.sub_skrin_id=s2.KK_Sskrin_id and s1.psub_skrin_id=s2.KK_Spreskrin_id and s1.psub1_skrin_id=s2.KK_Spreskrin1_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') and KK_Spreskrin_id IN ('" + Request.QueryString["edit"].ToString() + "')";
//string cmdstr = "select s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon from KK_Role_skrins s1 left join KK_PID_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') group by s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon order by cast(s2.position as int) asc";
SqlCommand cmd = new SqlCommand(cmdstr, con1);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
cmd.ExecuteNonQuery();
FromTable = ds.Tables[0];
if (FromTable.Rows.Count != 0)
{
foreach (DataRow dtrow in FromTable.Rows)
{
Protopbaners user1 = new Protopbaners();
user1.mod_val1 = txtinfo.ToTitleCase(dtrow["KK_Spreskrin1_name"].ToString().ToLower());
if (dtrow["KK_preskrin1_link"].ToString() == "#")
{
user1.mod_val6 = "href='#'";
}
else
{
user1.mod_val6 = "href='/" + dtrow["KK_preskrin1_link"].ToString() + "'";
}
user1.mod_val2 = dtrow["KK_Spreskrin1_ikon"].ToString();
details1.Add(user1);
}
ds.Dispose();
con1.Close();
bnd_mmenus.DataSource = details1.ToArray();
bnd_mmenus.DataBind();
}
}
protected void Modules()
{
DataTable ddicno1_stf = new DataTable();
ddicno1_stf = DBCon.Ora_Execute_table("select * from KK_User_Login where KK_userid='" + Session["New"].ToString() + "'");
DataSet ds = new DataSet();
DataTable FromTable = new DataTable();
List <Protopbaners> details1 = new List <Protopbaners>();
con.Open();
string cmdstr = "select s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon from KK_Role_skrins s1 left join KK_PID_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id where Status='A' group by s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon order by cast(s2.position as int) asc";
//string cmdstr = "select s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon from KK_Role_skrins s1 left join KK_PID_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') group by s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon order by cast(s2.position as int) asc";
SqlCommand cmd = new SqlCommand(cmdstr, con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
cmd.ExecuteNonQuery();
FromTable = ds.Tables[0];
if (FromTable.Rows.Count != 0)
{
foreach (DataRow dtrow in FromTable.Rows)
{
Protopbaners user1 = new Protopbaners();
user1.mod_val1 = dtrow["skrin_id"].ToString();
user1.mod_val2 = dtrow["KK_Skrin_name"].ToString();
user1.mod_val3 = dtrow["skrin_ikon"].ToString();
user1.mod_val4 = dtrow["skrin_id"].ToString();
user1.mod_val5 = dtrow["position"].ToString();
if (dtrow["skrin_id"].ToString() == "M0007")
{
user1.mod_val7 = "1";
}
else if (dtrow["skrin_id"].ToString() == "M0005")
{
user1.mod_val7 = "2";
}
else if (dtrow["skrin_id"].ToString() == "M0008")
{
user1.mod_val7 = "3";
}
else if (dtrow["skrin_id"].ToString() == "M0001")
{
user1.mod_val7 = "4";
}
else if (dtrow["skrin_id"].ToString() == "M0006")
{
user1.mod_val7 = "5";
}
else if (dtrow["skrin_id"].ToString() == "M0002")
{
user1.mod_val7 = "6";
}
else if (dtrow["skrin_id"].ToString() == "M0003")
{
user1.mod_val7 = "7";
}
else if (dtrow["skrin_id"].ToString() == "M0004")
{
user1.mod_val7 = "8";
}
chk_menu = DBCon.Ora_Execute_table("select s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon from KK_Role_skrins s1 left join KK_PID_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') and s2.KK_Skrin_id = '" + dtrow["skrin_id"].ToString() + "' group by s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon order by cast(s2.position as int) asc");
if (chk_menu.Rows.Count == 0)
{
user1.mod_val6 = "style='cursor:no-drop'";
user1.mod_val7 = "9";
user1.mod_val8 = "#";
}
else
{
if (dtrow["skrin_id"].ToString() == "M0001")
{
user1.mod_val8 = "/HR_Dashboard.aspx";
}
else if (dtrow["skrin_id"].ToString() == "M0002")
{
user1.mod_val8 = "/Finance_dashboard.aspx";
}
else if (dtrow["skrin_id"].ToString() == "M0007")
{
if (Session["roles"].ToString() != "R0016")
{
user1.mod_val8 = "/Dashboard.aspx";
}
else
{
user1.mod_val8 = "keanggotan/Maklumat_Anggota.aspx";
}
}
else if (dtrow["skrin_id"].ToString() == "M0003")
{
user1.mod_val8 = "/Dashboard.aspx";
}
else if (dtrow["skrin_id"].ToString() == "M0006")
{
user1.mod_val8 = "/#";
user1.mod_val9 = "style='pointer-events:none;'";
}
//else if (dtrow["skrin_id"].ToString() == "M0005")
//{
// user1.mod_val8 = "/#";
// user1.mod_val9 = "style='pointer-events:none;'";
//}
else if (dtrow["skrin_id"].ToString() == "M0008")
{
user1.mod_val8 = "/Dashboard.aspx";
}
else if (dtrow["skrin_id"].ToString() == "M0004")
{
user1.mod_val8 = "/settings/site_settings.aspx";
}
else
{
user1.mod_val8 = "/Dashboard.aspx";
}
user1.mod_val6 = "style='cursor:pointer'";
}
details1.Add(user1);
}
ds.Dispose();
con.Close();
bnd_modules.DataSource = details1.ToArray();
bnd_modules.DataBind();
}
}
protected void Load_sub_menus()
{
string main_mm1 = string.Empty, main_mm2 = string.Empty, main_mm3 = string.Empty, main_mm4 = string.Empty;
//if (Session["site_languaage"].ToString() == "mal") { main_mm1 = "KK_Skrin_name"; main_mm2 = "KK_Sskrin_name"; main_mm3 = "KK_Spreskrin_name"; main_mm4 = "KK_Spreskrin1_name"; } else { main_mm1 = "KK_Skrin_name_en"; main_mm2 = "KK_Sskrin_name_en"; main_mm3 = "KK_Spreskrin_name_en"; main_mm4 = "KK_Spreskrin1_name_en"; }
CultureInfo culinfo = Thread.CurrentThread.CurrentCulture;
TextInfo txtinfo = culinfo.TextInfo;
DataTable ddicno1_stf = new DataTable();
ddicno1_stf = DBCon.Ora_Execute_table("select * from KK_User_Login where KK_userid='" + Session["New"].ToString() + "'");
DataSet ds = new DataSet();
DataTable FromTable = new DataTable();
List <Protopbaners> details1 = new List <Protopbaners>();
con.Close();
con.Open();
string cmdstr = "select s1.skrin_id,s1.sub_skrin_id,s2.position,s2.KK_Sskrin_name,s2.KK_skrin_link,s2.subskrin_ikon from KK_Role_skrins s1 left join KK_PID_Sub_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id and s1.sub_skrin_id=s2.KK_Sskrin_id and s2.Status='A' where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') and KK_Skrin_id='" + Session["mnu_id"].ToString() + "' group by s1.skrin_id,s1.sub_skrin_id,s2.position,s2.KK_Sskrin_name,s2.KK_skrin_link,s2.subskrin_ikon order by cast(s2.position as int) asc";
//string cmdstr = "select s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon from KK_Role_skrins s1 left join KK_PID_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') group by s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon order by cast(s2.position as int) asc";
SqlCommand cmd = new SqlCommand(cmdstr, con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
cmd.ExecuteNonQuery();
FromTable = ds.Tables[0];
if (FromTable.Rows.Count != 0)
{
foreach (DataRow dtrow in FromTable.Rows)
{
DataTable bind_presmenu = new DataTable();
bind_presmenu = DBCon.Ora_Execute_table("select s1.skrin_id,s1.sub_skrin_id,s1.psub_skrin_id,s2.position,s2.KK_Spreskrin_name,s2.KK_preskrin_link from KK_Role_skrins s1 left join KK_PID_presub_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id and s1.sub_skrin_id=s2.KK_Sskrin_id and s1.psub_skrin_id=s2.KK_Spreskrin_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') and s1.psub_skrin_id != '' and KK_Skrin_id='" + dtrow["skrin_id"].ToString() + "' and KK_Sskrin_id IN ('" + dtrow["sub_skrin_id"].ToString() + "') and s2.Status='A' group by s1.skrin_id,s1.sub_skrin_id,s1.psub_skrin_id,s2.position,s2.KK_Spreskrin_name,s2.KK_preskrin_link order by cast(s2.position as int) asc");
Protopbaners user1 = new Protopbaners();
user1.mod_val1 = dtrow["skrin_id"].ToString();
user1.mod_val2 = dtrow["sub_skrin_id"].ToString();
user1.mod_val3 = txtinfo.ToTitleCase(dtrow["KK_Sskrin_name"].ToString().ToLower());
user1.mod_val4 = dtrow["KK_skrin_link"].ToString();
user1.mod_val5 = dtrow["subskrin_ikon"].ToString();
if (llk2 == dtrow["sub_skrin_id"].ToString())
{
main_mm1 = "active";
}
else
{
main_mm1 = "";
}
htmlTable.Append("<div id='" + dtrow["sub_skrin_id"].ToString() + "' class='tab-pane kt-tab-menu-bg animated flipInX " + main_mm1 + "'><ul class='kt-main-menu-dropdown'>");
for (int k = 0; k < bind_presmenu.Rows.Count; k++)
{
if (llk3 == bind_presmenu.Rows[k]["psub_skrin_id"].ToString())
{
main_mm2 = "owl-item-active";
}
else
{
main_mm2 = "";
}
DataTable bind_presmenu1 = new DataTable();
bind_presmenu1 = DBCon.Ora_Execute_table("select s1.skrin_id,s1.sub_skrin_id,s1.psub_skrin_id,s1.psub1_skrin_id,s2.position,s2.KK_Spreskrin1_name,s2.KK_preskrin1_link from KK_Role_skrins s1 left join KK_PID_presub1_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id and s1.sub_skrin_id=s2.KK_Sskrin_id and s1.psub_skrin_id=s2.KK_Spreskrin_id and s1.psub1_skrin_id=s2.KK_Spreskrin1_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') and s1.psub1_skrin_id != '' and KK_Skrin_id='" + dtrow["skrin_id"].ToString() + "' and KK_Sskrin_id IN ('" + dtrow["sub_skrin_id"].ToString() + "') and KK_Spreskrin_id IN ('" + bind_presmenu.Rows[k]["psub_skrin_id"].ToString() + "') group by s1.skrin_id,s1.sub_skrin_id,s1.psub_skrin_id,s1.psub1_skrin_id,s2.position,s2.KK_Spreskrin1_name,s2.KK_preskrin1_link order by cast(s2.position as int) asc");
string sv1 = string.Empty;
if (bind_presmenu.Rows[k]["KK_preskrin_link"].ToString() != "#")
{
sv1 = "";
}
else
{
sv1 = "data-toggle='tab'";
}
htmlTable.Append("<li class='dropdown " + main_mm2 + "'><a class='dropbtn' " + sv1 + " href='" + "/" + bind_presmenu.Rows[k]["KK_preskrin_link"].ToString() + "'>" + txtinfo.ToTitleCase(bind_presmenu.Rows[k]["KK_Spreskrin_name"].ToString().ToLower()) + "</a>");
if (bind_presmenu1.Rows.Count != 0)
{
htmlTable.Append("<div class='dropdown-content'>");
for (int m = 0; m < bind_presmenu1.Rows.Count; m++)
{
htmlTable.Append("<a href = '" + "/" + bind_presmenu1.Rows[m]["KK_preskrin1_link"].ToString() + "'> " + txtinfo.ToTitleCase(bind_presmenu1.Rows[m]["KK_Spreskrin1_name"].ToString().ToLower()) + " </ a >");
}
htmlTable.Append("</div></li>");
}
}
htmlTable.Append("</ul></div>");
details1.Add(user1);
}
plholder1.Controls.Add(new Literal {
Text = htmlTable.ToString()
});
//mobile_view
//plholder1_mob.Controls.Add(new Literal { Text = htmlTable.ToString() });
}
con.Close();
}
protected void Load_menus()
{
CultureInfo culinfo = Thread.CurrentThread.CurrentCulture;
TextInfo txtinfo = culinfo.TextInfo;
DataTable ddicno1_stf = new DataTable();
ddicno1_stf = DBCon.Ora_Execute_table("select * from KK_User_Login where KK_userid='" + Session["New"].ToString() + "'");
if (Session["mnu_id"].ToString() == "M0001")
{
gt_dshbrd.Attributes.Add("href", "/HR_Dashboard.aspx");
}
else if (Session["mnu_id"].ToString() == "M0002")
{
gt_dshbrd.Attributes.Add("href", "/Finance_dashboard.aspx");
}
else if (Session["mnu_id"].ToString() == "M0004")
{
dash_lbl1.Visible = false;
}
else if (Session["mnu_id"].ToString() == "M0007" && Session["roles"].ToString() == "R0016")
{
dash_lbl1.Visible = false;
}
else
{
gt_dshbrd.Attributes.Add("href", "/Dashboard.aspx");
}
if (fileName == "HR_Dashboard.aspx" || fileName == "Dashboard.aspx" || fileName == "Finance_dashboard.aspx" || fileName == "HR_recent_cuti.aspx")
{
dash_lbl1.Attributes.Add("class", "active owl-item-active");
}
else
{
dash_lbl1.Attributes.Add("class", "active");
}
DataSet ds = new DataSet();
DataTable FromTable = new DataTable();
List <Protopbaners> details1 = new List <Protopbaners>();
con.Open();
string cmdstr = "select s1.skrin_id,s1.sub_skrin_id,s2.position,s2.KK_Sskrin_name,s2.KK_skrin_link,s2.subskrin_ikon from KK_Role_skrins s1 left join KK_PID_Sub_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id and s1.sub_skrin_id=s2.KK_Sskrin_id and s2.Status='A' where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') and KK_Skrin_id='" + Session["mnu_id"].ToString() + "' group by s1.skrin_id,s1.sub_skrin_id,s2.position,s2.KK_Sskrin_name,s2.KK_skrin_link,s2.subskrin_ikon order by cast(s2.position as int) asc";
//string cmdstr = "select s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon from KK_Role_skrins s1 left join KK_PID_Skrin s2 on s2.KK_Skrin_id=s1.skrin_id where Role_id IN ('" + ddicno1_stf.Rows[0]["KK_roles"].ToString().Replace(",", "','") + "') group by s1.skrin_id,s2.position,s2.KK_Skrin_name,s2.skrin_ikon order by cast(s2.position as int) asc";
SqlCommand cmd = new SqlCommand(cmdstr, con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
cmd.ExecuteNonQuery();
FromTable = ds.Tables[0];
if (FromTable.Rows.Count != 0)
{
foreach (DataRow dtrow in FromTable.Rows)
{
Protopbaners user1 = new Protopbaners();
user1.mod_val1 = dtrow["skrin_id"].ToString();
user1.mod_val2 = dtrow["sub_skrin_id"].ToString();
user1.mod_val3 = txtinfo.ToTitleCase(dtrow["KK_Sskrin_name"].ToString().ToLower());
user1.mod_val4 = dtrow["KK_skrin_link"].ToString();
user1.mod_val5 = dtrow["subskrin_ikon"].ToString();
if (dtrow["KK_skrin_link"].ToString() == "#")
{
user1.mod_val6 = "data-toggle='tab' href='#" + dtrow["sub_skrin_id"].ToString() + "'";
}
else
{
user1.mod_val6 = "href='/" + dtrow["KK_skrin_link"].ToString() + "'";
}
if (dtrow["sub_skrin_id"].ToString() == llk2)
{
user1.mod_val7 = "owl-item-active";
}
else
{
user1.mod_val7 = "";
}
details1.Add(user1);
}
ds.Dispose();
con.Close();
bnd_mmenus.DataSource = details1.ToArray();
bnd_mmenus.DataBind();
//mobile_view
//bnd_mmenus_mob.DataSource = details1.ToArray();
//bnd_mmenus_mob.DataBind();
}
}
