public SessionNote SessionNoteModification(string action, int id, string note)
{
SqlParameter[] sqlParms = new SqlParameter[]{
new SqlParameter("@action",action),
new SqlParameter("@id",id),
new SqlParameter("@note",note)
};
var sessionNote = new IGNITE_MODEL.SessionNote.SessionNote();
using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "sp_hick_SessionNote_Modification", sqlParms))
{
while (sqlobj.Read())
{
sessionNote.Id = DBHelper.getInt(sqlobj, "Id");
sessionNote.Date = DBHelper.getDateTime(sqlobj, "Date").ToString("MMMM dd, yyyy");
sessionNote.Category = GetActionTypeString(DBHelper.getInt16(sqlobj, "Category"));
sessionNote.Note = DBHelper.getString(sqlobj, "Note");
sessionNote.StartTime = DBHelper.getDateTime(sqlobj, "StartTime").ToShortTimeString();
sessionNote.EndTime = DBHelper.getDateTime(sqlobj, "EndTime").ToShortTimeString();
TimeSpan totaltime = (DBHelper.getDateTime(sqlobj, "EndTime").Subtract(DBHelper.getDateTime(sqlobj, "StartTime")));
sessionNote.TotalTime = ToLongString(totaltime);
}
}
return sessionNote;
}
public List<SessionNote> GetSessionNote(string userid,int peerId,int PageIndex,int PageSize)
{
SqlParameter[] sqlParms = new SqlParameter[]{
new SqlParameter("@UserId",userid),
new SqlParameter("@PeerId",peerId)
};
var sessionNoteList = new List<SessionNote>();
using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "sp_hick_GetSessionNote", sqlParms))
{
while (sqlobj.Read())
{
var sessionNote = new IGNITE_MODEL.SessionNote.SessionNote();
sessionNote.Id = DBHelper.getInt(sqlobj, "Id");
sessionNote.Date = DBHelper.getDateTime(sqlobj, "Date").ToString("MMM dd,yyyy");
sessionNote.Category = GetActionTypeString(DBHelper.getInt(sqlobj, "Category"));
sessionNote.Note = DBHelper.getString(sqlobj, "Note");
sessionNote.StartTime = string.Format("{0:hh:mm tt}", DBHelper.getDateTime(sqlobj, "StartTime"));
sessionNote.EndTime = string.Format("{0:hh:mm tt}", DBHelper.getDateTime(sqlobj, "EndTime"));
TimeSpan totaltime = (DBHelper.getDateTime(sqlobj, "EndTime").Subtract(DBHelper.getDateTime(sqlobj, "StartTime")));
sessionNote.TotalTime = ToLongString(totaltime);
sessionNoteList.Add(sessionNote);
}
}
return sessionNoteList;
}