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); }