Exemplo n.º 1
0
 public ObservationNoteVm(ObservationNote note)
 {
     Id            = note.Id;
     Content       = note.Content;
     IsImportant   = note.IsImportant;
     ObservationId = note.ObservationId;
 }
Exemplo n.º 2
0
 public static ObservationNote GetObservationNoteByID(int id)
 {
     ObservationNote observationNote = new ObservationNote();
     SqlObservationNoteProvider sqlObservationNoteProvider = new SqlObservationNoteProvider();
     observationNote = sqlObservationNoteProvider.GetObservationNoteByID(id);
     return observationNote;
 }
        public void ObservationNoteDeleteCommandHandler_Handle()
        {
            var user            = FakeObjects.TestUserWithId();
            var observation     = FakeObjects.TestObservationWithId();
            var observationNote = FakeObjects.TestObservationNoteWithId();

            ObservationNote deletedTeam = null;

            var command = new ObservationNoteDeleteCommand()
            {
                Id     = observationNote.Id,
                UserId = user.Id
            };

            using (var session = _store.OpenSession())
            {
                session.Store(user);
                session.Store(observation);
                session.Store(observationNote);

                var commandHandler = new ObservationNoteDeleteCommandHandler(session);

                commandHandler.Handle(command);

                session.SaveChanges();

                deletedTeam = session.Load <ObservationNote>(observationNote.Id);
            }

            Assert.IsNull(deletedTeam);
        }
Exemplo n.º 4
0
    public static ObservationNote GetObservationNoteByID(int id)
    {
        ObservationNote            observationNote            = new ObservationNote();
        SqlObservationNoteProvider sqlObservationNoteProvider = new SqlObservationNoteProvider();

        observationNote = sqlObservationNoteProvider.GetObservationNoteByID(id);
        return(observationNote);
    }
Exemplo n.º 5
0
        public int UpdateNote(ObservationNote note)
        {
            var newNote = _context.ObservationNotes.Find(note.Id);

            newNote.IsImportant           = note.IsImportant;
            newNote.Content               = note.Content;
            _context.Entry(newNote).State = EntityState.Modified;
            _context.SaveChanges();
            return(newNote.Id);
        }
Exemplo n.º 6
0
        public void ObservationNote_UpdateDetails()
        {
            var testObservationNote = new ObservationNote(
                FakeObjects.TestUser(),
                FakeObjects.TestObservationWithId(),
                FakeValues.CommonName,
                FakeValues.ScientificName,
                FakeValues.Taxonomy,
                FakeValues.Tags,
                new Dictionary <string, string>()
            {
                { "a", "b" }
            },
                new Dictionary <string, string>()
            {
                { "c", "d" }
            },
                FakeValues.CreatedDateTime);

            var tagList = new List <string>();

            tagList.AddRange(FakeValues.Tags);
            tagList.Add(additionalString);

            testObservationNote.UpdateDetails(
                FakeObjects.TestUser(),
                FakeValues.CommonName.AppendWith(additionalString),
                FakeValues.ScientificName.AppendWith(additionalString),
                FakeValues.Taxonomy.AppendWith(additionalString),
                tagList,
                new Dictionary <string, string>()
            {
                { "e", "f" }
            },
                new Dictionary <string, string>()
            {
                { "g", "h" }
            }
                );

            Assert.AreEqual(testObservationNote.CommonName, FakeValues.CommonName.AppendWith(additionalString));
            Assert.AreEqual(testObservationNote.ScientificName, FakeValues.ScientificName.AppendWith(additionalString));
            Assert.AreEqual(testObservationNote.Taxonomy, FakeValues.Taxonomy.AppendWith(additionalString));
            Assert.AreEqual(testObservationNote.Tags, tagList);
            Assert.AreEqual(testObservationNote.Descriptions, new Dictionary <string, string>()
            {
                { "e", "f" }
            });
            Assert.AreEqual(testObservationNote.References, new Dictionary <string, string>()
            {
                { "g", "h" }
            });
        }
