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