CREATE TABLE Work_Note_Notification(
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[TaskId] [bigint] NULL DEFAULT ((0)),
[NoteId] [bigint] NULL,
[UserId] [nvarchar](250) NULL,
[Isread] [bit] NOT NULL DEFAULT ((1)),
[CreatedOn] [datetime] NOT NULL DEFAULT (getdate()),
[IpAddress] [nvarchar](50) NULL
)
GO
CREATE Procedure usp_SaveReadNotificationforNoteByNoteId
@UserId nvarchar(250),
@NoteId bigint,
@TaskId bigint,
@IPAddress nvarchar(50)
As
Begin
Declare @Result bigint= 0;
IF EXISTS(Select Id From Work_Note_Notification Where UserId = @UserId AND NoteId = @NoteId AND IPAddress = @IPAddress)
--OR NOT EXISTS(Select Id From Work_Note_Notification Where UserId = @UserId AND IPAddress = @IPAddress)
Begin
--Update Work_Note_Notification Set Isread = 0 Where Id = @NoteId
select @NoteId As Result
End
ELSE
Begin
INSERT INTO Work_Note_Notification(TaskId,NoteId, UserId, IPAddress)
VALUES (@TaskId,@NoteId, @UserId, @IPAddress)
SELECT IDENT_CURRENT('Work_Note_Notification') as Result
End
End
Go
CREATE Procedure usp_wokrnotenotificationByPrimaryKey
@NoteId bigint,
@TaskId bigint,
@UserId nvarchar(250)
As
Declare @Result bit= 0;
Begin
IF EXISTS(Select * From Work_Note_Notification Where NoteId = @NoteId AND TaskId = @TaskId AND UserId = @UserId)
Begin
Set @Result = 1
Select @Result as 'Result'
End
ELSE
Begin
Select @Result as 'Result'
End
End
Go
---------------------------------
Add Modal In TaskModel.cs
-------------------
public static bool CheckifThisnoread(Int64 NoteId, Int64 TaskId, String UserId)
{
try
{
StoredProcedure sp = new StoredProcedure("usp_wokrnotenotificationByPrimaryKey");
// sp.Command.AddParameter("@Id", Id, DbType.Int64);
sp.Command.AddParameter("@NoteId", NoteId, DbType.Int64);
sp.Command.AddParameter("@TaskId", TaskId, DbType.Int64);
sp.Command.AddParameter("@UserId", UserId, DbType.String);
DataTable dt = sp.ExecuteDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
if (Convert.ToBoolean(dt.Rows[0]["Result"]))
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception("Error :: TaskDetails.CheckifThisnoread :: " + ex.Message.ToString());
}
}
[HttpPost, ValidateInput(false)]
public JsonResult SaveNoteSeenStatus()
{
try
{
string GUID = String.IsNullOrEmpty(Request.Params["TaskGUID"]) ? "" : Request.Params["TaskGUID"].ToString();
Int64 NoteId = String.IsNullOrEmpty(Request.Params["NoteId"]) ? 0 : Convert.ToInt64(Request.Params["NoteId"].ToString().Trim());
Int64 CompanyId = PMS.Models.Registration.GetCompanyIdByCurrentUsersId();
Int64 TaskId = PMS.Models.TaskModel.GetTaskIdByGuid(GUID, CompanyId);
string CurrentUserId = PMS.Models.CustomLogin.GetCurrentUsersUserId();
Int64 NoteReadId = PMS.Models.TaskDetails.SaveViewsUser(CurrentUserId, Convert.ToInt64(TaskId), Convert.ToInt64(NoteId));
if(NoteReadId > 0)
{
return Json(new { success = true, msg = "", NoteId= NoteId, TaskId= TaskId, User = CurrentUserId });
}else
{
return Json(new { success = false, msg = "" });
}
return Json(new { success = true, msg = "" });
}
catch (Exception ex)
{
return Json(new { success = false, msg = "Error: " + ex.Message.ToString() });
}
}
public static Int64 SaveViewsUser(string UserId, Int64 TaskId, Int64 NoteId)
{
try
{
StoredProcedure sp = new StoredProcedure("usp_SaveReadNotificationforNoteByNoteId");
sp.Command.Parameters.Add("@UserId", UserId, DbType.String);
sp.Command.Parameters.Add("@TaskId", TaskId, DbType.Int64);
sp.Command.Parameters.Add("@NoteId", NoteId, DbType.Int64);
sp.Command.Parameters.Add("@IPAddress", PMS.Models.CustomLogin.GetUserIPAddress(), DbType.String);
return sp.ExecuteScalar<Int64>();
}
catch (Exception ex)
{
return 0;
}
}
TaskDetails View page add in top section
--------------------------------
string[] userinrole = PMS.Models.CustomLogin.GetRolesForUser(CurrentUserId);
string roleName = "";
if (userinrole != null && userinrole.Length > 0)
{
roleName = userinrole[0].ToString().ToLower();
}
string FullName = "", TaskUserProfilePic = "";
PMS.Models.Registration.GetNameAndProfilePicByUserId(TM.CreatedBy, CompanyId, roleName, out FullName, out TaskUserProfilePic);
////In @if(Notes != null && Notes.Count > 0)
add anoth li
-----------------------
List<string> TeamMem = new List<string>();
<p class="scroll-to" id="sc_@note.Id" data-Id="@note.Id">@Html.Raw(note.WorkNotes.Replace(Environment.NewLine, "<br />"))</p>
<strong>View By:</strong>
@if (TeamMembersArray != null && TeamMembersArray.Length > 0)
{
foreach (string teams in TeamMembersArray)
{
string team = teams;
if (!String.IsNullOrEmpty(team))
{
string[] teamDetails = team.Split('#');
string teamMemberUserId = teamDetails[0].ToString();
string teamMemberName = teamDetails.Length > 1 ? teamDetails[1].ToString() : "";
string teamMemberEmail = teamDetails.Length > 2 ? teamDetails[2].ToString() : "";
string teamMemberProfilePic = teamDetails.Length > 3 ? teamDetails[3].ToString() : "";
bool isread = PMS.Models.TaskModel.CheckifThisnoread(note.Id, TM.Id, teamMemberUserId);
if (isread)
{
<img class="note_viewer img-responsive" src="@teamMemberProfilePic" alt="Sonu Sharma" title="@teamMemberName">
<span id="team_@teamMemberUserId@note.Id"><i class="far fa-check-double" style="color:green;"></i></span>
}
else if (!isread)
{
<img class="note_viewer img-responsive" src="@teamMemberProfilePic" alt="Sonu Sharma" title="@teamMemberName">
<span id="team_@teamMemberUserId@note.Id"><i class="fa fa-check" aria-hidden="true" style="color:red;"></i></span>
}
else
{
}
}
}
}
@if (!TeamMem.Contains(TM.CreatedBy.ToUpper()))
{
if (PMS.Models.TaskModel.CheckifThisnoread(note.Id, TM.Id, TM.CreatedBy))
{
<img class="note_viewer img-responsive" src="@TaskUserProfilePic" alt="@FullName" title="@FullName">
<span id="team_@TM.CreatedBy.ToUpper()@note.Id"><i class="far fa-check-double" style="color:green;"></i></span>
}
else
{
<img class="note_viewer img-responsive" src="@TaskUserProfilePic" alt="@FullName" title="@FullName">
<span id="team_@TM.CreatedBy.ToUpper()@note.Id"><i class="fa fa-check" aria-hidden="true" style="color:red;"></i></span>
}
}
--------------------
JS
--------------------
<script>
function insertReadStatusForUserAboutNote(noteId){
debugger;
var TaskId = '@TM.GUID';
var NoteId = noteId;
$.ajax({
type: 'POST',
url: '/admin/savenoteseenstatus',
data:{
TaskGUID : TaskId,
NoteId:NoteId
},
success: function (data) {
debugger;
if (data.success) {
var NID = data.NoteId;
var TID = data.TaskId;
var UserRead = data.User;
var teamId = '#team_'+UserRead +NID;
var j = $(teamId);
$(teamId).html('<i class="far fa-check-double" style="color:green;"></i>');
} else {
}
},
error: function (req, error) {
debugger;
console.log(req.responseText);
},
beforeSend: function (data) {
$('#updatenotebutton').attr('disabled', 'disabled');
$('#updatenotebutton').text('Please wait...');
}
});
}
function check_if_in_view() {
var window_height = $(window).height();
var window_top_position = $(window).scrollTop();
var window_bottom_position = (window_top_position + window_height);
var elem = $('.scroll-to');
$.each(elem, function(e) {
var $element = $(this);
var dataId = $(this).attr('data-id');
var currentelement = '#sc_'+dataId;
var element_height = $element.outerHeight();
var element_top_position = $element.offset().top;
var element_bottom_position = (element_top_position + element_height);
//check to see if this current container is within viewport
if ((element_bottom_position >= window_top_position) &&
(element_top_position <= window_bottom_position)) {
insertReadStatusForUserAboutNote(dataId);
} else {
$(currentelement).removeClass('in-view');
}
});
}
$(window).scroll(function() {
var hT = $('.scroll-to').offset().top,
hH = $('.scroll-to').outerHeight(),
wH = $(window).height(),
wS = $(this).scrollTop();
console.log((hT-wH) , wS);
if($('#discussionForumSection').hasClass('show')){
if (wS > (hT+hH-wH)){
var j = $('.scroll-to').attr('data-id');
console.log( $('.scroll-to').attr('data-id'));
var t = $(this);
// alert('you have scrolled to the h1!');
check_if_in_view();
}
}
});
</script>
<style>
img.note_viewer {
width: 20px;
height: 20px;
border-radius: 15px;
}
</style>
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[TaskId] [bigint] NULL DEFAULT ((0)),
[NoteId] [bigint] NULL,
[UserId] [nvarchar](250) NULL,
[Isread] [bit] NOT NULL DEFAULT ((1)),
[CreatedOn] [datetime] NOT NULL DEFAULT (getdate()),
[IpAddress] [nvarchar](50) NULL
)
GO
CREATE Procedure usp_SaveReadNotificationforNoteByNoteId
@UserId nvarchar(250),
@NoteId bigint,
@TaskId bigint,
@IPAddress nvarchar(50)
As
Begin
Declare @Result bigint= 0;
IF EXISTS(Select Id From Work_Note_Notification Where UserId = @UserId AND NoteId = @NoteId AND IPAddress = @IPAddress)
--OR NOT EXISTS(Select Id From Work_Note_Notification Where UserId = @UserId AND IPAddress = @IPAddress)
Begin
--Update Work_Note_Notification Set Isread = 0 Where Id = @NoteId
select @NoteId As Result
End
ELSE
Begin
INSERT INTO Work_Note_Notification(TaskId,NoteId, UserId, IPAddress)
VALUES (@TaskId,@NoteId, @UserId, @IPAddress)
SELECT IDENT_CURRENT('Work_Note_Notification') as Result
End
End
Go
CREATE Procedure usp_wokrnotenotificationByPrimaryKey
@NoteId bigint,
@TaskId bigint,
@UserId nvarchar(250)
As
Declare @Result bit= 0;
Begin
IF EXISTS(Select * From Work_Note_Notification Where NoteId = @NoteId AND TaskId = @TaskId AND UserId = @UserId)
Begin
Set @Result = 1
Select @Result as 'Result'
End
ELSE
Begin
Select @Result as 'Result'
End
End
Go
---------------------------------
Add Modal In TaskModel.cs
-------------------
public static bool CheckifThisnoread(Int64 NoteId, Int64 TaskId, String UserId)
{
try
{
StoredProcedure sp = new StoredProcedure("usp_wokrnotenotificationByPrimaryKey");
// sp.Command.AddParameter("@Id", Id, DbType.Int64);
sp.Command.AddParameter("@NoteId", NoteId, DbType.Int64);
sp.Command.AddParameter("@TaskId", TaskId, DbType.Int64);
sp.Command.AddParameter("@UserId", UserId, DbType.String);
DataTable dt = sp.ExecuteDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
if (Convert.ToBoolean(dt.Rows[0]["Result"]))
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception("Error :: TaskDetails.CheckifThisnoread :: " + ex.Message.ToString());
}
}
[HttpPost, ValidateInput(false)]
public JsonResult SaveNoteSeenStatus()
{
try
{
string GUID = String.IsNullOrEmpty(Request.Params["TaskGUID"]) ? "" : Request.Params["TaskGUID"].ToString();
Int64 NoteId = String.IsNullOrEmpty(Request.Params["NoteId"]) ? 0 : Convert.ToInt64(Request.Params["NoteId"].ToString().Trim());
Int64 CompanyId = PMS.Models.Registration.GetCompanyIdByCurrentUsersId();
Int64 TaskId = PMS.Models.TaskModel.GetTaskIdByGuid(GUID, CompanyId);
string CurrentUserId = PMS.Models.CustomLogin.GetCurrentUsersUserId();
Int64 NoteReadId = PMS.Models.TaskDetails.SaveViewsUser(CurrentUserId, Convert.ToInt64(TaskId), Convert.ToInt64(NoteId));
if(NoteReadId > 0)
{
return Json(new { success = true, msg = "", NoteId= NoteId, TaskId= TaskId, User = CurrentUserId });
}else
{
return Json(new { success = false, msg = "" });
}
return Json(new { success = true, msg = "" });
}
catch (Exception ex)
{
return Json(new { success = false, msg = "Error: " + ex.Message.ToString() });
}
}
public static Int64 SaveViewsUser(string UserId, Int64 TaskId, Int64 NoteId)
{
try
{
StoredProcedure sp = new StoredProcedure("usp_SaveReadNotificationforNoteByNoteId");
sp.Command.Parameters.Add("@UserId", UserId, DbType.String);
sp.Command.Parameters.Add("@TaskId", TaskId, DbType.Int64);
sp.Command.Parameters.Add("@NoteId", NoteId, DbType.Int64);
sp.Command.Parameters.Add("@IPAddress", PMS.Models.CustomLogin.GetUserIPAddress(), DbType.String);
return sp.ExecuteScalar<Int64>();
}
catch (Exception ex)
{
return 0;
}
}
TaskDetails View page add in top section
--------------------------------
string[] userinrole = PMS.Models.CustomLogin.GetRolesForUser(CurrentUserId);
string roleName = "";
if (userinrole != null && userinrole.Length > 0)
{
roleName = userinrole[0].ToString().ToLower();
}
string FullName = "", TaskUserProfilePic = "";
PMS.Models.Registration.GetNameAndProfilePicByUserId(TM.CreatedBy, CompanyId, roleName, out FullName, out TaskUserProfilePic);
////In @if(Notes != null && Notes.Count > 0)
add anoth li
-----------------------
List<string> TeamMem = new List<string>();
<p class="scroll-to" id="sc_@note.Id" data-Id="@note.Id">@Html.Raw(note.WorkNotes.Replace(Environment.NewLine, "<br />"))</p>
<strong>View By:</strong>
@if (TeamMembersArray != null && TeamMembersArray.Length > 0)
{
foreach (string teams in TeamMembersArray)
{
string team = teams;
if (!String.IsNullOrEmpty(team))
{
string[] teamDetails = team.Split('#');
string teamMemberUserId = teamDetails[0].ToString();
string teamMemberName = teamDetails.Length > 1 ? teamDetails[1].ToString() : "";
string teamMemberEmail = teamDetails.Length > 2 ? teamDetails[2].ToString() : "";
string teamMemberProfilePic = teamDetails.Length > 3 ? teamDetails[3].ToString() : "";
bool isread = PMS.Models.TaskModel.CheckifThisnoread(note.Id, TM.Id, teamMemberUserId);
if (isread)
{
<img class="note_viewer img-responsive" src="@teamMemberProfilePic" alt="Sonu Sharma" title="@teamMemberName">
<span id="team_@teamMemberUserId@note.Id"><i class="far fa-check-double" style="color:green;"></i></span>
}
else if (!isread)
{
<img class="note_viewer img-responsive" src="@teamMemberProfilePic" alt="Sonu Sharma" title="@teamMemberName">
<span id="team_@teamMemberUserId@note.Id"><i class="fa fa-check" aria-hidden="true" style="color:red;"></i></span>
}
else
{
}
}
}
}
@if (!TeamMem.Contains(TM.CreatedBy.ToUpper()))
{
if (PMS.Models.TaskModel.CheckifThisnoread(note.Id, TM.Id, TM.CreatedBy))
{
<img class="note_viewer img-responsive" src="@TaskUserProfilePic" alt="@FullName" title="@FullName">
<span id="team_@TM.CreatedBy.ToUpper()@note.Id"><i class="far fa-check-double" style="color:green;"></i></span>
}
else
{
<img class="note_viewer img-responsive" src="@TaskUserProfilePic" alt="@FullName" title="@FullName">
<span id="team_@TM.CreatedBy.ToUpper()@note.Id"><i class="fa fa-check" aria-hidden="true" style="color:red;"></i></span>
}
}
--------------------
JS
--------------------
<script>
function insertReadStatusForUserAboutNote(noteId){
debugger;
var TaskId = '@TM.GUID';
var NoteId = noteId;
$.ajax({
type: 'POST',
url: '/admin/savenoteseenstatus',
data:{
TaskGUID : TaskId,
NoteId:NoteId
},
success: function (data) {
debugger;
if (data.success) {
var NID = data.NoteId;
var TID = data.TaskId;
var UserRead = data.User;
var teamId = '#team_'+UserRead +NID;
var j = $(teamId);
$(teamId).html('<i class="far fa-check-double" style="color:green;"></i>');
} else {
}
},
error: function (req, error) {
debugger;
console.log(req.responseText);
},
beforeSend: function (data) {
$('#updatenotebutton').attr('disabled', 'disabled');
$('#updatenotebutton').text('Please wait...');
}
});
}
function check_if_in_view() {
var window_height = $(window).height();
var window_top_position = $(window).scrollTop();
var window_bottom_position = (window_top_position + window_height);
var elem = $('.scroll-to');
$.each(elem, function(e) {
var $element = $(this);
var dataId = $(this).attr('data-id');
var currentelement = '#sc_'+dataId;
var element_height = $element.outerHeight();
var element_top_position = $element.offset().top;
var element_bottom_position = (element_top_position + element_height);
//check to see if this current container is within viewport
if ((element_bottom_position >= window_top_position) &&
(element_top_position <= window_bottom_position)) {
insertReadStatusForUserAboutNote(dataId);
} else {
$(currentelement).removeClass('in-view');
}
});
}
$(window).scroll(function() {
var hT = $('.scroll-to').offset().top,
hH = $('.scroll-to').outerHeight(),
wH = $(window).height(),
wS = $(this).scrollTop();
console.log((hT-wH) , wS);
if($('#discussionForumSection').hasClass('show')){
if (wS > (hT+hH-wH)){
var j = $('.scroll-to').attr('data-id');
console.log( $('.scroll-to').attr('data-id'));
var t = $(this);
// alert('you have scrolled to the h1!');
check_if_in_view();
}
}
});
</script>
<style>
img.note_viewer {
width: 20px;
height: 20px;
border-radius: 15px;
}
</style>

0 Comments