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());
}