public SystemEntity GetBySysName(string sysName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT s.* from Systems s ");
strSql.Append("WHERE s.SystemName=@SystemName");
SystemEntity systemEntity = null;
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "SystemName", DbType.String, sysName);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
systemEntity = SystemEntity.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(systemEntity);
}
public List <SystemEntity> GetAllSystems()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * from Systems");
List <SystemEntity> list = new List <SystemEntity>();
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
list.Add(SystemEntity.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(list);
}