Database Changes

[Kalpana Muddapu]

Hello Ashish,

Please create the following stored procedures for notifications

i) GetAllUsersForGivenServiceRequestID

ii) GetNotificationTypeIDForGivenChannelIDAndTransactionTypeID

iii) GetNotificationMessageForGivenChannelIDAndTransactionTypeID

Kindly correct the following in the database

1) Typo Errors in stored procedures 

i) Update_NotificaitonStatus_UserNotification

ii) param in the same stored procedures @NotificationStaus (Note that this SP is used in code. That needs modification as well.)

2) Following stored procedures use "Name" column which is an invalid column

i) GetNotificationTypeID_ForGivenNotificationName 

ii) GetNotificationName_ForGivenNotificationTypeID 

Regards,

Kalpana

This e-mail transmission may contain confidential, proprietary and / or legally privileged information and is intended only for the individual or entity named in the e-mail address. Any disclosure, copying, distribution, or reliance upon the contents of this e-mail not authorized by the sender is strictly prohibited. If you have received this e-mail transmission in error, please immediately reply to the sender, so that proper delivery of the e-mail can be effected, and then please delete the message from your Inbox. Any content of this message and its attachments that does not relate to the official business of Saama Technologies Inc. or its subsidiaries must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect.

[Ashish Chauhan]

Hi Kalpana,

Thanks for checking. Below are my comments.

Please create the following stored procedures for notifications

i) GetAllUsersForGivenServiceRequestID - Do you mean UserID who created SR or All UserID who did transaction on particular SR?

ii) GetNotificationTypeIDForGivenChannelIDAndTransactionTypeID - Create 

[GetNotificationDetails_ForGivenChannelIDandTransactionTypeID]

iii) GetNotificationMessageForGivenChannelIDAndTransactionTypeID - Create 

[GetNotificationDetails_ForGivenChannelIDandTransactionTypeID]

Kindly correct the following in the database

1) Typo Errors in stored procedures 

i) Update_NotificaitonStatus_UserNotification - Update

ii) param in the same stored procedures @NotificationStaus (Note that this SP is used in code. That needs modification as well.) - I don't find wrong spelling for @Notificationstatus in SP.

2) Following stored procedures use "Name" column which is an invalid column

i) GetNotificationTypeID_ForGivenNotificationName - Remove from DB as we are no longer using name in NotificationType table.

ii) GetNotificationName_ForGivenNotificationTypeID 

 - Remove from DB as we are no longer using name in NotificationType table.

Let me know if you have any question.

Thanks

-Ashish

[Kalpana Muddapu]

Hello Ashish,

Please create Stored Procedures for 

i) GetTansactionTypeIdForGivenTransactionName
ii) GetAllUsersDetailsForGivenServiceRequestID - User details who are associated with a particular service request

Below mentioned tables needs data

1) TransactionType Table needs the below mentioned actions

i) Commented on
ii) Subscribed to
iii) Backlogged
iv) Canceled
v) Approved
vi) Target Release Changed

2) NotificationType Table needs data for Email and SMS channels

Modify the following

i) Add_UserNotificationDetails  stored procedure to return the UserNotificationId once the insertion is done. 

ii) Typo error for the passed in parameter (@NotificationStaus) in stored procedure 

Update_NotificaitonStatus_UserNotification 

Regards,

Kalpana

[Ashish Chauhan]

Hi Kalpana/Navneet,

Is these changes for Notification or Transaction? I think you are mixing up Notification with Transaction. When you get chance, could you give me call to discuss.

Thanks

-Ashish

[Kalpana Muddapu]

Hello Ashish,

Please create Stored Procedures for 

i) GetTansactionTypeIdForGivenTransactionName

Reason: For retrieving the message from NotificationType details using GetNotificationDetails_ForGivenChannelIDandTransactionTypeID stored procedure

we need to provide ChannelID and TransactionTypeID . We have the transactionName(action performed by the user). Providing the transactionName we need to retrieve the transactionID

ii) GetAllUsersDetailsForGivenServiceRequestID

Reason: Notification should be send to all the users who are associated with a particular service request. We need the user details who are associated with a particular service request. 

Kindly create these stored procedures. 

Regards,

Kalpana