public void UpdateMapRolePermission(MapRolePermission eMapRolePermission)
{
query = "UPDATE MapRolePermission SET RoleId = @RoleId, WHERE PermissionId= @PermissionId";
data.SetSqlStatement(query, CommandType.Text);
data.Parameter("@RoleId", SqlDbType.Int, eMapRolePermission.RoleId);
data.Parameter("@PermissionId", SqlDbType.Int, eMapRolePermission.PermissionId);
data.ExecuteScalar();
}
private DataTable ReturnPermissionsDetails(IEnumerable <MapRolePermission> eMapRolePermissions)
{
DataTable dtPermission = General.GetdtParams();
MapRolePermission eMapRolePermission = new MapRolePermission();
if (eMapRolePermissions != null)
{
for (int i = 0; i < eMapRolePermissions.Count(); i++)
{
eMapRolePermission = eMapRolePermissions.ElementAt(i);
DataRow dr = dtPermission.NewRow();
dr["Int1"] = eMapRolePermission.RoleId;
dr["Int2"] = eMapRolePermission.PermissionId;
dtPermission.Rows.Add(dr);
}
}
return(dtPermission);
}
public void LoadMapRolePermission(ref MapRolePermission eMapRolePermission)
{
query = "SELECT RoleId,PermissionId FROM MapRolePermission WHERE PermissionId=@PermissionId";
data.SetSqlStatement(query, CommandType.Text);
data.Parameter("@PermissionId", SqlDbType.Int, eMapRolePermission.PermissionId);
DataTable dt = data.FillData();
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
eMapRolePermission = new MapRolePermission()
{
RoleId = Int32.Parse(dr["RoleId"].ToString()),
PermissionId = Int32.Parse(dr["PermissionId"].ToString())
};
}
}
public static void LoadMapRolePermission(ref MapRolePermission eMapRolePermission)
{
MapRolePermissionBL MapRolePermissionBL = new MapRolePermissionBL();
MapRolePermissionBL.LoadMapRolePermission(ref eMapRolePermission);
}
public void LoadMapRolePermission(ref MapRolePermission eMapRolePermission)
{
MapRolePermissionDAL.LoadMapRolePermission(ref eMapRolePermission);
}