public IEnumerable <Permision> GetAllPer(int id)
{
List <Permision> listPer = new List <Permision>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select p.id, p.name from itememp " +
"e inner join perrel r on r.emp_id = e.id inner join permision p on p.id = r.per_id where e.id = @id;";
cmd.Parameters.AddWithValue("@id", id);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Permision per = new Permision();
per.id = Convert.ToInt32(rdr["id"]);
per.name = rdr["name"].ToString();
// Employee employee = new Employee();
// employee.id = System.Convert.ToInt32(rdr["id"]);
// employee.name = rdr["name"].ToString();
// employee.surname = rdr["surname"].ToString();
// employee.patronymic = rdr["patronymic"].ToString();
listPer.Add(per);
}
con.Close();
}
return(listPer);
}
public IEnumerable <Permision> GetAllPermision()
{
List <Permision> listPer = new List <Permision>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select id,name from permision;";
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Permision per = new Permision();
per.id = Convert.ToInt32(rdr["id"]);
per.name = rdr["name"].ToString();
listPer.Add(per);
}
con.Close();
}
return(listPer);
}