Exemplo n.º 7
0
        public void ObservationNoteCreateCommandHandler_Handle()
        {
            var user            = FakeObjects.TestUserWithId();
            var observation     = FakeObjects.TestObservationWithId();
            var createdDateTime = DateTime.UtcNow;

            ObservationNote newValue = null;

            var command = new ObservationNoteCreateCommand()
            {
                UserId       = user.Id,
                CommonName   = FakeValues.CommonName,
                Descriptions = new Dictionary <string, string> {
                    { FakeValues.Description, FakeValues.Description }
                },
                Notes         = FakeValues.Notes,
                ObservationId = observation.Id,
                References    = new Dictionary <string, string> {
                    { FakeValues.Description, FakeValues.Description }
                },
                ScientificName = FakeValues.ScientificName,
                NotedOn        = createdDateTime,
                Tags           = FakeValues.Tags,
                Taxonomy       = FakeValues.Taxonomy
            };

            using (var session = _store.OpenSession())
            {
                session.Store(user);
                session.Store(observation);
                session.SaveChanges();

                var commandHandler = new ObservationNoteCreateCommandHandler(session);
                commandHandler.Handle(command);
                session.SaveChanges();

                newValue = session
                           .Query <ObservationNote>()
                           .SingleOrDefault(x => x.CreatedOn == createdDateTime);
            }

            Assert.IsNotNull(newValue);
            Assert.AreEqual(command.CommonName, newValue.CommonName);
            Assert.AreEqual(command.Descriptions, newValue.Descriptions);
            Assert.AreEqual(command.References, newValue.References);
            Assert.AreEqual(command.ScientificName, newValue.ScientificName);
            Assert.AreEqual(command.NotedOn, newValue.CreatedOn);
            Assert.AreEqual(command.Tags, newValue.Tags);
            Assert.AreEqual(command.Taxonomy, newValue.Taxonomy);
            //Assert.AreEqual(observation.DenormalisedObservationReference(), newValue.Observation);
        }
    private void showObservationNoteData()
    {
        ObservationNote observationNote = new ObservationNote();

        observationNote = ObservationNoteManager.GetObservationNoteByID(Int32.Parse(Request.QueryString["observationNoteID"]));

        txtNote.Text = observationNote.Note;
        ddlResident.SelectedValue = observationNote.ResidentID.ToString();
        txtAddeBy.Text            = observationNote.AddeBy.ToString();
        txtExtraField1.Text       = observationNote.ExtraField1;
        txtExtraField2.Text       = observationNote.ExtraField2;
        txtExtraField3.Text       = observationNote.ExtraField3;
        txtExtraField4.Text       = observationNote.ExtraField4;
        txtExtraField5.Text       = observationNote.ExtraField5;
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        ObservationNote observationNote = new ObservationNote();

        observationNote.Note        = txtNote.Text;
        observationNote.ResidentID  = Int32.Parse(ddlResident.SelectedValue);
        observationNote.AddeBy      = Int32.Parse(txtAddeBy.Text);
        observationNote.AddedDate   = DateTime.Now;
        observationNote.ExtraField1 = txtExtraField1.Text;
        observationNote.ExtraField2 = txtExtraField2.Text;
        observationNote.ExtraField3 = txtExtraField3.Text;
        observationNote.ExtraField4 = txtExtraField4.Text;
        observationNote.ExtraField5 = txtExtraField5.Text;
        int resutl = ObservationNoteManager.InsertObservationNote(observationNote);

        Response.Redirect("AdminObservationNoteDisplay.aspx");
    }
