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