Guid Problem (Role Management)

Question

4.00/5 (1 vote)

See more:

, +

i have aspnet_Roles

ROLID                           ROLNAME

   9acf74a8-d48b-4541-815e-695117a7a093    Admin
   88299f05-b2aa-41c2-81f5-69959777677c    AltinUye
   5712cd36-406c-490e-9da0-235fcec32186    NormalUye

i have my aspnet_UsersInRoles

 USERID                                 ROLEID
fbd74e8b-f5e6-44a9-9fd4-1930beafb0e3    9acf74a8-d48b-4541-815e-695117a7a093
e64aa732-8631-46e6-90bb-0d2b882a21e3    88299f05-b2aa-41c2-81f5-69959777677c
241e204e-530e-4917-97b6-4a14f7057e1f    88299f05-b2aa-41c2-81f5-69959777677c
ca5999b8-f076-482d-9be4-709efd0ce550    88299f05-b2aa-41c2-81f5-69959777677c
0e6789fe-b6fd-4ac5-8da9-f8eb661ae31f    88299f05-b2aa-41c2-81f5-69959777677c

My stored procedure is

ALTER proc [dbo].[RolDuzenle]
(
@UserId uniqueidentifier,
@RolId   uniqueidentifier,
@Result int output
)
as
Declare @RecordControl  int 
Set @RecordControl=(select count(*) from dbo.aspnet_UsersInRoles where UserId=@UserId and RoleId=@RolId) 
update dbo.aspnet_UsersInRoles set RoleId=@RolId   where UserId=@UserId 
if(@RecordControl=0) 
begin 
set @Result=0
end
else
begin
set @Result=1
end
return @Result

Baglanti baglan = new Baglanti();

          SqlParameter[] paramdizi2 = new SqlParameter[3]
          {
              new SqlParameter(";@UserId",SqlDbType.UniqueIdentifier),
              new SqlParameter("@RolId",SqlDbType.UniqueIdentifier),
              new SqlParameter("@Result",SqlDbType.Int)

          };

          paramdizi2[0].Value = new Guid(TxtUserId.Text);
          paramdizi2[1].Value = new Guid(TxtRolId.Text);
          paramdizi2[2].Direction = ParameterDirection.Output;
          baglan.ExecuteNonQuery("RolDuzenle", CommandType.StoredProcedure, paramdizi2);
          if (paramdizi2[2].Value.ToString() == "0")
          {
              LabelDurum.Text = "Rol Updated";
          }
          else
          {
              LabelDurum.Text = "The role is already same";
          }

ı managed this part.ı did it but;

i want to get the result below

C#

Baglanti baglan = new Baglanti();

          SqlParameter[] paramdizi2 = new SqlParameter[3]
          {
              new SqlParameter("@UserId";,SqlDbType.UniqueIdentifier),
              new SqlParameter("@RolId";,SqlDbType.UniqueIdentifier),
              new SqlParameter("@Result",SqlDbType.Int)

          };

          paramdizi2[0].Value = new Guid(TxtUserId.Text);
          paramdizi2[1].Value = new Guid(TxtRolId.Text);
          paramdizi2[2].Direction = ParameterDirection.Output;
          baglan.ExecuteNonQuery("RolDuzenle";, CommandType.StoredProcedure, paramdizi2);
          if (paramdizi2[2].Value.ToString() == "0")
          {
              LabelDurum.Text = "Role updated";
          }
          else
          {
              LabelDurum.Text = "The table doesnt include this RoleId";
          }

if ı used RolDuzenle stored procedure but, ı dont arrive this result

        //if (paramdizi2[2].Value.ToString() == "0")
         {
             LabelDurum.Text = "Role updated";
         }
         else
         {
             LabelDurum.Text = "The aspnet_Roles table doesnt include this RoleId"
         }
//

İf ı enter false Role Id my program is failed.

SQL

The UPDATE statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Us__RoleI__52593CB8". The conflict occurred in database "TskYurt", table"dbo.aspnet_Roles, column 'RoleId';.
The statement has been terminated.

IS IT POSSIBLE?

i want to this

if (paramdizi2[2].Value.ToString() == "0")
         {
             LabelDurum.Text = "Role updated";
         }
         else
         {
             LabelDurum.Text ="The aspnet_Roles table doesnt include this RoleId";
         }

Posted 14-Jun-11 11:50am

Ccsnow

Updated 14-Jun-11 15:07pm

walterhevedeich

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RakeshMeena · Answer 1 · 2011-06-14T19:09:00

Before updating the roleid you need to check if that role exists, if it doesn't then return 0 immediately, no need of update statement in that case. As you can see from the error message, it gives a "Foreign Key Constraint" error which is correct behavior.

Here is the modified SP. Just moved the update statement to the else part (when there exist a record with that role):

ALTER proc [dbo].[RolDuzenle]
(
@UserId uniqueidentifier,
@RolId   uniqueidentifier,
@Result int output
)
as
Declare @RecordControl  int 
Set @RecordControl=(select count(*) from dbo.aspnet_UsersInRoles where UserId=@UserId and RoleId=@RolId)
begin 
set @Result=0
end
else
begin 
update dbo.aspnet_UsersInRoles set RoleId=@RolId   where UserId=@UserId 
if(@RecordControl=0) 
set @Result=1
end
return @Result

I hope that helps.