Exemplo n.º 10
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        ObservationNote observationNote = new ObservationNote();

        observationNote.Note        = txtObservationOrComment.Text;
        observationNote.ResidentID  = Int32.Parse(Request.QueryString["ResidentID"]);
        observationNote.AddeBy      = getLogin().LoginID;
        observationNote.AddedDate   = DateTime.Parse(DateTime.Parse(txtDate.Text).ToString("yyyy-MM-dd") + " " + txtTakingTime.Text);
        observationNote.ExtraField1 = txtMadeBy.Text;
        observationNote.ExtraField2 = ddlObservationType.SelectedValue;
        observationNote.ExtraField3 = "";
        observationNote.ExtraField4 = "";
        observationNote.ExtraField5 = "";
        int resutl = ObservationNoteManager.InsertObservationNote(observationNote);

        loadGrid();
    }
        public Observation UpdateObservationDbFromObservationVm(Observation observation, ObservationVm observationVm)
        {
            observation.CycleId       = _observationRepository.UpdateCycleId(observationVm.ParentChartId, observationVm.NumberOfParentCycleInChart);
            observation.NumberInCycle = observationVm.NumberInCycle;
            observation.Marker        = _observationRepository.GetMarkerByValue(observationVm.Marker).FirstOrDefault();
            observation.PeakDayNumber = observationVm.PeakDayNumber;
            observation.Date          = observationVm.Date;
            observation.Letter        = _observationRepository.GetLetterByValue(observationVm.Letter).FirstOrDefault();
            observation.IsB           = observationVm.IsB;
            observation.NumTimes      = _observationRepository.GetNumTimesByValue(observationVm.NumTimes).FirstOrDefault();
            observation.Cipher        = _observationRepository.GetCipherByValue(observationVm.Cipher).FirstOrDefault();
            observation.CipherCd      = _observationRepository.GetCipherCdByValue(observationVm.CipherCd).FirstOrDefault();
            //comments. notes, pictures
            //public int? CommentId { get; set; }
            //public virtual IList<Comment> Comments { get; set; }

            foreach (var item in observationVm.Notes)
            {
                ObservationNote note = new ObservationNote()
                {
                    Id            = item.Id,
                    IsImportant   = item.IsImportant,
                    Content       = item.Content,
                    ObservationId = item.ObservationId
                };

                if (item.Content != "")
                {
                    if (item.Id != 0)
                    {
                        _observationRepository.UpdateNote(note);
                    }
                    else
                    {
                        _observationRepository.AddNote(note);
                    }
                }
                else if (item.Id != 0)
                {
                    _observationRepository.DeleteNote(note);
                }
            }

            return(observation);
        }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        ObservationNote observationNote = new ObservationNote();

        observationNote = ObservationNoteManager.GetObservationNoteByID(Int32.Parse(Request.QueryString["observationNoteID"]));
        ObservationNote tempObservationNote = new ObservationNote();

        tempObservationNote.ObservationNoteID = observationNote.ObservationNoteID;

        tempObservationNote.Note        = txtNote.Text;
        tempObservationNote.ResidentID  = Int32.Parse(ddlResident.SelectedValue);
        tempObservationNote.AddeBy      = Int32.Parse(txtAddeBy.Text);
        tempObservationNote.AddedDate   = DateTime.Now;
        tempObservationNote.ExtraField1 = txtExtraField1.Text;
        tempObservationNote.ExtraField2 = txtExtraField2.Text;
        tempObservationNote.ExtraField3 = txtExtraField3.Text;
        tempObservationNote.ExtraField4 = txtExtraField4.Text;
        tempObservationNote.ExtraField5 = txtExtraField5.Text;
        bool result = ObservationNoteManager.UpdateObservationNote(tempObservationNote);

        Response.Redirect("AdminObservationNoteDisplay.aspx");
    }
Exemplo n.º 13
0
    public bool UpdateObservationNote(ObservationNote observationNote)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_UpdateObservationNote", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ObservationNoteID", SqlDbType.Int).Value = observationNote.ObservationNoteID;
            cmd.Parameters.Add("@Note", SqlDbType.NText).Value            = observationNote.Note;
            cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value        = observationNote.ResidentID;
            cmd.Parameters.Add("@AddeBy", SqlDbType.Int).Value            = observationNote.AddeBy;
            cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value    = observationNote.AddedDate;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value  = observationNote.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value  = observationNote.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value  = observationNote.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value  = observationNote.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value  = observationNote.ExtraField5;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return(result == 1);
        }
    }
Exemplo n.º 14
0
 public ObservationNote GetObservationNoteFromReader(IDataReader reader)
 {
     try
     {
         ObservationNote observationNote = new ObservationNote
                                           (
             (int)reader["ObservationNoteID"],
             reader["Note"].ToString(),
             (int)reader["ResidentID"],
             (int)reader["AddeBy"],
             (DateTime)reader["AddedDate"],
             reader["ExtraField1"].ToString(),
             reader["ExtraField2"].ToString(),
             reader["ExtraField3"].ToString(),
             reader["ExtraField4"].ToString(),
             reader["ExtraField5"].ToString()
                                           );
         return(observationNote);
     }
     catch (Exception ex)
     {
         return(null);
     }
 }
