protected void Page_Load(object sender, EventArgs e)
{
connectionString = WebConfigurationManager.ConnectionStrings["FleetConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
try
{
HttpCookie cookie = Request.Cookies["UserName"];
string varName = "";
if (cookie != null)
{
varName = cookie["varUserName"];
txtUserLabel.Text = varName;
}
else
{
txtUserLabel.Text = "No cookies found";
}
varPageName = "Tyres Requisitions Report";
//**********************************************************
// Create the Command.
AXcontrol DB = new AXcontrol();
//**********************************************************
// Create the Command.
//string insertSQL = "select * from tb_RoleUser where userid=@userid";
//SqlCommand cmd = new SqlCommand(insertSQL, con);
//cmd.Parameters.AddWithValue("@userid", txtUserLabel.Text);
//SqlDataReader reader;
//con.Open();
//reader = cmd.ExecuteReader();
//reader.Read();
string varUserPresence = DB.FindUserPresence(txtUserLabel.Text);
if (varUserPresence.Length > 0)
{
string varRole = varUserPresence.ToString(); // (string)reader["role"];
//string query = "SELECT * FROM operator_permission where role=@role and menus=@menus";
//SqlConnection con1 = new SqlConnection(connectionString1);
//SqlCommand cmd1 = new SqlCommand(query, con1);
//cmd1.Parameters.AddWithValue("@role", varRole);
//cmd1.Parameters.AddWithValue("@menus", varPageName1);
//SqlDataReader readerPermissions;
//con1.Open();
//readerPermissions = cmd1.ExecuteReader();
//readerPermissions.Read();
DataSet ds = new DataSet();
ds = DB.FindRoleMenus(varRole, varPageName);
if (ds.Tables[0].Rows.Count == 0)
{
lblResults.Text = "No permissions found for role " + varRole;
}
else
{
string varMenu = DB.FindRoleMenusCreate(varRole, varPageName);
if (varMenu == "false")
{
cmdAdd.Visible = false;
}
else
{
cmdAdd.Visible = true;
}
varMenu = DB.FindRoleMenusRead(varRole, varPageName);
if (varMenu == "false")
{
GridView1.Visible = false;
}
else
{
GridView1.Visible = true;
}
varMenu = DB.FindRoleMenusUpdate(varRole, varPageName);
if (varMenu == "false")
{
cmdEdit.Visible = false;
}
else
{
cmdEdit.Visible = true;
}
varMenu = DB.FindRoleMenusDelete(varRole, varPageName);
if (varMenu == "false")
{
cmdDelete.Visible = false;
}
else
{
cmdDelete.Visible = true;
}
}
}
}
catch (Exception err)
{
EventLog log = new EventLog();
log.Source = "Stock Sales";
log.WriteEntry(err.Message, EventLogEntryType.Error);
return;
}
finally
{
con.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
HttpCookie cookie = Request.Cookies["UserName"];
string varName = "";
if (cookie != null)
{
varName = cookie["varUserName"];
txtUserLabel.Text = varName;
}
else
{
txtUserLabel.Text = "No cookies found";
}
varPageName = "Setup Operator";
//**********************************************************
// Create the Command.
AXcontrol DB = new AXcontrol();
string varUserPresence = DB.FindUserPresence(txtUserLabel.Text);
if (varUserPresence.Length > 0)
{
string varRole = varUserPresence.ToString(); // (string)reader["role"];
DataSet ds = new DataSet();
ds = DB.FindRoleMenus(varRole, varPageName);
if (ds.Tables[0].Rows.Count == 0)
{
string myResponse = "No permissions found for role " + varRole;
// Create the cookie object.
HttpCookie responsecookie = new HttpCookie("ResponseCookie");
// Set a value in it.
responsecookie["ResponseCookie"] = myResponse;
Response.Cookies.Add(responsecookie);
Response.Redirect("Default.aspx");
}
else
{
string varMenu = DB.FindRoleMenusCreate(varRole, varPageName);
if (varMenu == "false")
{
cmdAdd1.Visible = false;
}
else
{
cmdAdd1.Visible = true;
}
varMenu = DB.FindRoleMenusRead(varRole, varPageName);
if (varMenu == "false")
{
GridView1.Visible = false;
}
else
{
GridView1.Visible = true;
}
varMenu = DB.FindRoleMenusUpdate(varRole, varPageName);
if (varMenu == "false")
{
cmdEdit.Visible = false;
}
else
{
cmdEdit.Visible = true;
}
varMenu = DB.FindRoleMenusDelete(varRole, varPageName);
if (varMenu == "false")
{
cmdDelete.Visible = false;
}
else
{
cmdDelete.Visible = true;
}
}
}
}
catch (Exception err)
{
EventLog log = new EventLog();
log.Source = "Micar System";
log.WriteEntry(err.Message, EventLogEntryType.Error);
return;
}
finally
{
//con.Close();
}
}