public JsonResult Add(int clientId, string text)
{
try
{
var userId = User.Identity.GetUserId();
var client = db.Clients.Find(clientId);
var note = new ClientNote()
{
Date = DateTime.Now,
Text = text,
ClientId = clientId,
UserId = userId
};
db.ClientNotes.Add(note);
db.SaveChanges();
return(Json(new
{
Result = true,
Data = new
{
Result = true,
NoteId = note.Id,
ClientId = note.ClientId
}
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = false, Message = ex.Message }));
}
}
// Add your own data access methods here. If you wish to
// expose your public method to a WCF service, marked them with
// the attribute [NCPublish], and another T4 template will generate your service contract
/// <summary>
/// This method adds new client note in database
/// </summary>
/// <param name="clientID">clientID</param>
/// <param name="introducingBrokerUserID">introducingBrokerUserID</param>
/// <param name="subject">subject</param>
/// <param name="note">note</param>
/// <returns></returns>
public bool AddNewClientNote(int clientID, int introducingBrokerUserID, string subject, string note)
{
try
{
using (var unitOfWork = new EFUnitOfWork())
{
var clientNoteRepo =
new ClientNoteRepository(new EFRepository <ClientNote>(), unitOfWork);
ClientNote clientNote = new ClientNote();
clientNote.Subject = subject != String.Empty ? subject : "[No Subject]";
clientNote.Note = note.Replace("\n", "<br>");
clientNote.FK_ClientID = clientID;
clientNote.FK_IntroducingBrokerUserID = introducingBrokerUserID;
clientNote.Timestamp = DateTime.Now;
clientNoteRepo.Add(clientNote);
clientNoteRepo.Save();
return(true);
}
}
catch (Exception ex)
{
CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
return(false);
}
}
public IList <ClientNote> LoadClientNotesFor(int clientId)
{
IList <ClientNote> notes = new List <ClientNote>();
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"NotesClient_LoadForAClient",
CreateNotesClientPerm_LoadForAClientParameters
(clientId)))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
string parsedNotes = CustomerNotesParser.Parse(cleverReader.ToString("notes"));
ClientNote note = new ClientNote(
cleverReader.FromBigInteger("NotesID"),
cleverReader.ToDate("Created"),
ActivityType.Parse(cleverReader.ToInteger("ActivityTypeId")),
NoteType.Parse(cleverReader.ToInteger("NoteTypeId")),
parsedNotes,
cleverReader.ToInteger("CreatedBy"),
cleverReader.ToString("EmployeeName"),
cleverReader.FromBigInteger("ClientID"),
cleverReader.ToInteger("ModifiedBy"),
cleverReader.ToString("ModifiedByEmployeeName"),
cleverReader.ToDate("Modified"));
notes.Add(note);
}
}
}
return(notes);
}
public ActionResult AddNote()
{
int id = Convert.ToInt16(Request.Form["ClientId"]);
string Content = Request.Form["Content"];
Client client = db.Clients.Find(id);
if (client == null)
{
return(HttpNotFound());
}
ClientNote cn = new ClientNote();
cn.ClientId = id;
cn.Note = Content;
cn.DateCreated = DateTime.UtcNow.AddHours(8);
cn.Done = 0;
cn.CreatedByUserId = User.Identity.GetUserId();
db.ClientNotes.Add(cn);
db.SaveChanges();
return(RedirectToAction("Manage", "Clients", new { @id = id }));
}
public ActionResult DeleteConfirmed(int id)
{
ClientNote clientNote = db.ClientNotes.Find(id);
db.ClientNotes.Remove(clientNote);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void UpdateClientNote(long noteId, ActivityType activityType, NoteType noteType, string newComment, int modifiedBy)
{
ArgumentChecker.ThrowIfNullOrEmpty(newComment, "comment");
ClientNote clientNote = new ClientNote(noteId, activityType, noteType, newComment, modifiedBy);
repository.UpdateClientNote(clientNote);
view.DisplayFeedback();
}
protected void SaveButton_Click(object sender, EventArgs e)
{
int employeeId = CurrentPrincipal.CffUser.EmployeeId;
string comment = string.IsNullOrEmpty(CommentTextBox.Text) ? "" : CommentTextBox.Text;
if (!string.IsNullOrEmpty(comment))
{
//comment = comment.Replace("\n", ";"); //dbb
comment = comment.Replace("\n", " ");
}
ICffClient xClient = (SessionWrapper.Instance.Get != null) ? SessionWrapper.Instance.Get.ClientFromQueryString :
(!string.IsNullOrWhiteSpace(QueryString.ViewIDValue)) ? SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).ClientFromQueryString : null;
bool bIsAllClientsSelected = (SessionWrapper.Instance.Get != null) ? SessionWrapper.Instance.Get.IsAllClientsSelected :
(!string.IsNullOrEmpty(QueryString.ViewIDValue)) ? SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).IsAllClientsSelected : false;
bool bIsClientSelected = (SessionWrapper.Instance.Get != null) ? SessionWrapper.Instance.Get.IsClientSelected :
(!string.IsNullOrEmpty(QueryString.ViewIDValue)) ? SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).IsClientSelected : false;
bool bIsCustomerSelected = (SessionWrapper.Instance.Get != null) ? SessionWrapper.Instance.Get.IsCustomerSelected :
(!string.IsNullOrEmpty(QueryString.ViewIDValue)) ? SessionWrapper.Instance.GetSession(QueryString.ViewIDValue).IsCustomerSelected : false;
if (bIsAllClientsSelected)
{
int clientId = SessionWrapper.Instance.Get.ClientFromQueryString.Id;
var permanentNote = new PermanentClientNote(comment, clientId, employeeId);
presenter.SaveClientPermanentNote(permanentNote);
}
else if (bIsCustomerSelected)
{
//int customerId = SessionWrapper.Instance.Get.Customer.Id;
int customerId = SessionWrapper.Instance.Get.CustomerFromQueryString.Id;
string nextCallDueText = EncodedText(NextCallDueTextBox.Text);
ActivityType activityType = ActivityType.Parse(int.Parse(ActivityTypeDropDownList.SelectedValue));
NoteType noteType = NoteType.Parse(int.Parse(NoteTypeDropDownList.SelectedValue));
SaveNoteForCustomer(comment, employeeId, customerId, nextCallDueText, activityType, noteType);
}
else if (bIsClientSelected)
{
if (PermanentNoteCheckBox.Checked)
{
int clientId = xClient.Id;
var permanentNote = new PermanentClientNote(comment, clientId, employeeId);
presenter.SaveClientPermanentNote(permanentNote);
}
else
{
int clientId = xClient.Id;
ActivityType activityType = ActivityType.Parse(int.Parse(ActivityTypeDropDownList.SelectedValue));
NoteType noteType = NoteType.Parse(int.Parse(NoteTypeDropDownList.SelectedValue));
var clientNote = new ClientNote(activityType, noteType, comment, clientId, employeeId);
presenter.SaveClientNote(clientNote);
}
}
}
public HttpResponseMessage EditClientNote(HttpRequestMessage request, [FromBody] ClientNote clientNote)
{
return(Execute(request, () =>
{
_clientNoteService.Edit(clientNote);
return request.CreateResponse(HttpStatusCode.OK);
}));
}
private void PopulateClientNotesControls(ClientNote selectedClientNote)
{
PopulateNoteTypes(NoteType.KnownTypesForNewNotes);
PopulateActivityTypes(ActivityType.KnownTypesForNewNotes);
CommentEditTextBox.Text = EncodedText(CustomerNotesParser.RemoveBr(selectedClientNote.Comment));
ActivityTypeDropDownList.SelectedValue = selectedClientNote.ActivityType.Id.ToString();
NoteTypeDropDownList.SelectedValue = selectedClientNote.NoteType.Id.ToString();
}
public void DisplayRetentionNotes(IRetentionNote retentionNote)
{
retentionNotes = new List <ClientNote>();
RetentionNotesLiteral.Text = retentionNote.GetNote();
ClientNote retnClientNote = new ClientNote(ActivityType.AllNotes, NoteType.AllNotes,
retentionNote.GetNote(), 0, 0);
retentionNotes.Add(retnClientNote);
}
public void Show(ClientNote selectedClientNote)
{
PopulateClientNotesControls(selectedClientNote);
CommentEditTextBox.Text = EncodedText(CustomerNotesParser.RemoveBr(selectedClientNote.Comment));
CommentEditTextBox.Focus();
ViewState.Add(SelectedNote, selectedClientNote);
CustomerNoteDescriptors.Visible = true;
Visible = true;
BlockScreen();
}
public void InsertClientNote(ClientNote clientNote)
{
ArgumentChecker.ThrowIfNull(clientNote, "clientNote");
using (SqlConnection connection = CreateConnection())
{
SqlHelper.ExecuteNonQuery(connection,
CommandType.StoredProcedure,
"NoteClient_Save", CreateSaveClientNoteParameters(clientNote));
}
}
public ActionResult Edit([Bind(Include = "Id,Text,UserId,ClientId,Active")] ClientNote clientNote)
{
if (ModelState.IsValid)
{
db.Entry(clientNote).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "FullName", clientNote.UserId);
ViewBag.ClientId = new SelectList(db.Clients, "Id", "FullName", clientNote.ClientId);
return(View(clientNote));
}
private void UpdateClientNote(object orginalNote, int modifiedBy, string newComment)
{
newComment = newComment.Replace("&", "&");
NoteType noteType = NoteType.Parse(int.Parse(NoteTypeDropDownList.SelectedValue));
ActivityType activityType = ActivityType.Parse(int.Parse(ActivityTypeDropDownList.SelectedValue));
ClientNote originalCustomerNote = orginalNote as ClientNote;
if (originalCustomerNote != null)
{
presenter.UpdateClientNote(originalCustomerNote.NoteId, activityType, noteType, newComment, modifiedBy);
}
}
public ActionResult Create([Bind(Include = "Id,Date,Text,UserId,ClientId,Active")] ClientNote clientNote)
{
if (ModelState.IsValid)
{
db.ClientNotes.Add(clientNote);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", clientNote.UserId);
ViewBag.ClientId = new SelectList(db.Clients, "Id", "FirstName", clientNote.ClientId);
return(View(clientNote));
}
// GET: ClientNotes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClientNote clientNote = db.ClientNotes.Find(id);
if (clientNote == null)
{
return(HttpNotFound());
}
return(View(clientNote));
}
// GET: ClientNotes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClientNote clientNote = db.ClientNotes.Find(id);
if (clientNote == null)
{
return(HttpNotFound());
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "FullName", clientNote.UserId);
ViewBag.ClientId = new SelectList(db.Clients, "Id", "FullName", clientNote.ClientId);
return(View(clientNote));
}
public ActionResult RemoveNote(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClientNote cn = db.ClientNotes.Find(id);
if (cn == null)
{
return(HttpNotFound());
}
db.ClientNotes.Remove(cn);
db.SaveChanges();
return(RedirectToAction("Manage", "Clients", new { @id = cn.ClientId }));
}
private static SqlParameter[] CreateUpdateClientNoteParameters(ClientNote clientNote)
{
SqlParameter noteIdParameter = new SqlParameter("@NoteId", SqlDbType.Int);
SqlParameter activityTypeIdParameter = new SqlParameter("@ActivityTypeId", SqlDbType.Int);
SqlParameter noteTypeIdParameter = new SqlParameter("@NoteTypeId", SqlDbType.Int);
SqlParameter modifiedByParameter = new SqlParameter("@ModifiedBy", SqlDbType.Int);
SqlParameter noteParamter = new SqlParameter("@Comment", SqlDbType.Text);
noteIdParameter.Value = clientNote.NoteId;
modifiedByParameter.Value = clientNote.ModifiedBy;
noteParamter.Value = clientNote.Comment;
activityTypeIdParameter.Value = clientNote.ActivityType.Id;
noteTypeIdParameter.Value = clientNote.NoteType.Id;
return(new[]
{
noteIdParameter, activityTypeIdParameter, noteTypeIdParameter, modifiedByParameter,
noteParamter
});
}
private static SqlParameter[] CreateSaveClientNoteParameters(ClientNote note)
{
SqlParameter customerIdParameter = new SqlParameter("@ClientID", SqlDbType.Int);
SqlParameter createdByParameter = new SqlParameter("@CreatedBy", SqlDbType.Int);
SqlParameter noteParamter = new SqlParameter("@Note", SqlDbType.Text);
SqlParameter activityTypeIdParameter = new SqlParameter("@ActivityTypeId", SqlDbType.Int);
SqlParameter noteTypeIdParameter = new SqlParameter("@NoteTypeId", SqlDbType.Int);
customerIdParameter.Value = note.ClientId;
createdByParameter.Value = note.AuthorId;
noteParamter.Value = note.Comment;
activityTypeIdParameter.Value = note.ActivityType.Id;
noteTypeIdParameter.Value = note.NoteType.Id;
return(new[]
{
customerIdParameter, createdByParameter, noteParamter, activityTypeIdParameter,
noteTypeIdParameter
});
}
public List <ClientNote> GetClientNotesByClientId(int clientId)
{
List <ClientNote> clientNoteList = new List <ClientNote>();
List <int> foundIds = new List <int>();
bool done = false;
while (!done)
{
ClientNote getClientNote = _repository.Get(filter => filter.ClientId == clientId, l => !foundIds.Contains(l.Id)).FirstOrDefault();
if (getClientNote != null)
{
clientNoteList.Add(getClientNote);
foundIds.Add(getClientNote.Id);
}
else
{
done = true;
}
}
return(clientNoteList);
}
public bool UpdateClientNotes(ClientNote clientNote, ref string errMsg)
{
try
{
repository.UpdateClientNote(clientNote);
return(true);
}
catch (System.Exception exc)
{
if (exc.Message.ToLower().IndexOf("foreign key constraint", 0) > 0 &&
(exc.Message.ToLower().IndexOf("activitytype", 0) > 0) && clientNote.ActivityType.Id >= 0)
{
errMsg = "Unable to modify notes for this activity type.";
}
else
{
errMsg = exc.Message;
}
return(false);
}
}
public void Add(ClientNote entity)
{
Repository.Add(entity);
}
public IList <ClientNote> LoadClientNotesOnRange(int clientId, DateRange dateRange)
{
ArgumentChecker.ThrowIfNull(dateRange, "fromDate");
SqlParameter[] sqlParameters = new[]
{
CreateClientIdParameter(clientId),
CreateFromDateParameter(dateRange.StartDate),
CreateToDateParameters(dateRange.EndDate)
};
IList <ClientNote> notes = new List <ClientNote>();
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"NotesClient_LoadForAClientOnRange",
sqlParameters))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
string parsedNotes = CustomerNotesParser.Parse(cleverReader.ToString("notes"));
ClientNote note = null;
if (clientId > 0)
{
note = new ClientNote(
cleverReader.FromBigInteger("NotesID"),
cleverReader.ToDate("Created"),
ActivityType.Parse(cleverReader.ToInteger("ActivityTypeId")),
NoteType.Parse(cleverReader.ToInteger("NoteTypeId")),
parsedNotes,
cleverReader.ToInteger("CreatedBy"),
cleverReader.ToString("EmployeeName"),
cleverReader.FromBigInteger("ClientID"),
cleverReader.ToInteger("ModifiedBy"),
cleverReader.ToString("ModifiedByEmployeeName"),
cleverReader.ToDate("Modified"));
}
else
{
note = new ClientNote(
cleverReader.FromBigInteger("NotesID"),
cleverReader.ToDate("Created"),
ActivityType.Parse(cleverReader.ToInteger("ActivityTypeId")),
NoteType.Parse(cleverReader.ToInteger("NoteTypeId")),
parsedNotes,
cleverReader.ToInteger("CreatedBy"),
cleverReader.ToString("EmployeeName"),
cleverReader.FromBigInteger("ClientID"),
cleverReader.ToInteger("ModifiedBy"),
cleverReader.ToString("ModifiedByEmployeeName"),
cleverReader.ToDate("Modified"),
cleverReader.ToString("ClientName"));
}
if (note != null)
{
notes.Add(note);
}
}
}
}
return(notes);
}
public ClientNoteResult(ClientNote clientNote)
{
Id = clientNote.Id;
Note = clientNote.Note;
}
public void SaveClientNote(ClientNote clientNote)
{
ArgumentChecker.ThrowIfNull(clientNote, "clientNote");
notesRepository.InsertClientNote(clientNote);
view.DisplayFeedback();
}
public void Add(ClientNote clientNote)
{
_repository.Add(clientNote);
_uow.Commit();
}
public void Delete(ClientNote clientNote)
{
}
public void Edit(ClientNote clientNote)
{
_repository.Edit(clientNote);
_uow.Commit();
}
public void Delete(ClientNote entity)
{
Repository.Delete(entity);
}
