public int CreateRoleGroupMap(RoleGroupMap role) { int res = 0; using (var conn = new SqlConnection(ConnectionParameters.ConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(createRoleGroupMap, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter roleGroupId = new SqlParameter("roleGroupId", System.Data.SqlDbType.Int); roleGroupId.Value = role.RoleGroupId; cmd.Parameters.Add(roleGroupId); SqlParameter roleId = new SqlParameter("roleId", System.Data.SqlDbType.Int); roleId.Value = role.RoleId; cmd.Parameters.Add(roleId); SqlParameter pResult = new SqlParameter("status", System.Data.SqlDbType.Int); pResult.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(pResult); cmd.ExecuteNonQuery(); res = Convert.ToInt32(pResult.Value); } return(res); } }
private IList <RoleGroupMap> GetRoleGroupMap() { IList <RoleGroupMap> roleGroupMapList = null; using (var conn = new SqlConnection(ConnectionParameters.ConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(getRoleGroupMap, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; var cmdParamId = new SqlParameter("roleId", System.Data.SqlDbType.Int); SqlDataReader reader = cmd.ExecuteReader(); roleGroupMapList = new List <RoleGroupMap>(); while (reader.Read()) { RoleGroupMap newRoleGroupMap = new RoleGroupMap(); newRoleGroupMap.RoleGroupId = (int)reader["roleGroupId"]; newRoleGroupMap.RoleId = (int)reader["roleId"]; roleGroupMapList.Add(newRoleGroupMap); } } } return(roleGroupMapList); }
public int CreateRoleGroupMap(RoleGroupMap roleGroupMap) { var roleGroupAdaper = new RoleGroupMapAdapter(); return(roleGroupAdaper.CreateRoleGroupMap(roleGroupMap)); }