public List <ProposalTrackerNoteEntity> GetProposalTrackerNotes(int proposalTrackerId) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT w.*,u.UserName,u.LastName,u.FirstName from ProposalTrackerNote w left join Users u on w.ModifyBy= u.UserID where ProposalTrackerID=@ProposalTrackerID"); strSql.Append(" order by ModifyOn desc"); List <ProposalTrackerNoteEntity> list = new List <ProposalTrackerNoteEntity>(); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString())) { try { db.AddInParameter(dbCommand, "ProposalTrackerID", DbType.Int32, proposalTrackerId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) while (dataReader.Read()) { list.Add(ProposalTrackerNoteEntity.ReaderBind(dataReader)); } } catch (Exception ex) { WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]" , strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message)); return(null); } } return(list); }
public ProposalTrackerNoteEntity Get(int WID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,WID,TID,CreatedOn,CreatedBy from ProposalTrackerRelation "); strSql.Append(" where WID=@WID "); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString())) { db.AddInParameter(dbCommand, "WID", DbType.Int32, WID); ProposalTrackerNoteEntity model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ProposalTrackerNoteEntity.ReaderBind(dataReader); } } return(model); } }