// 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); } }
/// <summary> /// This method returns all notes of a particular client under an IB /// </summary> /// <param name="clientID">clientID</param> /// <param name="introducingBrokerUserID">introducingBrokerUserID</param> /// <returns></returns> public List <ClientNote> GetAllNotesOfClient(int clientID, int introducingBrokerUserID) { try { using (var unitOfWork = new EFUnitOfWork()) { var clientNoteRepo = new ClientNoteRepository(new EFRepository <ClientNote>(), unitOfWork); ObjectSet <ClientNote> clientNoteObjSet = ((CurrentDeskClientsEntities)clientNoteRepo.Repository.UnitOfWork.Context).ClientNotes; return(clientNoteObjSet.Where(note => note.FK_ClientID == clientID && note.FK_IntroducingBrokerUserID == introducingBrokerUserID).OrderByDescending(note => note.Timestamp).ToList()); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); throw; } }