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