Exemplo n.º 15
0
        public void ObservationNote_Constructor()
        {
            var testObservation = new ObservationNote(
                FakeObjects.TestUserWithId(),
                FakeObjects.TestObservationWithId(),
                FakeValues.CommonName,
                FakeValues.ScientificName,
                FakeValues.Taxonomy,
                FakeValues.Tags,
                new Dictionary <string, string>()
            {
                { "a", "b" }
            },
                new Dictionary <string, string>()
            {
                { "c", "d" }
            },
                FakeValues.CreatedDateTime);

            Assert.AreEqual(testObservation.CommonName, FakeValues.CommonName);
            Assert.AreEqual(testObservation.ScientificName, FakeValues.ScientificName);
            Assert.AreEqual(testObservation.Taxonomy, FakeValues.Taxonomy);
            Assert.AreEqual(testObservation.Tags, FakeValues.Tags);
            Assert.AreEqual(testObservation.Observation.Id, FakeObjects.TestObservationWithId().Id);
            Assert.AreEqual(testObservation.User.FirstName, FakeObjects.TestUserWithId().FirstName);
            Assert.AreEqual(testObservation.User.LastName, FakeObjects.TestUserWithId().LastName);
            Assert.AreEqual(testObservation.User.Id, FakeObjects.TestUserWithId().Id);
            Assert.AreEqual(testObservation.Descriptions, new Dictionary <string, string>()
            {
                { "a", "b" }
            });
            Assert.AreEqual(testObservation.References, new Dictionary <string, string>()
            {
                { "c", "d" }
            });
        }
Exemplo n.º 16
0
 public static bool UpdateObservationNote(ObservationNote observationNote)
 {
     SqlObservationNoteProvider sqlObservationNoteProvider = new SqlObservationNoteProvider();
     return sqlObservationNoteProvider.UpdateObservationNote(observationNote);
 }
Exemplo n.º 17
0
 public static int InsertObservationNote(ObservationNote observationNote)
 {
     SqlObservationNoteProvider sqlObservationNoteProvider = new SqlObservationNoteProvider();
     return sqlObservationNoteProvider.InsertObservationNote(observationNote);
 }
Exemplo n.º 18
0
 public int AddNote(ObservationNote note)
 {
     _context.ObservationNotes.Add(note);
     _context.SaveChanges();
     return(note.Id);
 }
Exemplo n.º 19
0
    public bool UpdateObservationNote(ObservationNote observationNote)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("AL_UpdateObservationNote", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ObservationNoteID", SqlDbType.Int).Value = observationNote.ObservationNoteID;
            cmd.Parameters.Add("@Note", SqlDbType.NText).Value = observationNote.Note;
            cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value = observationNote.ResidentID;
            cmd.Parameters.Add("@AddeBy", SqlDbType.Int).Value = observationNote.AddeBy;
            cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = observationNote.AddedDate;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = observationNote.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = observationNote.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = observationNote.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = observationNote.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = observationNote.ExtraField5;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }
Exemplo n.º 20
0
 public ObservationNote GetObservationNoteFromReader(IDataReader reader)
 {
     try
     {
         ObservationNote observationNote = new ObservationNote
             (
                 (int)reader["ObservationNoteID"],
                 reader["Note"].ToString(),
                 (int)reader["ResidentID"],
                 (int)reader["AddeBy"],
                 (DateTime)reader["AddedDate"],
                 reader["ExtraField1"].ToString(),
                 reader["ExtraField2"].ToString(),
                 reader["ExtraField3"].ToString(),
                 reader["ExtraField4"].ToString(),
                 reader["ExtraField5"].ToString()
             );
          return observationNote;
     }
     catch(Exception ex)
     {
         return null;
     }
 }
Exemplo n.º 21
0
    public static bool UpdateObservationNote(ObservationNote observationNote)
    {
        SqlObservationNoteProvider sqlObservationNoteProvider = new SqlObservationNoteProvider();

        return(sqlObservationNoteProvider.UpdateObservationNote(observationNote));
    }
Exemplo n.º 22
0
    public static int InsertObservationNote(ObservationNote observationNote)
    {
        SqlObservationNoteProvider sqlObservationNoteProvider = new SqlObservationNoteProvider();

        return(sqlObservationNoteProvider.InsertObservationNote(observationNote));
    }
Exemplo n.º 23
0
 public bool DeleteNote(ObservationNote note)
 {
     _context.ObservationNotes.Remove(note);
     _context.SaveChanges();
     return(true);
 }