Update issue with dropdown corresponding to label message.

Question

0.00/5 (No votes)

See more:

Hi ,

I have one label(ie updated status comes in this label) and two dropdown list one is developer and another is tester.

When I assign both it is working fine and if am assigning/selecting only developer it is working fine . But when i select only tester individually without selecting any developer then the other issues label status also gets changed automatically if some other issues have different status for the timing it gets changed to status=2(ie , assigned ) .

I have used procedure

SQL

ALTER procedure [dbo].[usp_assignedto]
(
@employeeid int,
@issuetrackerid int,
@testerid int
)
as
begin 
update issuesdetails set assignedto=@employeeid,status =2 , testerassign=@testerid where issuetrackerid=@issuetrackerid
end

This status =2 is because if am selecting and assigning the status label should get updated to assigned .

Hope you got the issue.

Thanks

Posted 17-Apr-13 19:46pm

Member 9954101

Updated 17-Apr-13 19:47pm

Vani Kulkarni

v2

Add a Solution

Comments

Mycroft Holmes 18-Apr-13 2:06am

Looks Ok to me have you checked that your client is sending the information correctly - both must the tester and the employee ids must be sent from the client otherwise you are going to have to test to see if one of them is zero.

Member 9954101 18-Apr-13 2:15am

If we select both developer and tester it works very fine but if suppose at present the status is 5 or anything else for one(1st) issue , and for the second it is status 3.In that case for the first 1st issue if I again select developer or tester then this particular issue should get the status=2 but it effects other issues also and everything gets status=2 automaticaly

Maciej Los 18-Apr-13 2:48am

Do not repost: Update query for stored procedure[^]!

Member 9954101 19-Apr-13 5:44am

ALTER procedure [dbo].[usp_assignedto]
(
@employeeid int,
@issuetrackerid int,
@testerid int
--@status int
)
as
begin
set nocount on

if (status !=1) or (status !=2)
begin
update issuesdetails set assignedto = @employeeid , testerassign=@testerid where issuetrackerid=@issuetrackerid
end
begin
update issuesdetails set assignedto=@employeeid,status =2 , testerassign=@testerid where issuetrackerid=@issuetrackerid
end

end

First of all the "if (status !=1) or (status !=2)" this condition is not working , if i pass the parameter @status It works but I am not passing any parametr from front end so I cant pass this parameter . So Please give substitute for this also .

I tried using this , the previous issue of updating the status label for all the issue is resolved but now I cant update the status , On submit click no change occur.

Please give me some solution asap

2 solutions

Solution 1

Answer has been provided here: Update query for stored procedure[^]

Posted 17-Apr-13 20:50pm

Maciej Los

Comments

Member 9954101 18-Apr-13 3:29am

this is another issue , that is resolved .

Maciej Los 18-Apr-13 3:33am

If issue was resolved, then mark it as "solved" (green button) - formally.

Member 9954101 18-Apr-13 3:41am

If you are talking for accept solution , M already done with dat.

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)

Member 9954101 · Accepted Answer · 2013-04-18T23:37:00

ALTER procedure [dbo].[usp_assignedto]
(
@employeeid int,
@issuetrackerid int,
@testerid int
--@status int
)
as
begin
set nocount on

if (status !=1) or (status !=2)
begin
update issuesdetails set assignedto = @employeeid , testerassign=@testerid where issuetrackerid=@issuetrackerid
end
begin
update issuesdetails set assignedto=@employeeid,status =2 , testerassign=@testerid where issuetrackerid=@issuetrackerid
end

end

First of all the "if (status !=1) or (status !=2)" this condition is not working , if i pass the parameter @status It works but I am not passing any parametr from front end so I cant pass this parameter . So Please give substitute for this also .

I tried using this , the previous issue of updating the status label for all the issue is resolved but now I cant update the status , On submit click no change occur.

Please give me some solution asap