Issue Tracker Starter Kit

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

boloyang — Fri, 31 Oct 2008 20:26:24 GMT

nvm ... i've also found a way on how to do this ... thanks for taking the time to not reply to any more my posting.

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

boloyang — Tue, 28 Oct 2008 15:42:04 GMT

Hey, I've tried it with this code but I'm getting a server error. This is the server error I'm getting.

Cannot insert the value NULL into column 'UserId', table 'IT.dbo.IssueTracker_IssueNotifications'; column does not allow nulls. INSERT fails.
The statement has been terminated.

it's from App_Code\Code\DAL\SQLDataAccessLayer.cs

Line 1878:				        sqlCmd.Connection = cn;
Line 1879:				        cn.Open();
Line 1880:				        result = sqlCmd.ExecuteScalar();
Line 1881:            }
Line 1882:

 any idea?

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

Testosteles — Fri, 05 Nov 2004 20:03:56 GMT

Oh, and check this thread:

http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=736681

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

Testosteles — Fri, 05 Nov 2004 18:45:43 GMT

I modified Issues\IssueDetails.aspx to look as follows:



		bool SaveIssue() 


		{


			Issue newIssue = new Issue(IssueId, ProjectId, txtTitle.Text, dropCats.SelectedValue, dropMilestone.SelectedValue, dropPriority.SelectedValue, dropStatus.SelectedValue, dropAssigned.SelectedValue, dropOwned.SelectedValue, User.Identity.Name);


			if (!newIssue.Save()) 


			{


				lblError.Text = "Could not save issue";


				return false;


			}





			IssueId = newIssue.Id;





			if (!CustomField.SaveCustomFieldValues(IssueId, ctlCustomFields.Values) ) 


			{


				lblError.Text = "Could not save issue custom fields";


				return false;


			}





			newIssue = Issue.GetIssueById( IssueId );





			IssueNotification notifyAssigned = new IssueNotification(IssueId, newIssue.AssignedDisplayName);


			IssueNotification notifyCreator = new IssueNotification(IssueId, newIssue.CreatorUsername);





			notifyAssigned.Save();


			IssueNotification.SendIssueNotifications( IssueId ); //Send a notification to the assigned user, but not to the creator.


			notifyAssigned.Save();





			return true;


		}

In my estimation, the correct behaviour is as follows:

- Bug is created, whomever it's assigned to will get an e-mail, and be added to the notification list (and possibly whomever it's owned by).

- The creator is added to the notification list, but they don't get an e-mail when the issue is created (they just created it, they don't need a notification e-mail).

- If a user no longer wants to be notified of changes, they simply take themselves off the notification list.

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

jwadsworth — Fri, 05 Nov 2004 14:20:42 GMT

I will look into creating a workspace on gotdotnet.

Also, is there a way to have this forum email me when someone posts?

Jeremy

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

jwezel — Fri, 05 Nov 2004 08:01:57 GMT

Hi Jeremy!

Would it be possible that I can use your enhanced final version? Would be great!

Or Maybe it might make sense to create a new project on gotdotnet? ;-)

Thank you very much!
Jochen

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

jwadsworth — Thu, 04 Nov 2004 20:56:22 GMT

I forgot to mention that the code I have written is in the beta version. I'm re-writing the functionality this week to be easier to use in the UI. Also, I'm not sure if I will be porting it over to the final release as I have made so many enhancements and modifications to the beta that I feel like maybe I wouldn't gain anything extra by trying to move all my changes to the final release version.

Jeremy

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

scotta — Wed, 03 Nov 2004 05:46:05 GMT

The code would be great.

The way I think it should work is as follows:
By default emails are sent to the creator/owner/assigned. You should then have a check box in the notifications area next to each email enabling you to switch off anyone who does not want emails.

Scott

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

jwadsworth — Tue, 02 Nov 2004 20:18:39 GMT

I implemented a feature like this in the beta where any changes to an issue or its comments fire off an email to the person the issue is assigned to, along with a link to the issue. The smtp address is stored in the web.config file. Also designed it so that users who want to receive email updates of issues are stored in a comma delimited string in the web.config. I did it this way as a quick effort to get it working and because some of the people I work with did not want email notifications.

If you're interested in the code, let me know.

Jeremy

Re: Automatic e-mail assignment delivery hasn't been implemented yet :(

jwezel — Tue, 02 Nov 2004 10:15:08 GMT

This issue is targetting the final version, not the BETA!!

Automatic e-mail assignment delivery hasn't been implemented yet :(

jwezel — Tue, 02 Nov 2004 10:09:47 GMT

Automatic e-mail delivery when a user get's created is not implemented.
Automatic e-mail assignment for issue creators hasn't been implemented.

My Summary: No purpose for the e-mail address field of the user profile has been found :(