public NoteContent AddNoteContent(NoteContent noteContent) { NoteContentEntity entity = noteContent.ToEntity(); entity.CreateTime = DateTime.Now; entity.DeletedTime = DateTime.Now; entity.IsDeleted = false; this.dbContext.NoteContents.Add(entity); this.dbContext.SaveChanges(); return(entity.ToModel()); }
public List <NoteContent> GetNoteCommentByNoteId(int id) { try { if (id <= 0) { return(null); } DbParameter[] parameters = new DbParameter[] { new SqlParameter() { ParameterName = SpParamsOfNoteContent.Sp_Select_NoteContentByNoteId_NoteId, Value = id } }; using (DataSet dataSet = DbHelper.Instance.RunProcedureGetDataSet(SpNamesOfNoteContent.Sp_Select_NoteContentByNoteId, parameters)) { NoteContentEntity entity = null; List <NoteContent> noteContents = new List <NoteContent>(); if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows != null && dataSet.Tables[0].Rows.Count != 0) { DataRowCollection dataRows = dataSet.Tables[0].Rows; DataColumnCollection dataColumns = dataSet.Tables[0].Columns; foreach (DataRow dataRow in dataRows) { entity = new NoteContentEntity() { Id = (int)dataRow[dataColumns[0]], NoteId = (int)dataRow[dataColumns[1]], Type = (int)dataRow[dataColumns[2]], Content = dataRow[dataColumns[3]].ToString(), CreateTime = (DateTime)dataRow[dataColumns[4]], IsDeleted = (bool)dataRow[dataColumns[5]], DeletedTime = (DateTime)dataRow[dataColumns[6]] }; noteContents.Add(entity.ToModel()); } } return(noteContents); } } catch (Exception ex) { throw ex; } }
public NoteContent GetNoteCommentById(int id) { NoteContentEntity entity = this.dbContext.NoteContents.FirstOrDefault(nc => nc.Id == id); return(entity == null ? null : entity.ToModel()); }