public static NoteBrowsedRecord ToModel(this NoteBrowsedRecordEntity entity)
{
return(new NoteBrowsedRecord()
{
Id = entity.Id,
UserId = entity.UserId,
NoteId = entity.NoteId,
BrowsedTime = entity.BrowsedTime
});
}
public NoteBrowsedRecord AddNoteBrowsedRecord(int noteId, int userId)
{
try
{
if (noteId <= 0 || userId <= 0)
{
return(null);
}
DbParameter[] parameters = new DbParameter[]
{
new SqlParameter()
{
ParameterName = SpParamsOfNoteBrowsedRecord.Sp_Add_NoteBrowsedRecord_NoteId,
Value = noteId
},
new SqlParameter()
{
ParameterName = SpParamsOfNoteBrowsedRecord.Sp_Add_NoteBrowsedRecord_UserId,
Value = userId
}
};
using (DataSet dataSet = DbHelper.Instance.RunProcedureGetDataSet(SpNamesOfNoteApprovedRecord.Sp_IUGetApproved_NoteApprovedRecord, parameters))
{
NoteBrowsedRecordEntity entity = null;
if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows != null && dataSet.Tables[0].Rows.Count != 0)
{
DataRow dataRow = dataSet.Tables[0].Rows[0];
DataColumnCollection dataColumns = dataSet.Tables[0].Columns;
entity = new NoteBrowsedRecordEntity()
{
Id = (int)dataRow[dataColumns[0]],
UserId = (int)dataRow[dataColumns[1]],
NoteId = (int)dataRow[dataColumns[2]],
BrowsedTime = (DateTime)dataRow[dataColumns[3]]
};
}
if (entity == null)
{
return(null);
}
return(entity.ToModel());
}
}
catch (Exception ex)
{
throw ex;
}
}
public NoteBrowsedRecord AddNoteBrowsedRecord(int noteId, int userId)
{
NoteBrowsedRecordEntity entity = new NoteBrowsedRecordEntity()
{
BrowsedTime = DateTime.Now,
NoteId = noteId,
UserId = userId,
};
this.dbContext.NoteBrowsedRecords.Add(entity);
this.dbContext.SaveChanges();
return(entity.ToModel());
}
public List <NoteBrowsedRecord> GetNoteBrowsedRecordsByUserId(int userId)
{
try
{
if (userId <= 0)
{
return(null);
}
DbParameter[] parameters = new DbParameter[]
{
new SqlParameter()
{
ParameterName = SpParamsOfNoteBrowsedRecord.Sp_Select_NoteBrowsedRecordsByUserId_UserId,
Value = userId
}
};
using (DataSet dataSet = DbHelper.Instance.RunProcedureGetDataSet(SpNamesOfNoteApprovedRecord.Sp_Select_NoteApprovedRecordsByUserId, parameters))
{
List <NoteBrowsedRecord> noteBrowsedRecords = new List <NoteBrowsedRecord>();
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)
{
NoteBrowsedRecordEntity entity = new NoteBrowsedRecordEntity()
{
Id = (int)dataRow[dataColumns[0]],
UserId = (int)dataRow[dataColumns[1]],
NoteId = (int)dataRow[dataColumns[2]],
BrowsedTime = (DateTime)dataRow[dataColumns[3]]
};
noteBrowsedRecords.Add(entity.ToModel());
}
}
return(noteBrowsedRecords);
}
}
catch (Exception ex)
{
throw ex;
}
}
public NoteBrowsedRecord NoteGetBrowsed(int noteId, int userId)
{
NoteEntity entity = this.dbContext.Notes.FirstOrDefault(n => n.Id == noteId && n.AuthorId == userId);
if (entity != null)
{
entity.LastBrowsedTime = DateTime.Now;
}
NoteBrowsedRecordEntity browsedRecordEntity = new NoteBrowsedRecordEntity()
{
BrowsedTime = DateTime.Now,
NoteId = noteId,
UserId = userId
};
this.dbContext.NoteBrowsedRecords.Add(browsedRecordEntity);
this.dbContext.SaveChanges();
return(browsedRecordEntity.ToModel());
}
