public List <C_Ftp> GetEntities(EnmFtp type)
{
SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int) };
parms[0].Value = (int)type;
var entities = new List <C_Ftp>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_FTP_Repository_GetFTPInType, parms)) {
while (rdr.Read())
{
var entity = new C_Ftp();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = SqlTypeConverter.DBNullFtpHandler(rdr["Type"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.User = SqlTypeConverter.DBNullStringHandler(rdr["User"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]);
entity.Directory = SqlTypeConverter.DBNullStringHandler(rdr["Directory"]);
entity.Remark = SqlTypeConverter.DBNullStringHandler(rdr["Remark"]);
entities.Add(entity);
}
}
return(entities);
}
public List <C_Ftp> GetFtps(EnmFtp type)
{
return(_repository.GetEntities(type));
}
