/// <summary>
/// Update note for NoteId
/// </summary>
/// <param name="note">The note.</param>
/// <returns></returns>
public Response <NoteDetailsModel> UpdateNoteDetails(NoteDetailsModel note)
{
var spParameters = new List <SqlParameter> {
new SqlParameter("NoteID", note.NoteID),
new SqlParameter("Notes", note.Notes),
new SqlParameter("ModifiedOn", note.ModifiedOn ?? DateTime.Now)
};
var repository = _unitOfWork.GetRepository <NoteDetailsModel>(SchemaName.Clinical);
return(repository.ExecuteNQStoredProc("usp_UpdateNoteDetails", spParameters));
}
/// <summary>
/// To the model.
/// </summary>
/// <param name="model">The model.</param>
/// <returns></returns>
public static NoteDetailsModel ToModel(this NoteDetailsViewModel model)
{
if (model == null)
{
return(null);
}
var entity = new NoteDetailsModel
{
NoteID = model.NoteID,
Notes = model.Notes,
ModifiedOn = model.ModifiedOn
};
return(entity);
}
public IHttpActionResult UpdateNoteDetails(NoteDetailsModel note)
{
if (ModelState.IsValid)
{
return(new HttpResult <Response <NoteDetailsModel> >(_noteRuleEngine.UpdateNoteDetails(note), Request));
}
else
{
var errorMessage = ModelState.ParseError();
var validationResponse = new Response <NoteModel>()
{
DataItems = new List <NoteModel>(), ResultCode = -1, ResultMessage = errorMessage
};
return(new HttpResult <Response <NoteModel> >(validationResponse, Request));
}
}
/// <summary>
/// To the ViewModel
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public static NoteDetailsViewModel ToViewModel(this NoteDetailsModel entity)
{
if (entity == null)
{
return(null);
}
var model = new NoteDetailsViewModel
{
NoteID = entity.NoteID,
Notes = entity.Notes,
ModifiedOn = entity.ModifiedOn
};
return(model);
}
public IActionResult Details(int id)
{
var note = _notesServices.GetNoteById(id);
if (note != null)
{
var model = new NoteDetailsModel
{
Title = note.Title,
Description = note.Description,
Content = note.Content
};
return(View(model));
}
return(NotFound());
}
public void UpdateNoteDetails_Failure()
{
//Arrange
var url = baseRoute + "UpdateNoteDetails";
var param = new NameValueCollection();
var noteModel = new NoteDetailsModel
{
NoteID = -1,
Notes = "Note Failure Update",
ForceRollback = true
};
//Act
var response = _communicationManager.Put <NoteDetailsModel, Response <NoteDetailsModel> >(noteModel, url);
// Assert
Assert.IsNotNull(response, "Response can not be null");
Assert.IsTrue(response.RowAffected == 2, "Note details updated for invalid data."); //Update is logged operation, default rows affected is 2
}
public void UpdateNoteDetails_Failure()
{
//Act
Mock_Note();
var updateNote = new NoteDetailsModel
{
NoteID = -1,
Notes = "Failure Note Update",
ForceRollback = true
};
var updateNoteResult = noteController.UpdateNoteDetails(updateNote);
var response = updateNoteResult as HttpResult <Response <NoteDetailsModel> >;
//Assert
Assert.IsNotNull(response, "Response can't be null");
Assert.IsNotNull(response.Value, "Response value can't be null");
Assert.IsNotNull(response.Value.DataItems, "DataItems can't be null");
Assert.IsTrue(response.Value.DataItems.Count > 0, "Response must return data items");
Assert.IsTrue(response.Value.DataItems[0].Notes != "Failure Note Update", "Note updated for invalid data.");
}
public void UpdateNoteDetails_Success()
{
//Act
Mock_Note();
var updateNote = new NoteDetailsModel
{
NoteID = 1,
Notes = "Updated Note details",
ForceRollback = true
};
var updateNoteResult = noteController.UpdateNoteDetails(updateNote);
var response = updateNoteResult as HttpResult <Response <NoteDetailsModel> >;
//Assert
Assert.IsNotNull(response, "Response can't be null");
Assert.IsNotNull(response.Value, "Response value can't be null");
Assert.IsNotNull(response.Value.DataItems, "DataItems can't be null");
Assert.IsTrue(response.Value.DataItems.Count > 0, "Response must return data items");
Assert.IsTrue(response.Value.DataItems[0].Notes == "Updated Note details", "Note could not be updated.");
}
public void UpdateNoteDetails_Failure()
{
//Arrange
var noteDetails = new List <NoteDetailsModel> {
new NoteDetailsModel {
NoteID = 1, Notes = "Updated Note details", ForceRollback = true
}
};
var noteDetailResponse = new Response <NoteDetailsModel>()
{
DataItems = noteDetails
};
mock.Setup(r => r.UpdateNoteDetails(It.IsAny <NoteDetailsModel>()))
.Callback((NoteDetailsModel noteModel) => { if (noteModel.NoteID > 0)
{
noteDetails.Remove(noteDetails.Find(note => note.NoteID == noteModel.NoteID)); noteDetails.Add(noteModel);
}
})
.Returns(noteDetailResponse);
var updateNote = new NoteDetailsModel
{
NoteID = -1,
Notes = "Updated Note details Failure",
ForceRollback = true
};
//Act
var updateNoteResult = noteController.UpdateNoteDetails(updateNote);
var response = updateNoteResult as HttpResult <Response <NoteDetailsModel> >;
//Assert
Assert.IsNotNull(response, "Response can't be null");
Assert.IsNotNull(response.Value, "Response value can't be null");
Assert.IsNotNull(response.Value.DataItems, "DataItems can't be null");
Assert.IsTrue(response.Value.DataItems.Count > 0, "Response must return data items");
Assert.IsTrue(response.Value.DataItems[0].Notes == "Updated Note details", "Note updated for invalid data.");
}
public ActionResult NoteDetail(int id)
{
ViewBag.Class = "white-nav";
if (TempData["Requested"] != null)
{
ViewBag.Requested = "Requested";
Session["Req"] = "Requested";
}
//Auth User as Buyer
var buyer = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault();
//Note
var NoteDetail = db.SellerNotes.Where(x => x.ID == id).FirstOrDefault();
//Note File for Download
var NoteFileDetail = db.SellerNotesAttachements.Where(x => x.NoteID == NoteDetail.ID).FirstOrDefault();
//Rating, Spam, Totol Review
var rating = db.SellerNotesReviews.Where(x => x.NoteID == id && x.IsActive == true).Average(x => (int?)x.Ratings) ?? 0;
var totalreview = db.SellerNotesReviews.Where(x => x.NoteID == id && x.IsActive == true).Count();
var spam = db.SellerNotesReportedIssues.Where(x => x.NoteID == id).Count();
//Note Review Query
IEnumerable <ReviewsModel> reviews = from review in db.SellerNotesReviews
join users in db.Users on review.ReviewedByID equals users.ID
join userprofile in db.UserProfiles on review.ReviewedByID equals userprofile.UserID
where review.NoteID == id && review.IsActive == true orderby review.Ratings descending, review.CreatedDate descending
select new ReviewsModel {
SellerNotesReviews = review, Users = users, UserProfiles = userprofile
};
//If Note is not UnAvailable
if (NoteDetail == null)
{
return(Content("This Note Is UnAvailable..."));
}
NoteDetailsModel note = new NoteDetailsModel();
//If Buyer already Bought this Note the disable Download Button
if (buyer != null)
{
//if User is Admin then Review Delete Button Show
if (buyer.RoleID != 1)
{
note.DisableBtn = false;
note.isAdmin = true;
}
else
{
var disable = db.Downloads.Where(x => x.Downloader == buyer.ID && x.Seller == NoteDetail.SellerID && x.NoteID == NoteDetail.ID).FirstOrDefault();
if (disable != null)
{
if (disable.IsPaid)
{
note.DisableBtn = true;
}
}
}
}
note.sellerNote = NoteDetail;
note.sellerNotesAttachement = NoteFileDetail;
note.Spam = spam != 0 ? spam : 0;
note.AvgRating = (int)rating;
note.TotalReview = totalreview;
note.notesreview = reviews;
return(View(note));
}
/// <summary>
/// Update note for NoteId
/// </summary>
/// <param name="note">The note.</param>
/// <returns></returns>
public Response <NoteDetailsModel> UpdateNoteDetails(NoteDetailsModel note)
{
return(_noteService.UpdateNoteDetails(note));
}
/// <summary>
/// Update note for NoteId
/// </summary>
/// <param name="note">The note.</param>
/// <returns></returns>
public Response <NoteDetailsModel> UpdateNoteDetails(NoteDetailsModel note)
{
const string apiUrl = BaseRoute + "UpdateNoteDetails";
return(_communicationManager.Put <NoteDetailsModel, Response <NoteDetailsModel> >(note, apiUrl));
}
public IHttpActionResult UpdateNoteDetails(NoteDetailsModel note)
{
return(new HttpResult <Response <NoteDetailsModel> >(_noteDataProvider.UpdateNoteDetails(note), Request));
}
